PythonPower BIDAXPower QueryFigma
HR Analytics — Employee Attrition & Performance
Built an end-to-end HR analytics solution to help management understand turnover drivers and identify high-risk departments.
📊 70% of attrition in first 5 years
Dataset
IBM HR Analytics dataset — 1,470 employee records across 35 attributes covering demographics, role, compensation, satisfaction, and attrition flags.
Methodology
- 1Data cleaning with Pandas: outlier detection on MonthlyIncome and TotalWorkingYears.
- 2Feature engineering: Age Groups, Salary Bands, Attrition Rate %.
- 3Multi-page Power BI dashboard with custom DAX measures and cross-filtering slicers.
- 4UI layout pre-designed in Figma for executive readability.
Final Outcome
Sales department carried the highest attrition pressure. 70%+ of resignations were in employees' first 5 years — enabling targeted early-retention programs.
Skills Used
PandasNumPyPower BIDAXPower QueryFigmaEDA