POWER BI EMPLOYEE ANALYSIS INDICATORS

Contents:-

Company employee data, their job performance, some job impact evaluation indicators, data on salary, working hours, years of experience, departments, and education fields for each employee.

Data status:-

CSV spreadsheet does not need cleaning and the data is in good condition, but it lacks the time aspect.

Data conversion was done, then analyzed and displayed interactively.

Programs used: Microsoft Excel Microsoft Power i my sql work bench Steps to use SQL: select Department, (select count(*) from hr where hr.Department=h2.Department and hr.Attrition ="NO") as still, (select count(*) from hr where hr.Department=h2.Department and hr.Attrition ="Yes") as go from hr h2 group by Department (select count( *) from hr where Gender="Male") As Male, (select count(*) from hr where Gender="Female") As female select JobRole, (select count(*) from hr where hr.JobRole=hr2.JobRole and Gender="Male") As Male, (select count(*) from hr where hr.JobRole=hr2.JobRole and Gender="Female") As female

from hr hr2

group by JobRole

This is to get the number of females and males for each job title and their number in general

and the number of those who left work and those who remained.

Outputs: -

The most department that agrees to work overtime is the research department

The most job title that takes overtime is research

The one who takes overtime was more satisfied than the rest

The largest number of employees is executive sales, and the number of females is greater than males

The smallest number of employees is in human resources, and the number of males is predominant

The company has a higher percentage of those present than those who have resigned

There is no relationship between the number of training times and the salary increase

The higher the work level, the higher the age

But the largest number is in the first degree

The number of married people is the largest number in the marital status categories

The largest percentage from the same department was Divorce in the human resources department

The average performance has no inverse relationship with the average years of work

The increase in salary is not related to travel

The shares that the company offers to employees The highest job satisfaction is those with the average number of shares