Revenue 2024
€4.03M
-12% YoY
Revenue contracted compared to 2023, requiring a deeper analysis of the drivers behind the decline.
Executive Snapshot
The key numbers behind the analysis.
A concise overview of the main findings from the 2023–2024 comparison: revenue decline, lower occupancy, OTA dependency and reduced profitability per available room.
Occupancy Rate
78%
-11% YoY
Occupancy decreased, with the strongest deterioration occurring in the final part of the year.
OTA Share
45%
Main channel
OTA channels dominate the booking mix, highlighting a strong dependency on intermediated distribution channels.
RevPAR 2024
€408
-13% YoY
Revenue per available room decreased, making profitability monitoring a key revenue management priority.
Lead Time Avg
45 days
Booking behavior
Lead time analysis helped interpret demand patterns and the impact of last-minute bookings.
Contest Result
1st place
Winning project
The dashboard was awarded for data storytelling, KPI clarity and decision-support effectiveness.
Dashboard Preview
A complete view of hotel performance
The dashboard combines revenue analysis, occupancy trends, booking channels and profitability metrics into one decision-oriented view.
Click the dashboard to view it in full screen.
Context
Understanding a market in constant evolution
Hospitality is shaped by seasonality, dynamic pricing and increasingly fragmented booking channels. To properly evaluate hotel performance, looking at revenue alone is not enough: occupancy, ADR, RevPAR, lead time and channel distribution must be connected into a single analytical view.
Business Challenge
The critical issues to solve
The 2024 analysis highlights three critical areas: declining revenue, dependency on intermediated channels and pressure on profitability.
Revenue Decline
Year-over-year revenue decline required a clear understanding of the root causes behind the contraction.
OTA Dependency
The strong weight of intermediated channels may affect margins and reduce commercial control.
Margin Reduction
RevPAR decline required integrated monitoring of ADR, occupancy and profitability dynamics.
Analytical Approach
From raw data to decision-ready insight.
The project was developed through a structured analytical process: from defining hospitality KPIs to reading performance gaps and generating operational recommendations.
KPI Definition
Selection of core metrics to measure performance, profitability and demand behavior.
YoY Analysis
Comparison between 2023 and 2024 to identify trends, gaps and critical performance signals.
Channel Analysis
Analysis of the booking mix to evaluate the weight of intermediated channels and the contribution of direct channels.
Insight Generation
Translation of the analysis into actionable insights for pricing, distribution and revenue management decisions.
Solution Developed
A dashboard designed to turn data into decisions.
The dashboard was developed to support decision-making in the hospitality sector by combining performance indicators, booking channel analysis and demand dynamics into one strategic view.
- Revenue, ADR, RevPAR and Occupancy monitoring
- Booking channel performance analysis
- Booking window and lead time analysis
- Year-over-year comparisons and seasonal trends
- Identification of risks and growth opportunities
- Strategic insights and data-driven recommendations
Performance
Channels
Profitability
KPI Framework
Every critical metric in the right context.
Dashboard indicators were organized into three analytical areas: economic performance, booking behavior and channel distribution.
Area 01
Performance
Measures the hotel’s economic performance and its ability to generate revenue against available occupancy.
Revenue • Occupancy • ADR • RevPAR
Area 02
Booking Behavior
Analyzes demand behavior, booking lead time and the mix of room categories sold.
Lead Time • Booking Window • Room Mix • Demand
Area 03
Distribution
Highlights the weight of booking channels in the revenue mix and helps evaluate OTA dependency, direct performance and commercial control.
Channel Mix • OTA • Website • CRO
INSIGHT & RECOGNITION
From performance analysis to an award-winning dashboard
The comparison between 2023 and 2024 made the decline in revenue, changes in occupancy and the weight of booking channels easier to interpret. The dashboard brought these signals together in a decision-oriented view and achieved 1st place in the 2024 “In viaggio coi dati” contest.
0
OTA share in 2024
0
KPIs integrated into the dashboard
0
2024 revenue change vs 2023
0
"In viaggio coi dati" 2024 contest
Do you have data to turn into a decision-ready dashboard?
I design Power BI dashboards and data storytelling solutions that make KPIs, trends and insights immediately usable for business decisions.
Free Consultation
Tell me about your project
Fill in the form and briefly describe your needs. I will get back to you to understand how to make your KPIs, reports and dashboards clearer.