The HR Attrition Dashboard project aims to provide a comprehensive view of employee attrition within an organization. This dashboard helps HR professionals and management understand the factors contributing to employee turnover, identify trends, and make data-driven decisions to improve employee retention. The dashboard displays various metrics such as total attrition, attrition by job role, education level, age group, gender, and more.
The dataset used for this project contains detailed records of employees, including their demographic information, job roles, education levels, travel frequency, performance status, and attrition status. This data is crucial for analyzing different dimensions of employee turnover and identifying key factors affecting attrition rates.
- Data Import and Cleaning: Importing the HR data into Excel Power Query, removing unwanted columns, and transforming the data for analysis.
- Dashboard Design: Setting up the dashboard canvas, adding shapes and visual elements, and organizing the layout for intuitive navigation.
- Data Visualization: Creating various charts and graphs to visualize attrition by job role, education level, age group, gender, and other factors.
- Interactive Features: Adding slicers and filters for gender and department to enable users to interact with the dashboard and view specific subsets of data.
- Final Formatting: Ensuring all elements are properly formatted and the dashboard is user-friendly and visually appealing.
-
Total Employees: Displays the total number of employees in the organization.
-
Total Employee Attrition Rate: Shows the percentage of employees who left the organization.
-
Total Active Employees: Indicates the current number of active employees.
-
Attrition by Job Role: Bar chart showing the number of employees who left each job role.
-
Attrition by Education: Bar chart displaying attrition rates based on the highest education level achieved.
-
Attrition by Age Group & Gender: Combination chart showing attrition rates across different age groups, broken down by gender.
-
Attrition by Business Travels: Pie chart illustrating the attrition rates based on travel frequency.
-
Total Attrition by Department: Pie chart showing attrition rates for different departments.
-
Total Attrition by Gender: Bar chart showing the attrition rates separated by gender.
-
Filters by Departments: Interactive filters to view attrition data for specific departments like HR, R&D, and Sales.
-
Gender Filter: Allows users to filter the data to view attrition statistics separately for males and females.
-
Attrition by Performance: Segregates attrition data by high and low performance categories.
-
Attrition by Distance: Displays attrition rates based on the distance employees travel to work, categorized as very far, far, and near-by.
- Data Analysis: Importing, cleaning, and transforming data using Excel Power Query.
- Data Visualization: Creating charts and graphs in Excel to represent various metrics and trends.
- Excel Slicers: Adding interactive slicers for dynamic data filtering.
- Dashboard Design: Structuring and formatting the dashboard for clear and intuitive data presentation.
- Attention to Detail: Ensuring all data is accurately represented and visualizations are correctly formatted.
- Problem-Solving: Identifying key metrics to include in the dashboard and determining the best way to visualize them.
- Communication: Clearly presenting data in a way that is easily understandable for HR professionals and management.
- Project Management: Planning and executing the project steps to deliver a comprehensive and functional dashboard.