Dashboard case study
HR Attrition & Workforce Dashboard
A Power BI people-analytics sample for headcount, attrition rate, tenure, pay, and the drivers behind who leaves.
Business question
Where are we losing employees, and which roles, teams, and pay bands carry the highest attrition risk?
At a glance
KPIs
Headcount, Attrition rate %, Avg tenure, Avg monthly income, Avg job satisfaction, Overtime %
Filters
Department, Job role, Age band, Gender, Overtime
Tools
Power BI, DAX, Power Query, Data modelling, People analytics
What it shows
Single-page people-analytics report with KPI cards, a department and job-role attrition matrix, an attrition decomposition tree, and an attrition-by-tenure-band cohort view.
- Headcount, attrition, tenure, income, and satisfaction KPI cards
- Department and job-role attrition matrix with status flags
- Attrition decomposition tree by department, overtime, and satisfaction
Main insights
Clear people-analytics view that moves from a single attrition number to the teams, tenure, and drivers behind it.
- Attrition spikes in the first one to two years of tenure
- Overtime is one of the strongest attrition drivers
- A small team can carry a high attrition rate worth protecting
Connects attrition with the departments, roles, tenure, and drivers that explain it, so retention effort goes where the risk actually is.
Discuss a dashboard