Employee attrition is one of the most costly HR challenges. This dashboard helps HR teams identify which employees are at risk of leaving and why, enabling proactive retention strategies.
Open the PDF above to view the full dashboard
- Overall attrition rate: 16.1% across the organisation
- Age group 26–35 showed the highest attrition — nearly 3x the company average
- Sales department had the highest turnover rate at ~20%
- Employees with low job satisfaction scores were significantly more likely to leave
- Overtime workers showed 2x higher attrition than non-overtime employees
- Which department has the highest attrition rate?
- What age group is most at risk of leaving?
- Does overtime work correlate with higher attrition?
- How does job satisfaction affect employee retention?
- What is the overall headcount and attrition trend?
| Tool | Usage |
|---|---|
| Power BI Desktop | Dashboard design, visuals, slicers |
| DAX | Calculated measures, attrition rate formula |
| Power Query | Data cleaning and transformation |
| Excel / CSV | Source data |
IBM HR Analytics Employee Attrition Dataset — HR_Analytics.csv (included)
- Download
Hr Analytics Dashboard pdf.pdfto view the dashboard - Or open the source data
HR_Analytics.csvto explore the raw data
Mehul Prajapati — BTech CSE, Dr. Ram Manohar Lohia Awadh University (2026)
Power BI DAX HR Analytics Data Visualization Attrition Analysis