Ruth442442/Palmoria-HR-Gender-Equality-Analysis

HR analytics project using Power BI to identify gender inequality, salary disparities, and bonus allocation issues within the Palmoria Group, a manufacturing company in Nigeria. # Palmoria HR Analytics – Gender Equality Case Study View Palmoria Dashboard The Palmoria Group, a manufacturing company based in Nigeria, is embroiled in issues bordering on **gender inequality** in its 3 regions. A recent media headline — _"Palmoria, the Manufacturing Patriarchy"_ — sparked public concern and internal pressure. ## Objectives - Analyze employee data to uncover gender-related inequalities - Visualize insights using interactive dashboards - Make evidence-based recommendations to management ## Case Scenario Instructions - Assign generic gender status to employees who didn’t disclose it - Remove employees without salary (they’re no longer with the company) - Exclude rows where departments are marked “NULL” ## Key Analysis Questions 1. **What is the gender distribution** in the company (by region and department)? 2. **What do employee ratings** look like across genders? 3. **Is there a gender pay gap**? If yes, in which departments and regions? 4. **Does Palmoria comply** with the regulation mandating a **minimum salary of $90,000**? - Show salary distribution by $10,000 bands - Visualize salary bands by region 5. **Bonus Allocation** - Calculate bonus based on performance rules - Show total salary (base + bonus) per employee - Compute total bonus payout per region and overall ## Power BI Dashboard Highlights **Total Employees Analyzed:** 946 **Compliance Rate:** 30.87% (only 30.87% earn at least $90,000) **Gender Distribution:** - Male: 465 (49.15%) - Female: 441 (46.62%) - Unknown: 40 (4.23%) ## Salary Disparities **Overall Salary Including Bonus:** - **Total:** $71.92M - **Without Bonus:** $69.72M **By Region:** - **Kaduna:** $27.48M - **Abuja:** $24.92M - **Lagos:** $19.53M **Median Salary by Gender (All Regions Combined):** - **Male:** $73,366 - **Female:** $72,500 - **Unknown:** $75,360 - **Gap (Male vs. Female):** ~$866 in favor of males **By Department – Notable Gaps:** **Legal:** - Male: $84,640 - Female: $78,650 - Gap: ~$5,99 …