The Raw Data: Arrivals, Overnight Stays and Accommodation Types
This lesson is part of the course
In this lesson
You read a monthly tourism table the way an analyst does: total overnight stays, nights for one accommodation type and arrivals for one month with SUMIFS, and the share one type holds of all nights.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- The Raw Data: Arrivals, Overnight Stays and Accommodation Types Locked
- Average Length of Stay: Nights per Arrival, by Type and Overall Locked
- Bed and Room Occupancy: Capacity, Open Days and Calendar Days Locked
- Seasonality: Monthly Index, Peak and Low Season, Peak-to-Trough Ratio Locked
- Year over Year: Change %, Same-Period Comparisons and Contributions to Growth Locked
- Tourism Intensity: Nights per 1,000 Residents, per km² and Rankings Locked
- A Simple Projection: Linear Trend, Trend Factor and Next Season by Month Locked
- The Regional Report: KPI Table, Top-3 List and a Chart Locked