HR-Analysis
Abdelrhman Sadek
Description
The aim of this project is to analyze and give insights about the employee status such as:
Some general information like How many employees we have(Males, Females), What is there material status, Educational background,etc
How many years of service do they spent with the company
% Employee career levels the company has determined based on their job levels
Their job satisfaction level working with the company
% of employees that take overtime shifts
Age range for every job role Also, Performing changes from Retrenchmentand Promotions that the organization wants to perform
The company wants the do some Retrenchmens and Promotions based on:
employees that haven't been promoted 5 years or more get a Promotion
employees that spent over 18 years with the company will be Retrenched
employees that satisfy both condetion will get Severance Benefits due to their services Then, visualize how these changes will affect the organization
Preprocessing
The data was all in one column so I had to reformat it using Power Query
Perform relationships between HR employee data and HR Analytics Data with joins to gain more insights
Add conditional columns like :
Pormotion_Stats based on the company's condition for promotion (employees that haven't been promoted 5 years or more get a promotion)
Emp_Retrenchment based on the company's condition for retrenchment (employees that spent over 18 years with the company will be Retrenched)
Career Level based on job level 3-5 Senior/0-2 Junior
Distances Status based on distance from home <= 5 very close,>=10 close,>=20 far, else very far And more
Created:
Promotion and Retrenchment CSVs that have the lists of employees that will get a promotion or will be retrenched
Severance Benefits CSV that have duplicate values from Promotion and Retrenchment tables
Dashboards
Employee Insights
Changes
Work Filled Insights
Loading this content connects you to GitHub Gist.
GitHub Gist privacy informationLike this project
Posted Jun 13, 2023
An interactive Power BI dashboard that gives insights about employee and company departments’ status and also, gives information about some changes that will o…
