GabbyTech17/Palmora-Group-HR-Analysis

The Palmoria Group, a manufacturing company based in Nigeria. # Palmora-Group-HR-Analysis ## The Palmoria Group, a manufacturing company based in Nigeria. ## Project Overview: The Palmoria Group, a manufacturing company based in Nigeria, is embroiled in issues bordering on gender inequality in its 3 regions. Unfortunately, the media recently published the news with the headline “Palmoria, the Manufacturing Patriarchy”. This doesn’t look good for the owners of the business, based on their ambition to scale the business to other regions and even overseas. Cases like this can only spiral downwards, revealing other issues like the gender pay gap, amongst other possible issues. ## Tools Used: Power BI ## Data Cleaning and Preparation: The data was cleaned and prepared using Power Query ## Exploratory Data Analysis: ● Analyze the company data and generate insights that the Palmoria management team would need to address ● Your analysis should be visualised using appropriate charts ● Your focus should be on gender-related issues within the organization and its regions ● The insights required are based on your discretion. However, Mr Gamma, as an insider, has offered to give you pointers on areas you need to pay attention to Required: ● Generally, there are two genders in the organization. However, some employees refused to disclose their gender. You would need to assign a generic gender status to these employees ● Some employees are without a salary because they are no longer with the company. You will need to take those employees out ● Lastly, some departments are indicated as “NULL”. These departments would also need to be taken out. Pointers from Mr Gamma 1. What is the gender distribution in the organization? Distil to regions and departments 2. Show insights on ratings based on gender 3. Analyse the company’s salary structure. Identify if there is a gender pay gap. If there is, identify the department and regions that should be the focus of management 4. A recent regulation was adopted which requires manufacturing companies t …