Oluwatobi92/palmora-hr-analysis

Capstone Project – Palmora Group HR Analysis (Power BI Dashboard). Completed as part of the Digital SkillUp Africa (DSA) Data Analysis Bootcamp. # palmora-hr-analysis Capstone Project – Palmora Group HR Analysis (Power BI Dashboard). Completed as part of the Digital SkillUp Africa (DSA) Data Analysis Bootcamp. # 👩‍💼 Palmoria Group HR Analysis This Power BI dashboard was developed as part of the **Digital SkillUp Africa (DSA) Data Analysis Bootcamp Capstone Project**, focusing on HR-related data to uncover gender disparities, salary structures, bonus distribution, and compliance issues at Palmoria Group — a Nigerian manufacturing company. ## 📊 Project Overview You were recruited as an HR Analytics expert to investigate critical workforce issues relating to gender equity, salary fairness, and bonus allocations. The objective was to identify trends and provide actionable recommendations to management before media scrutiny escalated further. This project was completed using **Power BI**, leveraging: * Power Query for data cleaning and transformation * DAX for creating KPIs, salary bands, and bonus calculations * Data modeling to link employee and bonus rule tables * Interactive visuals including stacked bar charts, slicers, and KPI cards ## 🛠 Tools Used * Microsoft Power BI Desktop * Power Query Editor * DAX Measures & Calculated Columns * Report View with Slicers and Charts ## 📌 Key Tasks Performed * Cleaned employee and department-level bonus data * Removed employees with no salary or NULL department * Assigned a generic gender label to undisclosed employees * Created salary bands grouped in \$10,000 intervals * Built KPIs for salary averages, bonus totals, rating distribution, and gender balance * Developed multi-page interactive dashboards ### 💡 Key Insights (Detailed Narrative) The Palmoria Group HR dataset comprises a total of **946 employees**, spread across **three regions** (Lagos, Abuja, and Kaduna) and multiple departments. A breakdown of gender reveals that **49.2% are male (465 employees)**, **46.6% are female (441 employees)**, and **4.2% (40 employees)** preferred not to disclose their …