Analysed 22,000+ HR records using MySQL for querying and Power BI for dashboards. Explored workforce patterns including gender distribution, department turnover, and employee tenure across a 20-year dataset.
Introduction
An end-to-end HR analytics project combining MySQL for data cleaning and analysis with Microsoft Power BI for interactive dashboard development — built on a dataset of 22,000+ employee records spanning 20 years (2000–2020) across 14 variables.
Breif
The project was structured around 11 business questions covering workforce composition, diversity, turnover, and headcount trends.
Data Cleaning & Analysis in MySQL: Excluded records with negative ages (age threshold set to 18+) and future termination dates to ensure data integrity. Wrote SQL queries to calculate gender and race breakdowns, departmental turnover rates, average employment tenure, remote vs. headquarters distribution, and yearly net employee change over time.
Power BI Dashboard: Built an interactive multi-page dashboard visualizing workforce KPIs including gender distribution across departments and job titles, age group segmentation, geographic distribution by city and state, and tenure analysis by department.
Key Findings:
– Average employee tenure before termination is ~8 years
– ~75% of employees work on-site vs ~25% remotely
– Engineering is the largest department for both genders
– The 25–34 age group is the most represented segment
– Ohio accounts for the majority of employees (14,144), indicating the likely headquarters location
– Net employee headcount has grown consistently over time
– White is the most represented racial group; American Indian and Native Hawaiian are the least represented
– Auditing has the smallest headcount across all departments