Hotel Booking Cancellation Dashboard

📊 Total Bookings

36,274

Dataset size

❌ Cancellation Rate

32.76%

11,885 canceled bookings

💰 Average Price

$103.37

Per room

⚠️ Revenue at Risk

$4.22M

38.1% of potential

Booking Status Distribution

Cancellation Rate by Season

🎯 Driver #1: Lead Time Impact (Correlation: 0.44)

⚡ Key Finding: Bookings made 365+ days in advance have 59.8% cancellation rate

🎯 Driver #2: Market Segment Performance

⚡ Key Finding: Corporate bookings have only 10.6% cancellation (most reliable!)

🎯 Driver #3: Special Requests (Protective Factor!)

⚡ Key Finding: Guests with special requests are 2.5x more committed

🎯 Driver #4: Price Category Impact

⚡ Key Finding: Premium rooms ($125-150) have 41.4% cancellation rate

📅 Monthly Cancellation Trends

Peak season (summer) shows highest cancellation rates

📊 Bookings vs Cancellations by Month

🔴 HIGH PRIORITY Recommendations

1. Implement Deposit Policy

Require deposits for bookings >90 days lead time

💰 Impact: $150K-200K annual savings

2. Encourage Special Requests

Add prominent UI prompts during booking

💰 Impact: 10-15% cancellation reduction

3. Dynamic Cancellation Policies

Stricter policies for summer, flexible for winter

💰 Impact: 5-10% seasonal improvement

4. Re-engagement Campaigns

Automated emails at 60/30/14 days before arrival

💰 Impact: 5-8% cancellation reduction

💰 Revenue Impact Analysis

💡 Key Business Insights

Lead Time is #1 Driver: Each 30-day increase in lead time raises cancellation risk by 5-10%
Special Requests = Commitment: Guests making requests are 2.5x more likely to show up
Corporate Segment Gold: Only 10.6% cancellation vs 36.6% for online bookings
Summer Challenge: 40.6% cancellation in summer vs 14.9% in winter
Premium Pricing Issue: Luxury rooms have 49.2% cancellation - needs strategy review
Quick Win Available: Implementing 4 high-priority actions could recover $400K-600K annually

🏨 Hotel Booking Cancellation Dashboard