Back to projects
🧑💼
HR Analytics Dashboard
Turning a static HR spreadsheet into a living retention-risk dashboard.
Power BIExcelPower Query
View repositoryProblem Statement
HR was manually recalculating attrition and headcount metrics every week, with no visibility into which departments were at risk.
Dataset Overview
HR records for 200+ employees spanning tenure, department, performance rating, and exit status.
Cleaning Process
- Normalized department and job-title naming conventions
- Flagged and resolved missing tenure data
- Automated a weekly refresh pipeline replacing manual recalculation
SQL / Analysis Queries
Attrition rate DAX measure segmented by department and tenure band
Rolling 12-month headcount trend calculation
Business Insights
- Attrition concentrated in employees with under 18 months tenure
- One department showed 2x the attrition rate of the company average
Results
Saved roughly 3 hours of manual reporting every week
Gave leadership an early-warning view of retention risk by department