A Power BI recruitment dashboard for the whole hiring funnel
A Power BI recruitment dashboard follows every open role from approval to accepted offer and shows where candidates slow down or drop out. Recruiters see their own pipeline, while leaders see time to fill and source quality across the company. The model reads from your applicant tracking system and lives in your own Microsoft tenant, built by our consultants.
- Time to fill by role
- Stage-by-stage conversion
- Source quality compared
Last updated
What does a Power BI recruitment dashboard track?
Hiring looks simple from outside: post a role, pick a person. Inside, it is a funnel with many stages. Candidates apply, pass a screen, interview, receive an offer and accept. Each stage loses people and takes time.
An applicant tracking system records all of this, but its built-in reports rarely compare roles, teams and sources side by side. So a head of talent cannot easily see that one department takes twice as long at the interview stage.
A hiring page puts those comparisons first. It shows open roles by age, the funnel by stage and the sources that produce hires rather than just applicants. As a result, the weekly hiring meeting starts with the same facts for everyone.
Hiring measures with the standard definitions
Teams often blur these terms, so the page states each definition next to the figure.
Time to fill
Count the days from the date a requisition opens to the date a candidate accepts the offer. It measures the process as a whole.
Time to hire
Count the days from a candidate's application to their acceptance. Therefore it measures how fast you move once the right person appears.
Stage conversion
Divide the candidates who reach a stage by those who entered the stage before it. Weak stages then stand out.
Offer acceptance rate
Divide accepted offers by offers made. A falling rate often signals a pay or speed problem.
Source of hire
Count hires, not only applicants, by channel. Because volume and quality differ, both figures appear together.
Open requisition age
Show how long each open role has waited, so old requisitions get a decision instead of drifting.
How should recruitment data sit in a Power BI model?
Two grains matter. One table holds requisitions, with the department, hiring manager, open date and close date. Another holds applications, with the candidate, the source and the current stage. We keep them separate and relate both to shared lookups.
Stage history is the hard part. A snapshot of the current stage cannot tell you how long people waited at each step. So we ask the system for its stage change log and model one row per move. Then time in stage becomes a simple measure. This kind of power bi data modeling matters more than any chart on the page.
Dates need attention as well. An application has an applied date, an offer date and a start date, but only one relationship to the date table can be active. The others stay inactive, and a measure switches to them when needed, as Microsoft's modeling guidance describes.
Mistakes that weaken a Power BI recruitment dashboard
Watch for these six issues, since each one bends the hiring numbers.
- Using time to fill and time to hire as one measure
- Reading only the current stage and losing the history
- Counting one person who applied to three roles as three people
- Leaving canceled requisitions in the averages
- Ranking sources by applicants instead of by hires
- Showing candidate names to people outside the hiring team
How we build a Power BI recruitment dashboard
The build follows four stages, each closed with a demo to your talent team.
Define the funnel
First we list your stages in order and agree which system statuses belong to each. Odd statuses get a home too.
Connect the tracking system
We read requisitions, applications and stage changes through the route your vendor supports, such as an API or an export.
Build measures and test them
Next we write the measures and check a sample of roles by hand against the source system.
Design for recruiters and leaders
Finally recruiters get a working pipeline view, leaders get a summary, and your team gets the file and notes.
Recruitment reporting in Power BI: questions from talent teams
Can a Power BI recruitment dashboard connect to our applicant tracking system?
In most cases, yes. The route depends on the vendor. Some systems expose an API or a reporting database, while others provide scheduled exports. We check the vendor's documentation and Microsoft's connector list before we promise anything. Then we choose the most stable route and set a refresh schedule that suits your hiring pace.
How does the recruitment funnel work in Power BI?
The funnel counts candidates who reached each stage, in order. We base it on the stage change log, so a candidate who skipped a step still counts correctly. Power BI has a funnel chart that fits this view well. However, we also show the same data as a table, because exact counts matter in reviews.
Can hiring managers see only their own roles?
Yes. Row-level security filters requisitions and applications to the manager who owns them. Recruiters see the roles assigned to them, and talent leaders see everything. We keep candidate names off summary pages in any case. So a wider audience can read trends without access to personal details.
Can we report cost per hire?
Yes, if the cost data exists. Agency fees, job board spend and referral bonuses usually sit in the ledger or a spreadsheet. We load them by period and relate them to hires in the same period. Then cost per hire equals total recruiting cost over the number of hires, split by source where the data allows.
How do we get started with your team?
Book the free 30-minute assessment, and we reply within 2 hours. After the call you receive a written scope with fixed contents. Power BI Agency is a division of Sataware Technologies, independent of Microsoft, and serves clients online. We do not resell licenses, so you keep buying those directly.
Let's build your first dashboard together.
Tell us what you report on today. A consultant replies within 2 hours with next steps.
Trusted partners
Microsoft Solutions Partner · AWS Partner
Cloud & AI Platforms
Azure SQL, Microsoft Fabric and the data pipelines behind your reports.
AI Business Solutions
Power BI reporting on your Dynamics 365, Business Central and Power Platform data.
Security
Row-level security and Entra ID sign-in on every report and workspace.
Amazon Web Services
Power BI on your AWS data, with connectors for Redshift, Athena and S3.