Praise-es/-Palmora-Group-HR-Analysis

The Palmoria Group, a manufacturing company based in Nigeria, is embroiled in issues bordering on gender inequality in its 3 regions. # 📊 Palmoria Group HR Analysis – Capstone Project ## 🧩 Project Overview Palmoria Group, a manufacturing company in Nigeria, came under public scrutiny due to gender inequality allegations. This capstone project investigates HR data to identify gender-related disparities in pay, performance, and compliance with wage regulations. The goal is to extract actionable insights to support data-driven HR policy improvements. --- ## 📂 Dataset Description The dataset includes: - Employee demographic and compensation data - Department, region, gender, salary, and performance ratings - A separate bonus rule table based on department and rating --- ## 🛠️ Tools Used - **Microsoft Excel** - Power Pivot Tables - Conditional Formatting - INDEX + MATCH functions - Charts (Bar, Column, Pie, 100% Stacked) - **GitHub** for project documentation and sharing --- ## ✅ Analysis Conducted ### 1. Gender Distribution - Distribution of employees by gender, region, and department using Pivot Tables. - Visualized with 100% stacked bar and pie charts. - Males outnumber females across all three regions — **Kaduna, Abuja, and Lagos**. - **Kaduna** has the **highest number of male employees**, followed by Abuja and Lagos. ### 2. Performance Ratings by Gender - **Female employees received higher average performance ratings** than male employees. - Most “Very Good” and “Good” ratings were awarded to **females**. - Male employees had more “Very Poor” and “Poor” ratings across all regions. - Indicates a **potential misalignment** between performance and compensation. ### 3. Salary Structure & Gender Pay Gap - **Male employees earn an average of $2,214.47 more** than female employees. - **Business Development** showed the largest departmental pay gap of **$9,595**. - **Lagos** exhibited the widest regional gap at **$3,026**. - Legal, Product Management, and Accounting are **male-dominated departments**. - Engineering, Business Development, Research, and Services have **higher female representati …