Data - HR Data with over 22000 rows from the year 2000 to 2020.
Data Cleaning & Analysis - MySQL, Jupyter Notebook(sql magic)
Data Visualization - PowerBI
-
What is the demographic breakdown of employees in the company based on gender?
-
What is the overview of the racial and ethnic makeup of employees in the company?
-
How is the age range of employees in the company distributed?
-
What is the breakdown of employees between those working at the headquarters and those working remotely?
-
On average, how long do terminated employees remain employed by the company?
-
How does the distribution of gender vary across different departments and job titles?
-
What is the distribution of job titles throughout the company?
-
Which department has the highest rate of employee turnover?
-
What is the geographic distribution of employees across different states or locations?
-
How has the number of employees in the company changed over time based on their hire and termination dates?
-
What is the tenure distribution among employees in each department?
-
There are more male employees
-
White race is the most dominant while Native Hawaiian and American Indian are the least dominant.
-
The youngest employee is 20 years old and the oldest is 57 years old
-
5 age groups were created (18-24, 25-34, 35-44, 45-54, 55-64). A large number of employees were between 25-34 followed by 35-44 while the smallest group was 55-64.
-
A large number of employees work at the headquarters versus remotely.
-
The average length of employment for terminated employees is around 7 years.
-
The gender distribution across departments is fairly balanced but there are generally more male than female employees.
-
The Marketing department has the highest turnover rate followed by Training. The least turn over rate are in the Research and development, Support and Legal departments.
-
A large number of employees come from the state of Ohio.
-
The net change in employees has increased over the years.
-
The average tenure for each department is about 8 years with Legal and Auditing having the highest and Services, Sales and Marketing having the lowest.