HR Analytics
SQL Server | My SQL | SSMS
Built a relational HR database in SQL Server to analyse workforce distribution, salary trends, employee training, and workforce activity using advanced SQL queries and business-focused analysis
SQL Analysis
This project focuses on analysing HR workforce data using SQL Server. I created a relational database containing employee, department, attendance, leave, and training data to answer business-focused HR questions and generate workforce insights.
The goal of the project was to demonstrate SQL skills used in real business environments, including joins, aggregations, CTEs, subqueries, window functions, and data analysis techniques.
Key Findings
Identified employees without completed training records
Ranked employees by salary within departments using window functions
Found IT and Operations had the highest average salaries
Identified high-performing employees hired after 2022 who remained within lower salary bands, highlighting potential progression and retention opportunities
Combined leave and training activity into one workforce activity log for HR reporting
Click the links below to view SQL codes.