data analysis for HR data

Objectives

1.Total bonus per month

2.Total employees (women&men)

3.Average Employee Tenue

4.Average Employees age

5.Employee performance score

6.Turn over in department

7.Turn over causes

8.Measurement of employee satisifaction

9.Average of hourly pay rate

10.Hierarchy Of Employees

11.Total bonus per department

12.Employees in department

13.Average of hourly pay rate and position

14.Employees status

Conclusions

1.Higher month bonus is December

2.Higher position pay rate is IT manager &Area sales Manager

3.Average employee age is 46 and most of emplyees higher than 44 years old

4.Average employee tenue is 12 (employess has Job security(

5.80% of employees meet job description

6.The higher turn over in production department

7.Executive office department has no termination

8.Higher capacity in production department

9.Most of turn over reason is another position or un happy

10.100% of Executive office employees meet job