HR_Data_Analysis

This project aims to explore the company HR data to understand the most paid careers, average salary of each categories and so on .

Objectives Of Analysis

The main purpose of the analysis :: to answer the following questions to gain a deeper understanding of the data.

1. To understand the most paid career?
2. What is the average salary of each category?
3. How does gender affect the salary of an employee?
4. How does race(white/black/Asian...) affect the salary of an employee?
5. How does race(white/black/Asian...) affect employee position?
6. How does absence affect the salary of an individual?
7. What is the most common recruitement source and how does recruitement source affect salary and EmpSatisfaction?
8. What is the categorization count for EmploymentStatus?
9. What is the average salary based on department?
10. Which state has the most paid salary?
11. What is the most common reason for termination?
12. What is the most common reason for termination by race?
13. What is the most common EmploymentStatus?
14. Which recruitment source give employees with best performance score?
15. Which department has the most absenties?
16. Which race has the most absenties?
17. Which department has the best employee satisfactions?
18. Which race has the most satisfied employees?
19. What is the employee satisfaction levels for married/single people?
20. Which state has the most satisfied employees?
21. Which state are you likely to get a job(Position) by category?
22. What is the average age of employees in each department?
23. Average age by each race?
24. What is the average age of each position?

Procedures :

1. Data Cleaning : Remove unwanted columns, delete PII.
2. Database Creation
3. Writing Scripts to answer defined questions.