DataGuy-Eterniti/Palmoria-HR-Performance-Compensation-Analysis

This HR analytics project was developed as a capstone deliverable for the Digital SkillUp Africa (DSA) training program. It simulates a real-world scenario where I served as a junior analyst for Palmoria Group, tasked with investigating HR trends, rating equity, compensation patterns, and bonus allocation strategy using Microsoft Power BI. # Case Study 3: Palmoria HR Performance & Compensation Analysis ## Author **Adeniji Elijah Adetomiwa** Junior Data Analyst ## Submission Date **July 2025** --- ## Table of Contents - Project Description - Dataset Overview - Key Business Questions - Tools & Workflow - Dashboard Pages & Visuals - Insights & Observations - Connect with Me --- ## Project Description This HR analytics project was developed as a capstone deliverable for the **Digital SkillUp Africa (DSA)** training program. It simulates a real-world scenario where I served as a junior analyst for **Palmoria Group**, tasked with investigating HR trends, rating equity, compensation patterns, and bonus allocation strategy using Microsoft Power BI. The dashboard is interactive, multi-layered, and designed to help management gain deeper insight into internal workforce dynamics. --- ## Dataset Overview ### 1. **Employee Dataset** Contains employee-level records including: - Name, Gender, Location, Department - Salary, Performance Rating (Very Poor to Very Good) Employee Dataset ### 2. **Bonus Rules Dataset** Bonus percentages vary by **Department + Rating**. This dataset was unpivoted and mapped using composite keys to calculate conditional bonus payouts per employee. Bonus Rule Dataset --- ## Key Business Questions | Page | Questions Answered | |------|--------------------| | 1. Workforce Profile | What’s the gender and departmental spread across regions? | | 2. Compensation Overview | How fairly are salaries distributed by gender and region? | | 3. Performance & Ratings | Are ratings consistent across departments and demographics? | | 4. Bonus Allocation | Who earned bonuses? Are payouts equitably distributed? | --- ## Tools & Workflow - **Power BI Desktop** Power BI - Power Query: Data cleaning and transformation - DAX: Custom measures and calculated columns - Data modeling: Composite keys, many-to-one joins - Visuals: KPIs, funnel, waterfall, filled maps, matrix, gauge --- ## Dashboard …