Hotel chain analyzing booking patterns to reduce cancellation rates

Hospitality / Travel

Booking-pattern and cancellation diagnostics

A diagnostic analysis of cancellation patterns across booking channel, geography, time period, customer segment, and ADR.

Hotel booking cancellation diagnostic dashboard

Challenge

What needed to change

A 32% cancellation rate affected forecasting, but the team lacked a shared view of which channels and segments were associated with the pattern.

Delivery

What was built

A diagnostic dashboard with channel, region, seasonality, segment, and ADR comparisons.

Evidence

What the supplied material supports

  • OTA cancellation rate observed at 39.6%
  • Summer months showed the highest observed cancellations
  • Higher-ADR bookings showed lower observed cancellation rates

Evidence note: These are analytical findings, not a claim that the dashboard reduced cancellations.

Back to portfolio