1.Time-Series Occupancy Tracking
Time-Series Analysis · 2026
A revenue analyst generated a dashboard to automate reporting from raw reservation data, displaying daily occupancy metrics. The "Overall Daily Occupancy Timeline" tracks "Rooms occupied" from July 2015 through late 2017, showing fluctuations between roughly 50 and 400 rooms. A 30-day rolling average highlights seasonal peaks near 400 rooms in mid-2016 and mid-2017, and troughs below 200 rooms around January 2016 and January 2017. A stacked area chart breaks this down, showing a Resort Hotel maintaining a baseline just under 200 rooms, while a City Hotel drives the volatility up to the 400-room maximum.
What it shows:
How to expand individual date ranges into a continuous daily time series for capacity planning.




