This HR Analytics project aims to determine the key factors influencing employee attrition within a company. By analyzing various data points, we seek to uncover insights into why employees leave and identify potential areas for improvement in employee retention strategies. The project leverages Power BI to create a comprehensive dashboard that visualizes these insights.
The scope of this project includes:
- Collecting and preparing HR data for analysis.
- Identifying key factors that influence employee attrition.
- Creating visualizations to represent data insights.
- Building a Power BI dashboard to present findings.
- Data Cleaning: Handling missing values, correcting data types, and ensuring data consistency.
- Data Transformation: Aggregating data and creating calculated columns to enhance analysis.
- Attrition Analysis: Determining the overall attrition rate and analyzing it by various demographics such as department, job role, and age.
- Job Satisfaction: Examining the correlation between job satisfaction levels and employee attrition.
- Performance Analysis: Assessing how performance ratings impact the likelihood of an employee leaving.
- Salary and Compensation: Investigating the role of salary and compensation in employee retention.
- Work-Life Balance: Understanding how work-life balance affects employee decisions to stay or leave.
- Overview Page: High-level metrics and key performance indicators (KPIs) related to employee attrition.
- Job Roles Analysis: Attrition rates segmented by different job roles.
- Job Satisfaction Matrix: Visualizing the relationship between job satisfaction ratings and attrition counts across job roles.
- Demographics: Breakdown of attrition by age, gender, and other demographic factors.
- View Dashboard images below
-
-
View in pdf for better clarity of dashboard image HR Analytics Dashboard Project