Developed an interactive HR attrition analysis dashboard in Microsoft Excel using KPIs, PivotTables, slicers, and dynamic visualizations to identify workforce attrition trends, high-risk segments, and key retention drivers across multiple employee dimensions.
This project focuses on analyzing employee attrition using an interactive Excel-based HR Analytics Dashboard built on the IBM HR Analytics Attrition Dataset sourced from Kaggle.
Dataset source: https://www.kaggle.com/datasets/pavansubhasht/ibm-hr-analytics-attrition-dataset
The dashboard is designed to help HR teams and management identify attrition drivers, high-risk employee segments, and workforce patterns using KPIs, PivotTables, slicers, and dynamic charts. The analysis explores attrition across departments, job roles, education fields, job levels, tenure bands, overtime status, and gender to support data-driven retention strategies.
- Measure and monitor overall employee attrition
- Identify departments and job roles with high attrition risk
- Analyze attrition patterns by education field, job level, and tenure
- Evaluate the impact of overtime and gender on attrition
- Provide leadership-ready KPIs for quick decision-making
The dashboard includes the following KPI cards:
- Total Employees
- Attrition Rate (%)
- Average Monthly Income
- Average Years at Company
These KPIs dynamically update based on slicer selections.
- What is the attrition rate across different departments?
- Which job roles experience the highest and lowest attrition?
- Which education fields contribute most to overall attrition?
- Which Gender × Department combination shows the highest attrition risk?
- How does attrition vary by job level?
- How does employee tenure (Years at Company) impact attrition?
- Is attrition higher among employees working overtime?
- Which Education Field × Job Level combination is most attrition-prone?
- Microsoft Excel
- PivotTables & PivotCharts
- Helper columns using
GETPIVOTDATA - Slicers for interactivity
- Conditional formatting (heatmaps)
- KPI cards & dynamic charts
- Department-wise Attrition (Bar Chart)
- Attrition by Job Role (Horizontal Bar Chart)
- Attrition by Education Field (Column Chart)
- Gender × Department Attrition (Heatmap)
- Attrition by Job Level (Line Chart)
- Attrition by Tenure Band (Line Chart)
- Attrition by OverTime (Column / Pie Chart)
- Education Field × Job Level Attrition (Matrix Heatmap)
- Attrition is significantly higher in certain job roles and lower job levels
- Employees working overtime show a noticeably higher attrition rate
- Early-tenure employees contribute most to overall attrition
- Specific education field and job level combinations represent high-risk segments
(Insights may vary based on slicer selection.)
- HR_Attrition_Dashboard.xlsx → Interactive Excel dashboard
- dashboard_screenshot.png → Dashboard preview
- README.md → Project documentation
- Download the Excel file from this repository
- Open it in Microsoft Excel (Desktop version recommended)
- Use slicers (Department, JobLevel, OverTime, EducationField) to interact with the dashboard
- Analyze KPI changes and visual trends dynamically
Aniket Gund
Designed as part of a hands-on HR analytics and Excel dashboarding project to demonstrate practical data analysis and business intelligence skills.