HR KPI cockpit in Power BI — 5 steps

The path

1. 01

   Shape the data

   Split the export into dimensions and facts and generate monthly headcount snapshots.

   From HRIS export to a clean star schemaCompensation analysis · XLSX
2. 02

   Agree the definitions

   Fill in the KPI definition sheet before writing a single measure — this is what saves the project later.

   HR KPI definition sheet · PDF
3. 03

   Write the core measures

   Headcount, FTE, turnover and absence, each with plan and prior-year comparison.

   Turnover cohorts and 12-month survival in DAXTurnover & retention model · PBIX
4. 04

   Lay out the cockpit

   KPI header, drill paths, field parameters and conditional formatting on a single canvas.

   An HR KPI cockpit the board actually readsHR KPI cockpit · PBIX
5. 05

   Protect and publish

   Minimum group size, row-level security by org unit, and a refresh and ownership plan.