The company planned to provide employees hired before June 1, 2020 with a 4% Cost of Living Adjustment (COLA) increase.
others
Description
Group Tableau Assignments
Assignment #4: Compensation
The company planned to provide employees hired before June 1, 2020 with a 4% Cost of Living Adjustment (COLA) increase. However, with the additional resources required to meet the increase in Sales, the teams needs to analyze if the budget needs to be adjusted to
Graph Tips:
• Remember to change the Performance Rating field from SUM to AVE (Average)
• To change from SUM to AVERAGE click on the white arrow once you place the field in
either the COLUMN OR ROW
Graph Tips:
• Round the numbers up to the nearest whole number for both graphs.
14
accommodate the annual COLA. Also, the team will analyze if there are GENDER disparities in pay.
Graph #1: is there enough in the Compensation area of the budget to provide a COLA increase to current employees hired before June 1, 2020?
Graph #2: Are there any disparities in AVERAGE pay in the departments by EMPLOYEE LEVELS?
Please send me the tableau files and the word document once completed. Ensure that the information is simple, easy to read, and like the example provided.
