This project provides a comprehensive analysis of employee attrition using an interactive dashboard. The dashboard visualizes key HR metrics and insights derived from employee data, enabling organizations to identify trends, potential issues, and opportunities for retention improvement.The HR Attrition Analysis Dashboard presents a visual breakdown of employee attrition patterns across multiple dimensions, helping HR professionals to make data-driven decisions.
Here’s what’s under the hood:
🔹 Power BI – for dashboard creation and data visualization
🔹 DAX (Data Analysis Expressions) – for calculated fields and custom KPIs
🔹 Power Query (M Language) – for transforming raw HR data
🔹 Data Modeling – structured as a star schema for performance and clarity
- Total Employees: 1,470
- Total Attrition: 237
- Attrition Rate: 16%
- Average Age: 37
- Average Salary: 6.5K/month
- Average Tenure: 7 years
- Younger employees in lower-paying roles are most likely to leave
- Low job satisfaction is a big red flag
- Early exits (in Year 1) show onboarding and culture gaps
- Sales & technical teams may need focused retention strategies
Here are some cool things you could add:
- Filters for department, performance rating, and location
- Predictive analytics with Power BI’s AI visuals
- Drill-downs to employee-level data
- Time-based DAX measures to track changes over time
Thanks for checking this out! This dashboard is a great example of how Power BI + DAX + strong data modeling can turn raw HR data into insights that really matter.
Hi, I'm Hemant, a data enthusiast passionate about turning raw data into meaningful business insights.
Let’s connect:
- LinkedIn : LinkedIn Profile
- Email : [email protected]