1) Select one of the markets (Austin, Dallas, Denver, or Nashville) and use provided Trend Reports to create a Monthly Occupancy seasonality line chart from January 2014 to May 2019 (Use Trend Report_Raw Data Tab).

2) Use the chart to analyze Occupancy seasonality in the selected hotel market and provide explanations, takeaway points and suggestions to the market stakeholders.

When interpreting the charts, pay attention to the following questions:

How have monthly metrics for various seasons changed over time?

What are the peak months for Occupancy?

What are the potential causes of the peaks and downs?

What are the explanations, takeaway points & suggestions based on the above observations?

Video Instructions for building chart, please use tab 13 on the excel spreadsheet below