HR-Analysis

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

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

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