In today's dynamic business landscape, organizations are increasingly recognizing the critical importance of leveraging data-driven insights to optimize their human resources strategies. The human resources (HR) department serves as the backbone of an organization, managing the most valuable asset: its workforce. Employing data analytics practices in this sector can help us gain deep insights into various aspects of employee retention, performance, and demographic trends within the organization.
The primary aim of this project is to delve into the data and scrutinize historical data and current trends,to study underlying factors influencing attrition rates and decipher patterns that may impact employee retentionand provide the orgination with actionable recommendations tailored to enhancing retention strategies and fostering smarter talent management decisions.
This project was executed by me as part of my internship experience with Ai Variant. The analysis was conducted using excel and powerbi.
Objectives :
- To study the total attrition across various depts, education fields, etc.
- Explore Gender distribution and Equity
- Correlation between attrition rates and various factors such as income, last promotion, etc.
- To evaluate work-life balance across different job roles.
- Compare job satisfaction levels across different departments
- Provide recommendations to improve retention.
Data sets and Data cleaning:
- The organisation has provided two datasets HR_1 containing personal or demographics details of the employees and HR_2 contains their performance metrics. The datsets were cleaned and transformed accordingly using power query.
Data Analysis
- After cleaning, the datasets were loaded into powerbi to conduct statistical analysis and to create a interactive report.
- The report into two two categories – The demographics of the employees and their performance.
- The major focus of the study was to study the causes for the attrition
Link to live report - https://www.novypro.com/project/employee-retention-project-internship-project-power-bi
Demographics:
Performance:
- After conducting the analysis, we extracted critical insights that proved to be pivotal in our understanding.
- The report and the outputs were presented to the participating entities using the following ppt.
- Later the organisation was sugguested with few recommedations and solutions to adapt in order to improve employee retention.