The Regional Report: KPI Table, Top-3 List and a Chart
This lesson is part of the course
In this lesson
You complete a regional KPI table with average length of stay and yearly bed occupancy, build a top-3 list with LARGE and INDEX/MATCH and chart the nights by region for the annual report.
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