team-pfa-solutions/DSA-Capstone-Palmora-HR-Analytics

Capstone project for the Data Skillup Africa (DSA) program – A Power BI HR analytics dashboard uncovering gender distribution, pay gap, and bonus allocation insights for Palmora Group. # 🎓 DSA Capstone Project: Palmora Group HR Analytics This repository contains my capstone project for the **Data Skills Accelerator (DSA)** program. It focuses on solving a real-world HR analytics case for Palmora Group, a Nigerian manufacturing company, using Power BI. The project addresses organizational issues such as **gender inequality**, **pay gaps**, and **performance-based bonus allocation**, through data visualization and insights generation. --- ## 🏢 Project Background Palmora Group came under public scrutiny after a media report accused the company of being a male-dominated organization. As part of a consulting team, I was tasked with analyzing their employee dataset and identifying gender-related imbalances, salary structures, and bonus payouts across three regions in Nigeria. --- ## 🎯 Objective To analyze HR data and generate actionable insights for management, focusing on: - Gender distribution across regions and departments - Performance ratings by gender - Salary gap and regulatory compliance - Bonus allocation based on performance --- ## 📁 Files in This Repository - `Palmoria Group emp-data.csv` – Cleaned employee dataset - `Palmoria Group Bonus Rules.xlsx` – Bonus percentage rules by rating - `Palmoria HR Dashboard.pbix` – Power BI file containing all visuals - `README.md` – Project documentation --- ## 📊 Dashboard Highlights - 📌 Gender distribution by region & department - 📌 Average performance ratings by gender - 📌 Salary analysis with pay gap visuals - 📌 Salary band histogram (grouped by $10k) - 📌 Compliance with $90,000 minimum wage - 📌 Performance-based bonus calculations - 📌 Bonus payout totals by region --- ## 🔍 Key Insights - Gender imbalance was most severe in [Region X / Department Y] - A significant portion of staff earned below $90,000 threshold - Female employees had lower average ratings in certain departments - Bonus payments automated successfully using performance logic --- ## 🧰 Tools Used - Power BI - Power Que …