Background

Palmoria Group, a Nigerian manufacturing company is facing gender inequality issues in its 3 regions. A recent media report has labelled the company 'Palmoria, the Manfacturing Patriarchy' that threatens its expansion. The CEO, Mr. Ayodeji Chukwuma has asked the HR team, led by Chief Human Resources Officer Yunus Shofowole to address these issues. The Palm Project group 2025 have been tasked to analyze data and recommend solutions.

Key Business Questions

Does gender pay gap exist in the company?

Which departments or locations show most gender disparity?

Does Palmoria meet the minimum wage requirement?

Tasks

1.Evaluate the gender distribution by gender, department and location

2 Analyze the employee performance ratings based on gender and across departments

3 Analyze the company's salary structure to identify any gender pay gaps by department and location

4 Determine the degree of compliance with minimum wage

Data cleaning process - Data collected, Data cleaned via PowerQuery, Modelled using DAX formulas, visualized and analyzed data