Data Used

Data: Human Resource Data with over 22,000 rows from 2000 to 2020.

Data Cleaning & Analysis: MySQL

Visualization: PowerBI

Questions

1. What is the gender breakdown of employees?
2. What is the race/ethnicity breakdown of employees?
3. What is the age distribution of employees?
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?

Phase 1: Data Cleaning

Creating the project

CREATE projects;