Built with datascienceportfol.io

HUMAN RESOURCES ATTRITION ANALYSIS

Project photo

Skills

About this project

Introduction: This project aims to provide a comprehensive view of personnel Attrition, showcasing various key performance indicators (KPIs) and visualizations to help understand the factors that contributes to it

Key Metrics and Visualization:

Attrition Rate by Job Role and Monthly income: This was represented by line chart, it aimed to show the correlation between the attrition rate and the monthly income of the employees

Attrition Rate by Gender and Satisfaction Grouping: This aimed to determine the relation between gender and relationship satisfaction rate with Attrition by emoloyees. This is to determine if employees leave their jobs more if their not satisfied in their personal life's and if their gender affects that too.

Attrition count by Gender and Marital Status: This  was represented bya clustered bar chart. The bars represented Divorced, married and single. It goes to determine if married people had a higher rate of attition or single employees had a higher rate. The data showed that married Males had the highest rate of Attrition.

Attrition Rate by Overtime: This was visualized by a pie chart which sought to determine if employees that worked overtime had a higher attrition rate than those that did not. The data showed that employees that did not work overtime had a higher attrition rate, and this could be due to the fact that no overtime means no extra income except for the base salary. This could lead them to leave the company in other to find other company that would offer more in terms of pay

Attrition rate by gender: this was visualized byba pie chart and it sought to show if males had a higher attrition rate than females or vice versa, and the data showed that females had a lower attrition rate.

Attrition Rate by Age group: This information was filtered out using the case syntax on SQL. The ages were grouped into 18 - 30, 31 - 45, 46 - 60, and it was group using the case syntax. It was visualized using a in order to see which age group had a higher rate of attrition. The data found that ages 31 - 45 had a higher rate of attrition and ages 45 - 60 had the lowest rate of attrition.

Link to the Project: https://drive.google.com/folderview?id=1kBazkMPNbipfTA4utn1_CQ2zKzI9vetE