This project analyzes employee churn data using Excel to uncover insights about why employees leave an organization.
- The dataset contains 14 columns including employee age, tenure, credit score, geography, balance, and whether they exited the organization.
What is employee churn?
Employee churn is the movement of people out of and into your workforce. As people leave your business due to attrition and turnover, your overall headcount is reduced. And as you hire replacements for workers lost to turnover, your overall headcount climbs again. That disruption in workforce numbers is employee churn.
Reduce churn and increase employee retention
- Understanding the problem statement
- Data collection
- Data cleaning
- Analyzing the data
- Visualizing the data
- Dashboard creation
- Germany region has the highest churn rate.
- Inactive employees are 2x more likely to churn.
- Those with only 1 product tend to leave more.
- Employees aged 41–50 show the highest churn compared to other age groups.
- Employees with 1 year of tenure have consistent churn levels.
- Female employees have a higher churn rate compared to male employees.
- Consider implementing supportive policies like hybrid work, leadership mentoring for women.
- Offer growth opportunities.
- Introduce flexible work policies, leadership roles to retain experienced groups.
- Boost engagement via recognition programs, feedback targeting inactive people.
- Train and involve employees in multiple tools or roles to boost value and satisfaction.
- Investigate region-specific HR policies. Use localized employee engagement programs to reduce churn.
- Microsoft Excel
- Pivot Tables
- Charts & Dashboards
The project includes a detailed PDF report and dashboard for HR decision-making.