HR Attrition Analysis is an interactive Power BI dashboard designed to analyze employee turnover trends and identify key factors contributing to attrition within an organization.
The dashboard enables HR teams and management to make data-driven decisions to improve employee retention and workforce planning.
Employee attrition leads to:
- Increased hiring and training costs
- Loss of experienced talent
- Reduced productivity
- Workforce instability
This dashboard helps identify:
- Which departments have high attrition
- Which job roles are most affected
- Whether salary, age, or experience impacts attrition
- Gender-based attrition distribution
The dashboard includes the following major metrics:
- Total Attrition Count
- Attrition Rate
- Average Age
- Average Salary
- Total Employees
- Years at Company
- HR
- Research & Development
- Sales
- Department-wise attrition comparison
- Attrition count by Male and Female employees
- Attrition distribution across different education backgrounds
- Sum of Age by Attrition (Yes/No comparison)
- Attrition count by Job Role
- Detailed job-role-wise breakdown table
- Average Salary comparison (Attrition vs Non-Attrition)
- Years at Company comparison by attrition status
- Power BI Desktop
- Power Query (Data Cleaning & Transformation)
- DAX (Data Analysis Expressions)
- Interactive Visualizations
- KPI Cards & Slicers
The dataset used for this project can be downloaded below:
HR_Attrition_Analysis.pbix
- Certain job roles show significantly higher attrition
- Employees with fewer years at company show higher turnover
- Salary differences influence attrition trends
- R&D and Sales departments show notable attrition concentration
- Gender-based distribution provides additional workforce insights
- Helps HR identify high-risk employee segments
- Supports retention strategy development
- Enables workforce cost optimization
- Improves strategic HR planning
- Provides leadership-level workforce visibility
- Predictive attrition model using Machine Learning
- Drill-through employee-level analysis
- Real-time HR database integration
- Advanced DAX KPI benchmarking
- Attrition forecasting dashboard
Soni Data Analyst | Business Intelligence Enthusiast
