1.Automating Daily Occupancy Time Series
Hospitality Analytics · 2026
A revenue analyst generated a dashboard to display daily hotel occupancy metrics, automating reporting from raw reservation data to solve the manual expansion of individual booking date ranges into a continuous daily time series. The interface features a line chart tracking rooms occupied from July 2015 through late 2017, overlaid with a 30-day rolling average highlighting seasonal peaks near 400 rooms and troughs below 200 rooms. Additionally, a stacked area chart breaks down total occupancy between a Resort Hotel and a City Hotel, while a calendar heatmap visualizes daily room counts up to 400 for August and September 2017.
What it shows:
How to transform individual booking date ranges into continuous occupancy timelines.




