Start here: what these KPIs are for
HR KPIs help track hiring, retention, workforce productivity, engagement, and people operations.
Use these pages when you need to explain a KPI to a beginner, build it in Excel, validate the inputs, or recreate the same logic in Power BI. Each page includes a plain-English definition, real-life example, Excel formula, DAX measure, interpretation notes, and common mistakes.
HR KPI list
Absenteeism Rate
Absent Days / Available Workdays
👥Cost per Hire
Recruiting Cost / Number of Hires
👥Employee Engagement Score
Total Survey Score / Number of Responses
👥Employee Turnover Rate
Employees Who Left / Average Employees
👥Internal Mobility Rate
Internal Role Changes / Employee Count
👥Offer Acceptance Rate
Accepted Offers / Total Offers
👥Overtime Rate
Overtime Hours / Total Hours
👥Profit per Employee
Profit / Employee Count
👥Promotion Rate
Promotions / Employee Count
👥Revenue per Employee
Revenue / Employee Count
👥Time to Hire
Total Days to Hire / Number of Hires
👥Training Completion Rate
Completed Trainings / Assigned Trainings
How to use these KPI formulas
- Pick one KPI and confirm the business definition.
- Add the inputs to a clean Excel table, one row per period or segment.
- Paste the formula from the KPI page and format the result correctly.
- Add a target or benchmark column so the number has context.
- Link related KPIs together instead of judging one metric alone.