This project requires the use of pivot tables, pivot charts, and Tableau

Before solving the project, please read the project background.

Mell Industries hire you as a data scientist. For your first assignment; Ms. Forward, your boss; asked you to use a file (Case_DataSet.xlsx) regarding salaries in the company to answer the following questions:

1. Which occupation has been terminated due to a low total evaluation score? What is the average overall evaluation score for those occupations terminated? What is the average job duration for that occupation in 2017?
2. Why do you think there is a turnover rate for this occupation described in question 1?
3. How many male employees were making more (percentage-wise) than female employees in the $50,001 - $100,000 salary bracket?
4. Employees Evaluation Metrics. Employees are subject to performance evaluations every year based on five different criteria: Knowledge of work, communication skills, teamwork, leadership, and quality of work. Each employee supervisor assesses each employee and prepares a performance report. Based on these performance reports, what can be said about the top ten highest-paid positions? Are the employees being paid fairly based on their evaluation scores? What might be a factor for salary discrepancies?
5. What would be your recommendations to prevent high turnover rates and to solve any salary inconsistencies for each position?

Using Tableau

1. For the following positions, design a chart to compare the average salaries of males and females employees:

• Administrator Purchasing
• Assoc Will Call Center
• Business Specialist
• Category Manager
• Merchandiser
• Sr Eng App Developer
• Stocking Associate
• Warehouse Supervisor

2. Design a chart to represent the difference between the highest paid male and female salaries, along with their evaluation scores.

Ms. Forward wants you to submit thee documents. The Excel file with your data, data preparation, and data analysis. A PDF with the Tableau charts, and a Word document with your detailed description on how you answer each one of the questions and how you designed and built the Tableau charts. If there is missing information, Ms. Forward wants you to state what is missing and how you can overcome that weakness on the data.

C D E F G H J L M N 0 P Q Knowledge of Work Communication Leadership Quality of Work 3 3 Teamwork 2 1 1 1 1 3 1 3 2 2. 3 1 1 00 ou +wNP 2 3 2. 3 1 1 2 1 1 2 7 3 2 3 1 1 3 3 1 1 3 3 1 2 1 3 9 10 11 3 1 3 3 1 2 3 3 2 DATE_OF_BIRTH 5/1/43 4/21/45 3/16/47 2/16/48 8/4/48 1/9/86 2/9/49 2/22/49 4/10/49 2/1/86 3/25/84 5/5/50 12/24/86 8/24/50 9/7/50 2/15/76 10/4/50 10/25/50 12/21/50 2/4/51 2/14/51 5/1/68 12 DATE_OF_HIRE 10/11/75 7/11/90 5/23/81 4/16/92 8/1/89 6/1/15 10/27/94 1/1/98 8/11/99 12/10/07 8/13/08 12/6/95 4/12/12 8/30/90 9/18/97 11/5/03 5/23/81 10/12/94 5/23/81 1/6/97 1/25/90 1/5/00 TERMINATION_DATE OCCUPATION 11/26/90 Stocking Associate $ Stocking Associate $ Stocking Associate $ Warehouse Receiving Asso $ Board Member $ Customer Service Help D $ 3/21/16 Inventory Associate $ Inventory Supervisor $ Marketing Coordinato $ Marketing Coordinato $ 1/8/16 ehouse Receiving Asso $ 10/20/12 Stocking Associate $ Stocking Associate $ Stocking Associate $ 10/19/04 Accountant $ 11/28/08 Accounting Associate $ 11/26/15 Stocking Associate $ 4/13/12 Supervisor $ Stocking Associate $ Senior Category Manage $ 8/20/10 Stocking Associate $ Stocking Associate $ SALARY 24,960.00 20,800.00 24,481.60 23,296.00 60,000.00 37,024.00 22,068.80 54,347.02 54,288.00 54,288.00 24,024.00 21,964.80 26,291.20 26,291.20 35,131.20 35,131.20 21,216.00 59,743.58 21,840.00 86,178.56 22,057.00 22,057.00 2 3 1 1 1 2 13 2 3 3 2 2 3 2 3 3 1 14 15 3 2 3 3 3 3 2 2 2 2 2 1 3 1 2 2 1 3 3 1 3 2 1 3 1 16 17 18 19 20 21 22 23 2 2 2 1 2 3 3 2 3 1 2 1 3 3 2 1 2 1 1 3 7 In ( 1 li(d C D E F G H J L M N 0 P Q Knowledge of Work Communication Leadership Quality of Work 3 3 Teamwork 2 1 1 1 1 3 1 3 2 2. 3 1 1 00 ou +wNP 2 3 2. 3 1 1 2 1 1 2 7 3 2 3 1 1 3 3 1 1 3 3 1 2 1 3 9 10 11 3 1 3 3 1 2 3 3 2 DATE_OF_BIRTH 5/1/43 4/21/45 3/16/47 2/16/48 8/4/48 1/9/86 2/9/49 2/22/49 4/10/49 2/1/86 3/25/84 5/5/50 12/24/86 8/24/50 9/7/50 2/15/76 10/4/50 10/25/50 12/21/50 2/4/51 2/14/51 5/1/68 12 DATE_OF_HIRE 10/11/75 7/11/90 5/23/81 4/16/92 8/1/89 6/1/15 10/27/94 1/1/98 8/11/99 12/10/07 8/13/08 12/6/95 4/12/12 8/30/90 9/18/97 11/5/03 5/23/81 10/12/94 5/23/81 1/6/97 1/25/90 1/5/00 TERMINATION_DATE OCCUPATION 11/26/90 Stocking Associate $ Stocking Associate $ Stocking Associate $ Warehouse Receiving Asso $ Board Member $ Customer Service Help D $ 3/21/16 Inventory Associate $ Inventory Supervisor $ Marketing Coordinato $ Marketing Coordinato $ 1/8/16 ehouse Receiving Asso $ 10/20/12 Stocking Associate $ Stocking Associate $ Stocking Associate $ 10/19/04 Accountant $ 11/28/08 Accounting Associate $ 11/26/15 Stocking Associate $ 4/13/12 Supervisor $ Stocking Associate $ Senior Category Manage $ 8/20/10 Stocking Associate $ Stocking Associate $ SALARY 24,960.00 20,800.00 24,481.60 23,296.00 60,000.00 37,024.00 22,068.80 54,347.02 54,288.00 54,288.00 24,024.00 21,964.80 26,291.20 26,291.20 35,131.20 35,131.20 21,216.00 59,743.58 21,840.00 86,178.56 22,057.00 22,057.00 2 3 1 1 1 2 13 2 3 3 2 2 3 2 3 3 1 14 15 3 2 3 3 3 3 2 2 2 2 2 1 3 1 2 2 1 3 3 1 3 2 1 3 1 16 17 18 19 20 21 22 23 2 2 2 1 2 3 3 2 3 1 2 1 3 3 2 1 2 1 1 3 7 In ( 1 li(d