Based on the data below please help to complete this question. Thank you.

Hotel Chain: Ritz Carlton

1.Financial Perspective:

Strategic Objective 1: Increase revenue per room occupied (RevPAR)

Measure: RevPAR

Target: To achieve a year-over-year (YOY) increase in RevPAR by 5%

Strategic Objective 2: Improve occupancy rate

Measure: Occupancy rate

Target: To achieve a YOY increase in occupancy rate by 3%

2. Customer Perspective:

Strategic Objective 1: Improve customer satisfaction

Measure: Customer satisfaction score (CSS)

Target: To achieve a YOY increase in CSS by 4%

Strategic Objective 2: Increase repeat business

Measure: Repeat business rate

Target: To achieve a YOY increase in repeat business rate by 2%

3. Internal Business Process Perspective:

Strategic Objective 1: Streamline processes for improved efficiency

Measure: Employee efficiency rate

Target: To achieve a YOY increase in employee efficiency rate by 5%

Strategic Objective 2: Improve inventory management

Measure: Inventory turnover rate

Target: To achieve a YOY increase in inventory turnover rate by 10%

4. Learning and Growth Perspective:

Strategic Objective 1: Enhance employee training and development

Measure: Employee training and development score

Target: To achieve a YOY increase in employee training and development score by 3%

Strategic Objective 2: Encourage innovation and creativity

Measure: Innovation rate

Target: To achieve a YOY increase in innovation rate by 5%

By setting these strategic objectives and corresponding measures and targets, Ritz Carlton can ensure that it is not only meeting its financial goals but also providing the highest level of customer satisfaction, improving its internal processes, and investing in its employees and innovation. The targets set for each objective will serve as a benchmark for performance and provide a clear understanding of what is expected in terms of growth and improvement. By tracking these measures and evaluating progress towards the targets, Ritz Carlton can continually make data-driven decisions to ensure the success of its business.

Use Tableau to plot a visualisation chart for each of the measures suggested in part (a) (total 8 charts), and provide a screenshot of each chart with a meaningful title. Discuss why each chart is appropriate for its corresponding measure and a conclusion drawn in 4-5 lines below each respective screenshot of the chart. (Write up to 750 words) You will need to create your own datasets using the information on corporate website as a starting point but you can also obtain relevant data from other online sources (if available). (40 marks)