HR scenario: Analyze hiring practices

Download scenario guide
Available with: Copilot for Microsoft 365 Scenario level:

KPIs impacted

Cost per hire

Value benefit

Cost savings

Employee experience

Using Copilot to analyze hiring practices

1. Connect data sources

Prompt Copilot to summarize relevant hiring insights from data sources linked using Copilot Studio plug-ins such as applicant tracking systems, LinkedIn, HR insights, and Power BI.

Microsoft Copilot icon


Copilot Studio icon

Copilot Studio

Use Copilot to rapidly locate relevant data which indicates and impacts the hiring pipeline.

2. Analyze data

Analyze data, summarize findings, and provide candidate insights, pipeline, capacity, and hire quality.

Excel icon

Copilot in Excel

What is the average of “Time to hire”?

3. Generate reports

Create reporting and visualizations to better understand the hiring pipeline and make data-driven decisions.

Excel icon

Copilot in Excel

To better articulate the data, highlight the cells yellow where “Time to hire” exceeds 60 days.

4. Collaborate with team

Schedule a meeting to present the report, insights, and to gather feedback.

Microsoft Teams icon

Copilot in Teams

“Generate meeting notes” after the call to capture key topics and action items.

5. Track progress

Track the progress of the hiring pipeline.

Excel icon

Copilot in Excel

In addition to “What is the average of ‘Time to hire’?”, monitor “What is the average ‘Candidate Satisfaction’?” to compare the impact of hiring process changes.

6. Improve hiring pipeline reviews

Based on the impact of the actions, adjust approach and continue to iterate.

Microsoft Loop icon

Copilot in Loop

Brainstorm ideas to improve the hiring pipelines process and ask colleagues to contribute and provide feedback in Loop.

1Access Copilot at or the Microsoft Copilot mobile app and set toggle to “Web”
2Access Copilot at, the Microsoft Copilot mobile app, or the Copilot app in Teams, and set toggle to “Work”