HR Analytics - Attrition Prediction on Power BI, using power query.
HR Analytics & Attrition Prediction Dashboard | Power BI 📌 Project Overview
This project delivers an end-to-end HR Analytics and Attrition Analysis solution using Power BI, designed to support data-driven workforce planning and retention strategies. The solution transforms raw HR data into actionable insights through KPIs, interactive dashboards, and advanced visual analytics.
🎯 Business Objective
Analyze workforce composition and attrition trends
Identify high-risk departments, roles, and demographic segments
Enable leadership to make proactive retention decisions
🗂 Data Source
Raw HR dataset (Excel format)
Includes employee demographics, job roles, education, age, gender, and attrition status
⚙️ ETL & Data Preparation (Power Query)
Imported raw Excel data into Power BI
Removed duplicates and null values
Standardized column names and formats
Created derived columns:
Age Group bands
Attrition indicator
Ensured analytical consistency and performance optimization
📊 KPIs Developed (DAX)
Total Employees
Active Employees
Attrition Count
Attrition Rate (%)
Average Employee Age
All KPIs are dynamic and slicer-driven.
📈 Visualizations
Department-wise Attrition (Pie Chart)
Education Field-wise Attrition (Bar Chart)
Employee Count by Age Group & Gender (Stacked Column Chart)
Job Role vs Job Satisfaction (Matrix)
Attrition by Age & Gender (Donut Charts)
🎛 Slicers & Interactivity
Department
Education Level
Gender
Age Group
All slicers are fully synchronized with KPIs and visuals.
💡 Key Insights
Sales and R&D show higher attrition concentration
Mid-career professionals (25–44) contribute most to attrition volume
Certain education backgrounds exhibit higher churn
Job satisfaction varies significantly by role
🛠 Tools & Technologies
Microsoft Excel
Power BI Desktop
Power Query (ETL)
DAX
🚀 Future Enhancements
Predictive attrition modeling
Time-series attrition trend analysis
Automated refresh using Power BI Service
Abhishek Milwar MBA – Business Analytics Aspiring Business Analyst | BI Developer