This project illustrates the application of SQL for comprehensive data wrangling, statistical analysis, and the use of window functions to analyze employee data in a company to derive deeper insights into employee distribution and salary structures. The dataset contains information on company divisions, regions, and staff, detailing job titles, departments, and salaries.
The key steps in analysis include:
- Data wrangling and cleaning of the datasets
- Analyzing employee distribution and statistical analysis by various attributes such as department, job category and gender
- Using SQL window functions for detailed analysis of employee salary
- Balanced Gender Distribution: The company has a nearly equal number of male and female employees, promoting a balanced workforce
- Department-Wise Employee Distribution: Some departments have significantly more employees. Ensuring equitable distribution of workforce can improve operational efficiency.
- Gender Distribution in Departments: Departments such as 'Automotive', 'Electronics', and 'Industrial' have more men, while 'Clothing', 'Home', and 'Outdoors' have more women. Encouraging diversity within departments can enhance innovation and performance.
- No Significant Gender Pay Gap: There is no significant gender pay gap observed in the average salaries, indicating fair pay practices.
- High Salary Variation in Health Department: The Health Department shows the highest variation in salary. Standardizing pay scales within this department can reduce disparities.
- High Earners in Outdoors Department: The Outdoors Department has a high number of top earners. Analyzing the factors contributing to this can help replicate success in other departments
The SQL-based analysis provided comprehensive insights into the company’s workforce, highlighting areas of strength and opportunities for improvement. The findings indicate a balanced gender distribution and no significant gender pay gap, suggesting fair HR practices. However, certain departments exhibit salary variations and uneven workforce distribution, which can be addressed to enhance overall efficiency and employee satisfaction. Implementing the recommendations derived from this analysis can contribute to a more equitable and productive workplace