p_06 · People Analytics
HR Management Analytics
Workforce analytics covering attrition patterns, hiring funnel and headcount trends. Early warning indicators surfaced to HR leadership, 20% attrition reduction.
- SQL
- Power BI
01 / Problem
HR leadership needed to understand what drives attrition and spot it before people leave.
02 / Data
- Employee master data across group companies: status, company, department, designation, reporting manager, location, join and resignation dates.
03 / Approach
- SQL to prepare employee data, a Power BI model with DAX measures.
- Active headcount, FY joiners and leavers, 90 and 30 day joiners and leavers, average tenure of resigned employees.
- Tenure buckets for active and resigned staff, location split, and pages for joined vs resigned and company view.
stage_1
SQL
Employee data
stage_2
Power BI model
DAX measures
stage_3
Report
Attrition drivers
04 / Live dashboard
05 / Business impact
- Early warning indicators surfaced to HR leadership.
- 20% reduction in attrition.
06 / Tools
- SQL
- Power BI
- DAX