Atlas Labs HR Analytics on Power BI
- Michael Olaniyi Jeremiah
- Sep 21, 2024
- 2 min read
Updated: Aug 15
By Michael Michael Jeremiah
Dashboard Overview
Analysis Finding:
Total Employees: 1470
Active Employees: 1233
Inactive Employees: 237
Attrition Rate: 16.1%
Employees Hiring Trend in 2022: 130 employees hired and 25 attritions, totaling 155.
The technology department has the highest number of active employees with 828. The sales department and sales executives are the most active employees.
Demographic:
Analysis Finding:
Youngest Employee: 18
Oldest Employee: 51
Marital Status: Married is the highest with 624 employees, which is 42%.
Highest Age Bin: 20 - 30
Ethnicity: White ethnicity is the largest with 860 employees.
Performance Tracker:
Analysis Finding:
Estelle Chung's ratings for job satisfaction, relationship satisfaction, and environment satisfaction are all 3, while work-life balance is rated 4 in 2022. The Manager's rating is 2, indicating a need for attention and improvements.
Attrition:
The overall attrition rate is 16.1%.
Attrition rate by Department and Job Role: The sales department and sales representatives have the highest attrition rate at 39.8%.
Total Employees Attrition Rate by Business Travel: Frequent Travelers have the highest attrition rate of 24.9%.
Over time workers have an attrition rate of 30.5%. Within the past 10 years, Atlas Labs experienced the highest employee attrition in the year 2020 with 22%.
Attrition by Tenure: The employees with 1 year of tenure at Atlas Labs have the highest attrition rate.
Summary
In summary, the analysis results highlight a moderate attrition rate of 16.1%, with the sales department and sales representatives exhibiting the highest attrition rates, necessitating a focus on employee engagement and managerial improvements to enhance overall workforce stability and satisfaction.
Recommendations
Prioritize employee engagement initiatives, including feedback mechanisms and skill development opportunities, to reduce attrition rates and improve overall job satisfaction.
Invest in managerial training, closely monitor attrition in high-risk departments, and tailor retention strategies for employees with shorter tenures to create a more stable and content workforce.
-----------------------------------------------------------------------------------------------------------------------
Thank you for taking the time to review this project. I welcome your comments, suggestions, and feedback.
For any project discussions or job opportunities, please feel free to contact me at:
Email Address: michaeljeremiah124@gmail.com
Phone: 234706664402
GitHub: https://github.com/mikeolani
Comments