Employees Insights-Dashboard-MySQL-PowerBI
Data Used Data - Employees data with over 22000 rows from the year 2000 to 2020.
Data Cleaning & Analysis - MySQL Workbench
Data Visualization - PowerBI
Questions
- What is the gender breakdown of employees in the company?
- What is the race/ethnicity breakdown of employees in the company?
- What is the age distribution of employees in the company?
- How many employees work at headquarters versus remote locations?
- What is the average length of employment for employees who have been terminated?
- How does the gender distribution vary across departments and job titles?
- What is the distribution of job titles across the company?
- What is the distribution of employees across locations by state?
Summary of Findings
- 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.
- A large number of employees come from the state of Ohio.
- Some records had negative ages and these were excluded during querying(967 records). Ages used were 18 years and above.