HR Attrition Analysis

Key Highlights & Insights:

Attrition Rate: 16%—higher than the average rate across industries (10-11%).

By Job Role: Sales Representatives face the highest attrition at 40%, followed

by Laboratory Technicians.

By Department: Research & Development has the most alarming attrition rate at 56%, raising significant concerns.

Education Factor: Employees with a Bachelor's degree leave the most, contributing to 41% of attrition cases.

Work-Life Balance: Low work-life balance correlates strongly with attrition, but surprisingly, those with very high work-life balance also tend to leave—why?

Demographics:

Average attrition age: 33-34 years.

Single males (27%) and single females (24%) are more likely to leave than their married counterparts (dropping to 11%-13%).

Attrition decreases significantly after employees turn 31 and plateaus after 10 years at the company.

Data Modeling: To ensure efficient analysis, I implemented a star schema:

Created 7 dimensions (e.g., Job Role, Business Travel, Department, Education, etc.).

Built a centralized Fact Table containing key metrics like attrition rates, employee demographics, and performance data. This model not only optimized data queries but also ensured clarity and ease of navigation.