An analysis of employee attrition using Key Performance Indicators (KPIs). The report provided structured insight into the factors contributing to attrition. Firstly, Excel pivot table is used to understand the datasheet & find suitable variables for analysis. Then, PowerBI is used to transform the data and a Dashboard is created.
- Attrition count
- Attrition rate
- Average age
- Average salary
- Average years at company
- Attrition by education
- Attrition by age
- Employee satisfaction scores
- Attrition by salary
- Attrition by years at company
- Attrition by job role
An in-depth analysis of employee attrition using KPIs enables organizations to pinpoint the root causes, facilitating data-driven decisions to enhance employee satisfaction and retention.