This project involves the analysis of HR data from the year 2000 to 2020, consisting of over 22,000 rows. The aim is to uncover insights into the workforce composition and employment trends within the company.
- Data Source: HR database with records from 2000 to 2020.
- Data Cleaning and Analysis: Performed using MySQL Workbench.
- Data Visualization: Created with PowerBI.
The analysis addresses the following questions:
- Gender breakdown of employees.
- Race/ethnicity breakdown of employees.
- Age distribution of employees.
- Number of employees at headquarters vs. remote locations.
- Average length of employment for terminated employees.
- Gender distribution across departments and job titles.
- Distribution of job titles across the company.
- Department with the highest turnover rate.
- Employee distribution across locations by state.
- Company's employee count change over time.
- Tenure distribution for each department.
- Gender: Predominantly male employees.
- Race/Ethnicity: White race is the most represented; Native Hawaiian and American Indian are the least.
- Age: Range from 20 to 57 years old, with most employees between 25-34 years.
- Location: Majority work at headquarters.
- Employment Length: Terminated employees average around 7 years.
- Departmental Gender Distribution: Fairly balanced, with a slight male majority.
- Turnover Rate: Highest in Marketing, followed by Training.
- State Representation: Ohio has the largest employee base.
- Employee Count Trend: Net increase over the years.
- Departmental Tenure: Average tenure is 8 years, with Legal and Auditing having the highest.
- Excluded records with negative ages (967 records).
- Term dates beyond the current date were not considered