This project is an HR Analytics Dashboard built in Microsoft Excel using a dataset of 1470 employee records. It focuses on analyzing employee attrition and workforce patterns, helping HR teams make informed, data-driven decisions. The dashboard is designed from an MIS reporting perspective, ensuring clarity, accuracy, and usability.
- Analyze employee attrition trends
- Identify key factors impacting employee retention
- Build a structured and interactive MIS dashboard
- Enable quick and efficient reporting
The dataset includes employee-level information such as:
- Demographics (Age, Gender, Marital Status)
- Job details (Department, Role, Job Level)
- Compensation (Monthly Income, Salary Hike)
- Work metrics (Work-Life Balance, Overtime, Experience)
- Performance & satisfaction metrics
- Total Employees: 1470
- Attrition Count
- Attrition Rate (%)
- Active Employees
- Attrition by Department, Job Role, and Education Field
- Attrition by Age Group and Marital Status
- Impact of Overtime and Work-Life Balance on attrition
- Job Satisfaction and performance insights
- Slicers for dynamic filtering (Department, Gender, Education)
- Real-time updates across all visuals
- Microsoft Excel (Advanced)
- Pivot Tables & Pivot Charts
- Slicers & Dashboard Design
- Data Cleaning & Transformation
- MIS Reporting
- Higher attrition observed in specific roles and departments
- Overtime and poor work-life balance strongly linked to attrition
- Employees with lower job satisfaction are more likely to leave
- Early-career employees show higher turnover
Transformed raw HR data into a clean, interactive MIS dashboard that simplifies reporting and supports better decision-making.