This repository contains an Excel dashboard analyzing employee attrition and performance, using the IBM HR Analytics Employee Attrition & Performance dataset from Kaggle. The dataset simulates employee data from IBM, focusing on various demographic and performance factors that influence attrition.
The dashboard provides an in-depth analysis of employee demographics and their relation to attrition rates, helping companies like IBM understand and prepare for potential employee turnover. Key metrics visualized include:
- Age Distribution: The age groups more susceptible to attrition.
- Departmental Breakdown: Identifying which departments face the highest attrition rates.
- Job Role & Satisfaction: Correlating job roles and employee satisfaction with attrition.
- Education & Years at Company: Analyzing how education levels and tenure affect attrition.
- Gender & Marital Status: Impact of personal demographics on attrition likelihood.
The insights provided in this dashboard enable businesses to make informed decisions on employee retention strategies.
IBM_Attrition_Dashboard.xlsx: The Excel file containing the dashboard with various visualizations and analysis on employee attrition.
- Download the Excel file from the repository.
- Open the file using Excel or a compatible spreadsheet software.
- Navigate through the tabs and charts to explore the data and insights.
- Microsoft Excel (or similar software capable of opening
.xlsxfiles).
The dashboard is based on a simulated dataset provided by Kaggle: IBM HR Analytics Employee Attrition & Performance.
This dashboard can be used by HR teams, managers, and analysts to:
- Identify trends in employee attrition.
- Make informed decisions to improve employee retention.
- Develop proactive strategies for high-risk employee groups.
Contributions are welcome! Feel free to open issues or submit pull requests for any suggestions, improvements, or additional features.