Employee-Attrition

XYZ Company is currently facing a significant challenge with a 15% annual employee attrition rate, impacting various facets of its operations. To address this issue, a comprehensive HR analytics project has been initiated to understand the underlying reasons behind employee departures and to formulate effective retention strategies.

Details of Data

1. EmployeeID: Unique identifier for each employee.
2. Age: Age of the employee.
3. Attrition: Whether the employee has left the company (Yes or No).
4. BusinessTravel: Frequency of travel for work (Travel_Rarely, Travel_Frequently, Non-Travel).
5. Department: Department in which the employee works (Sales, Research & Development, Human Resources).
6. DistanceFromHome: Distance of employee's residence from work in miles.
7. Education: Employee's level of education (1 to 5, representing varying levels).
8. EducationField: Field of education of the employee (Life Sciences, Medical, Marketing, etc.).
9. EmployeeCount: Number of employees (usually 1 in most records). 10 Gender: Gender of the employee (Male or Female).
10. JobLevel: Level of the job (1 to 5, indicating different hierarchical levels).
11. JobRole: Role/title of the employee (Sales Executive, Research Scientist, Laboratory Technician, etc.).
12. MaritalStatus: Marital status of the employee (Single, Married, Divorced).
13. MonthlyIncome: Monthly income of the employee in USD.
14. NumCompaniesWorked: Number of companies the employee has worked for previously.
15. Over18: Whether the employee is over 18 years old (Y for all records).
16. PercentSalaryHike: Percentage increase in salary last year.
17. StandardHours: Standard number of working hours (80 for all records, assuming full-time).

KPI

1. Attrition Rate: Calculate the percentage of employees who have left the company (Attrition = Yes) compared to the total number of employees.
2. Average Age: Average age of employees in the company.
3. Average Monthly Income: Average monthly income of employees.
4. Average Distance From Home: Average distance of employees' residences from their workplace.
5. Average Years at Company: Average number of years employees have worked at the company.
6. Average Years Since Last Promotion: Average number of years since employees' last promotion.
7. Turnover Rate by Department: Percentage of employees who have left the company within each department.

Dashboard

Insights

1. The attrition rate in XYZ company is approximately 15%, which indicates a significant turnover that needs attention.
2. The workforce shows a diverse age distribution, with a majority likely in their mid-career stages based on average age trends.
3. There is variability in monthly income levels among employees, reflecting different roles and experience levels within the company.
4. Employees seem to live relatively close to the workplace on average, which may impact commuting satisfaction and retention.
5. The average tenure at the company is moderate, suggesting a mix of new hires and longer-tenured employees.
6. There is a varied distribution in years since the last promotion, indicating potential dissatisfaction with career progression opportunities.
7. Distribution across education levels and gender shows a diverse workforce composition, which may influence attrition patterns.