HR Dashboard Templates
Ready-made hr dashboards that tracks your people: hiring, attrition, attendance, training and pay in one place. Choose your platform, then your industry.
Choose your platform
Excel
Works offline, opens on any office computer and keeps every formula visible, so you can audit and change it.
Google Sheets
Lives in the cloud, so your whole team sees the same live numbers and you can share it with one link.
Power BI
Handles large data, refreshes from many sources and lets people drill from a yearly total down to a single week.
Looker Studio
Is free, connects straight to Google Sheets, GA4, Google Ads and BigQuery, and shares as a live web link.
The 8 KPIs every hr dashboard should track
| KPI | What it tells you | Formula |
|---|---|---|
| Headcount | Number of active employees at period end. | COUNT of employees with status = Active |
| Attrition rate | Share of employees who left in the period. | Leavers ÷ Average headcount |
| Time to hire | Average days from job opening to offer accepted. | AVERAGE of (Offer accepted − Opening date) |
| Open positions | Roles approved but not yet filled. | COUNT of open requisitions |
| Absenteeism | Share of scheduled work time lost to unplanned absence. | Days absent ÷ Scheduled working days |
| Training hours | Total hours of learning completed. | SUM of training hours logged |
| eNPS | How likely employees are to recommend you as a workplace. | % Promoters − % Detractors |
| Avg salary | Average monthly pay per employee. | Total payroll ÷ Headcount |
HR dashboards by industry
Questions
What is a hr dashboard?
A hr dashboard is a single page that tracks your people: hiring, attrition, attendance, training and pay in one place. It pulls the key hr KPIs, such as headcount, attrition rate, time to hire and open positions, into charts and tables that update when your data changes.
Which tool is best for a hr dashboard?
Excel suits offline work and small teams. Google Sheets is best for sharing and live collaboration. Power BI handles large data and drill-down. Looker Studio is free and great with Google data. Every Kpiloom hr dashboard comes in all four.
Which KPIs should a hr dashboard track?
Start with headcount, attrition rate, time to hire, open positions, absenteeism, training hours, eNPS and avg salary. The table on this page explains each one and how it is calculated.