This Excel-based interactive dashboard provides an in-depth analysis of employee demographics and attrition data. It offers key insights into workforce distribution, attrition trends, salary analysis, and job roles, helping organizations understand their employee dynamics better.
- Employee Count by Age Group: A bar chart displaying the distribution of employees across various age ranges.
- Employee Count by Department: A pie chart visualizing the proportion of employees in departments such as Human Resources, Research & Development, and Sales.
- Employee Travel Status: A donut chart depicting employees' travel frequency, including categories like non-travelers and frequent travelers.
- Employee Attrition Rate: A visual breakdown of employees who have left the company versus those who stayed.
- Gender Distribution: A pie chart displaying the ratio of male to female employees.
- Salary Analysis: Insights into total company salaries, average employee salary, and salary versus education level.
- Job Role Distribution: A bar chart showing the employee count in various job roles, such as Sales Executive, Research Scientist, and Manager.
- Employee Count by Education Field: A bar chart analyzing the number of employees across different education fields, including Life Sciences, Medical, and Marketing.
- Interactive Slicers: The dashboard includes slicers for filtering by department, gender, age group, and attrition status, enabling users to interact with the data and uncover specific insights.
The dataset used in this project is sourced from Kaggle: HR Dataset.