IluyemiJoy/Palmoria-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 The Palmoria Group, a manufacturing company based in Nigeria, is embroiled in issues bordering on gender inequality in its 3 regions. The project is focused on uncovering the presence of employee discrimination and inequality --- 1. Project Overview • Problem Statement The recent negative media portrayal of The Palmoria Group as "the Manufacturing Patriarchy" has created a severe reputational crisis that directly endangers the company's strategic growth ambitions. This publicity exposes the organization to significant operational, legal, and brand risks by highlighting perceived systemic gender inequality. The immediate business problem is to objectively diagnose, quantify, and eradicate gender-based disparities across all people processes to safeguard the company's reputation, ensure long-term viability, and build an equitable workplace that facilitates scalable growth. • Objectives: The major objectives of the project is to: • Diagnose Gender Representation Equity • Establish Pay Equity and Identify Gaps • Ensure Performance Management Fairness --- 2. Data Source The data was obtained from hand to hand. Click on the link below to download the raw file Raw file1 Raw file2 --- 3. Business Questions Click on the link below to download the file Business Questions --- 4. Methodology • Tools Used The dashboard was built using the following tools and technologies: i. **Microsoft Excel** – Main data analysis and visualization platform used. ii. **Power Query** – Data transformation and cleaning layer for reshaping and preparing data. iii. **Power Pivot** - Used to create Pivot tables iv **Pivot Table** – Used for analysis v. **File format** - .xlsx for development and .png for dashboards preview • Key Data Cleaning Processes i. Assigned a generic gender status to these employees ii. Took out employees that are without a salary iii. Some departments are indicated as “NULL”. These departments were taken out. • K …