Embedded Files
EMPLOYEE ANALYSIS FOR PALMORIA GROUP
EMPLOYEE ANALYSIS FOR PALMORIA GROUP
The company's HR data was analyzed and data was visualized using appropriate charts. Recommendations concerning gender inequality was made. Some employee who refused to disclose their gender was assigned a generic one and employees who are no longer with the company was taken out. Lastly, departments indicated as 'Null' was taken out.
The company's HR data was analyzed and data was visualized using appropriate charts. Recommendations concerning gender inequality was made. Some employee who refused to disclose their gender was assigned a generic one and employees who are no longer with the company was taken out. Lastly, departments indicated as 'Null' was taken out.
Note: Data was cleaned properly before being worked on.
TASK;
What is the gender distribution in the organization with respect to regions and department.
Show insights on rating based on gender
.From the company's salary structure, what is the gender pay gap.
identify the department and regions with the highest pay gap.
Show the pay distribution of employees grouped by a band of $10,000 difference
in case a %5 bonus was decided to be added to their salary, calculate the bonus amount to be paid to individual employers, calculate the total salary of each individual employer and total amount to be paid out per gender and region.
A description of the images you are showcasing for your project, your process and the artefacts you created along the way
A description of the images you are showcasing for your project, your process and the artefacts you created along the way
Gender distribution by department
Gender distribution by department
Gender distribution by region
Gender distribution by region
Total payout per region
Total payout per region
Ratings by gender
Ratings by gender
Pay gap by department and region with reference to gender
Pay gap by department and region with reference to gender
Employee pay group by region
Employee pay group by region
From the insight generated, the company was able to make a more informed decision on the issue of gender equality of the current and subsequent employees.
SALES INSIGHT FOR SUNRISE LIMITED
The company's financial data was analyzed and sales insight was generated. Raw data was in CSV format and was delimited to include rows and columns before being transferred for cleaning. Empty columns were deleted and null values were checked. Data was cleaned thoroughly before being loaded to the dashboard interface. New measure was created where necessary.
Task;
What is the sales before discount.
What is the total sales.
What is the total profit for each year.
Estimate a 25 % profit projection.
What is the sales and profit for each quarter of the year and which quarter of the year did the company make the highest and lowest profit profit.
Which month did the company make the highest and lowest sales.
Which economic sector did the highest and lowest sales come from.
In which country did the company make he highest sales.
What is the top 3 products that the company sold.
What is the bottom 3 products that the company sold.
Sales by month
Sales by month
Sales by segment
Sales by segment
Sales and profit by quarter
Sales and profit by quarter
Sales and profit by month
Sales and profit by month
The top 3 products
The top 3 products
The bottom 3 products
The bottom 3 products
From the insight generated, the company was able to make a more informed decision on the financial standing of the organization.
Page updated
Google Sites
Report abuse