Dataset

Data

The data consists of HR information with more than 22,000 entries spanning from 2000 to 2020.

Data Cleaning & Analysis

The data was processed and analyzed using MySQL Workbench.

Data Visualization

Using PowerBI.

Questions

1. What is the gender breakdown of employees in the company?
2. What is the race/ethnicity breakdown of employees in the company?
3. What is the age distribution of employees in the company?
4. How many employees work at headquarters versus remote locations?
5. What is the average length of employment for employees who have been terminated?
6. How does the gender distribution vary across departments and job titles?
7. What is the distribution of job titles across the company?
8. Which department has the highest turnover rate?
9. What is the distribution of employees across locations by state?
10. How has the company’s employee count changed over time based on hire and term dates?
11. What is the tenure distribution for each department?

Summary of Findings

• There are more male employees than female employees.
• White is the predominant race, while Native Hawaiian and American Indian are the least represented.
• Employees’ ages range from 21 to 58, with the majority falling into the 35-44 age group.
• A significant number of employees work at the headquarters compared to remote locations.
• The average length of employment for terminated employees is approximately 8 years.
• Gender distribution across departments is generally balanced, but there are more males than females overall.
• The Marketing department has the highest turnover rate, followed by Training and Human Resources, while Research and Development, Auditing, and Support have the lowest turnover rates.
• Many employees come from the state of Ohio.
• The company’s employee count has increased over the years.
• The average tenure for each department is around 8 years, with Legal and Auditing having the highest, while Marketing having the lowest.

Go to repo >>