The data analysis work is done by using power BI on a HR data.
Objective:
- Identifying the number of employees who are in due for promotion and not due for promotion based on their years of service.
- The company is going to retrench the employees who are having 15 years of service. So, we have to examine the employees who have completed more than 15 years in the company.
Steps Performed: • Firstly I have taken the data set from the internet in CSV format and exported it to the Power BI. • By using Power Query editor Data cleaning is performed using • Transformed data to creat new columns in the existing table. The new columns are service year, Job level, Retrenchment Status, Promotion Status. • Created a new table and with the help of DAX language created ed all the new measurements. • The new measurements created in the process are, Total employees, number of employees by both the genders, Due for Promotion, Not due for Promotion, Employees will retrench, Employees in service.
KPIs: • Total number of employees. • Number of employees in due for promotion. • Number of employees will be retrenched from the company.