This project dives deep into the realm of data analysis using Excel and Power BI to uncover important human resource insights that can greatly benefit the company.
Featuring eye-catching dashboards offer crucial HR metrics like employee turnover, diversity, recruitment efficacy and performance evaluations. These help HR professionals make informed decisions and strategic workforce planning.

The source data contained Human Resource 22000 records from 2000 to 2020. This is included in the repository.

1. What's the age distribution in the company?
2. What's the gender breakdown in the company?
3. How does gender vary across departments and job titles?
4. What's the race distribution in the company?
5. What's the average length of employment in the company?
6. Which department has the highest turnover rate?
7. What is the tenure distribution for each department?
8. How many employees work remotely for each department?
9. What's the distribution of employees across different states?
10. How are job titles distributed in the company?
11. How have employee hire counts varied over time?

    Findings:

12. There are more male employees than female or non-conforming employees.
13. The genders are fairly evenly distributed across departments. There are slightly more male employees overall.
14. Employees 21-30 years old are the fewest in the company. Most employees are 31-50 years old. Surprisingly, the age group 50+ have the most employees in the company.
15. Caucasian employees are the majority in the company, followed by mixed race, black, Asian, Hispanic, and native Americans.
16. The average length of employment is 7 years.
17. Auditing has the highest turnover rate, followed by Legal, Research & Development and Training. Business Development & Marketing have the lowest turnover rates.
18. Employees tend to stay with the company for 6-8 years. Tenure is quite evenly distributed across departments.
19. About 25% of employees work remotely.
20. Most employees are in Ohio (14,788) followed distantly by Pennsylvania (930) and Illinois (730), Indiana (572), Michigan (569), Kentucky (375) and Wisconsin (321).
21. There are 182 job titles in the company, with Research Assistant II taking most of the employees (634) and Assistant Professor, Marketing Manager, Office Assistant IV, Associate Professor and VP of Training and Development taking the just 1 employee each.
22. Employee hire counts have increased over the yeaar