Power BI dashboards for HR and people teams
An HR dashboard shows who is leaving, how fast roles are filled, and whether payroll is right and compliant. Below are the three screens we have designed. We build them on your own HR and payroll data.
Request the sample pack
What it answers
Three questions every people team is asked
Each screen starts from a question. The figures on each page are the ones that help the people team act that week.
- Are we growing, and who is leaving?Workforce numbers, attrition, net hiring and payroll cost per person, with attrition by month and by department, and the reasons people leave.
- How quickly are we filling roles?Open positions, time to hire, offer acceptance and cost per hire, with the hiring funnel from application to joining, by source.
- Is payroll right, and are we compliant?Leave days, absence and overtime cost by department, statutory contributions with a compliance tracker, and payroll cost by month.
The screens
Power BI HR dashboard screens
Three screens for the people team. Open one to see it full size. Each comes with filters and drill-through, and we adjust measures, filters and branding to your business, so a screen is a starting point and not a fixed product.
3 dashboards
Every number on these screens is sample data from a fictional retailer. No client data is shown. Your own logo replaces the AscenWork mark at the top left of each report.
How we define the main hr analytics measures
A dashboard is only trusted if everyone reads the same number. We agree these definitions with you before we build, and write them down at handover.
| Measure | How we calculate it | What to agree first |
|---|---|---|
| Attrition rate | Leavers in the period divided by the average workforce, shown as a percentage. | Whether voluntary and involuntary leavers are shown together or apart. |
| Net hiring | Joiners in the period minus leavers in the period. | Whether transfers in and out of a department are counted. |
| Time to hire | Days from an approved requisition to the accepted offer. | The start and end events in your recruitment system. |
| Offer acceptance rate | Offers accepted divided by offers made. | Whether withdrawn offers are counted as declined. |
| Absence rate | Days absent divided by working days in the period. | Which absence types are included, such as sick leave and unpaid leave. |
| Payroll cost per person | Total payroll cost divided by the average workforce for the period. | Whether bonuses and overtime are included. |
How it works
From these screens to your live dashboard
In a project, the dashboard connects to your HR and payroll data and refreshes on a schedule. You see working pages early, so you react to something real.
Connect
We link your systems and files, and check the data is complete.
Model
We clean and join the data, and agree each measure with you so everyone reads the same number.
Design
We apply your chosen look and your logo to every page, with a phone layout where it is needed.
Go live
The dashboard runs in Power BI with scheduled refresh, filters, drill-through and access by role.
What we connect
Where the data for these dashboards comes from
We confirm the sources on a short scoping call. These are the common ones for this dashboard.
HR system
Your HR records, such as Workday, SAP SuccessFactors or an HR database, or the employee list you keep in Excel today.
Recruitment tracker
Requisitions, candidates, offers and joiners from your applicant tracking system, or the sheet your team keeps.
Payroll
Payroll cost, overtime and statutory contributions from your payroll system, matched to departments.
Leave and attendance
Leave balances, absence records and working days, from your timesheet or attendance system.
Departments and cost centres
The organisation structure, so each measure is drawn for the right manager.
Access by role
Row-level security, so a manager sees their own team and the people team sees everyone. HR data is limited to the people who need it.
Our Power BI work
These screens are one part of what we do on Power BI
The same team builds the data model behind the dashboard, designs the report and keeps it running. Pick the part you need.
Power BI development
Data connections, model, measures, row-level security and scheduled refresh, built in your Power BI.
Power BI consulting
A review of your current reports and data, and a plan before you build.
Power BI designing
Clear, fast report design with a consistent look across every page.
Copilot and AI for Power BI
Ask questions of your data in plain language, with the right guardrails.
Case studies
Power BI projects we have delivered
Power BI job life cycle, exception and debtors reports for a freight forwarder
A set of Power BI reports for a freight forwarding and customs clearing company with many branches. They follow every job from creation to closure and flag exceptions, pending billing, debtors and profit.
A freight forwarding and customs clearing company with many branches and a finance team at head office
Read the case study →Power BI · Energy and renewables
Power BI asset performance dashboards for a renewable energy portfolio
A Power BI report that follows generation, losses, breakdowns and module cleaning across every solar plant in a portfolio, from an executive summary down to the inverter.
A renewable energy company operating several solar plants
Read the case study →Power BI · Retail and consumer goods
Power BI sales dashboards for digital channels and prescription sales
Two Power BI reports that bring sales data from every channel into one view. Digital sales covers partners, marketplaces, website and products, and Rx sales covers prescribers, zones, brands and field teams.
A skincare company selling through digital partners, its own website and prescription channels
Read the case study →Trusted by teams at
Power BI hr analytics dashboard questions
What should an HR dashboard in Power BI show?
Attrition, net hiring, time to hire and payroll cost per person, with the reasons people leave. Start with the decisions the people team takes each month, and show only the figures that support them.
Can it connect to our HR system and payroll?
Usually yes. Power BI connects to many HR systems, databases and Excel files. We confirm the route for your system on a short scoping call and tell you what is easy and what needs extra work.
Who can see employee-level data?
Only the people who need it. With row-level security, a manager sees their own team, and the people team sees the whole organisation. Personal details can be left out of the dashboard altogether.
Are these screens real employee data?
No. Every number is sample data from a fictional retailer, so no employee data is shown. In a project, the same pages run on your own data.
Is the sample pack free?
Yes. The design pack is free, and we email it to you as a PDF. Building dashboards on your own data is a scoped, paid engagement, which we quote after a discovery call.
How do we get a price and a timeline?
Book a free call. We learn your data sources, users and questions, then send a proposal with the scope, the assumptions and the price. Timelines depend on the number of sources and dashboards.
Related
More from our Power BI work
All dashboard templates
Fifteen dashboards by function and industry
HR dashboard examples
Attrition, hiring and workforce measures
Finance dashboards
Cash, receivables and budget screens
Leadership dashboards
CEO view and board pack
Power BI development
Build a dashboard on your own data
Power BI consulting
Review and plan before you build
Power BI designing
Clear, fast report design
Hire Power BI developers
Developers who join your team
Contact