Goal: reduce cancellations & increase revenue
🔍 What I did:
Cleaned data using Power Query (missing values, types, duplicates)
Fixed an invalid date that could affect the analysis
📈 Key insights:
New customers cancel more than returning ones
Longer lead time = higher cancellation rate
Weekend prices are higher
Customers with special requests are less likely to cancel
Demand increases in Q3 & Q4
Online bookings dominate
💡 Impact:
Better pricing, fewer cancellations, and smarter focus on loyal customers
This project taught me how to turn raw data into real business insights.
