png)
In this project, I analyzed employee data to understand workforce trends, salary patterns, and how different departments are structured.
I used SQL to extract the data and Tableau to build an interactive dashboard that clearly shows key insights.
- SQL (MySQL Workbench)
- Tableau
- Employee distribution (Male vs Female over time)
- Salary trends across years
- Number of managers per department
- Average salary by department and gender
- The company experienced steady growth in employee count
- Salaries increased gradually over time
- Some departments have more managers than others
- There are slight salary differences across departments and gender
👉 [https://public.tableau.com/app/profile/nonye.obi]
Repository Structure
- 01_Database_Setup — database creation and setup
- 02_Exploratory_Analysis — exploratory SQL analysis
- 03_Advanced_Insights — advanced SQL techniques and analytical queries
- 04_Database_Objects — views, procedures, functions, indexes, and triggers
All SQL queries used for this project are included in this repository.