Portfolio Project · Revenue Management Analytics

Hotel Booking
Cancellation & Revenue

Interactive analysis of 117,430 bookings across City Hotel and Resort Hotel. Identifying cancellation drivers, ADR trends, and revenue impact over a 3-year period.

Dataset Kaggle · Hotel Booking Demand
Period 2015 – 2017
Records 117,430
Tools Python · Pandas · Chart.js
Year
Hotel
Total Bookings
117,430
Cancellation Rate
37.6%
Avg ADR (€)
103.4
Revenue Lost (€)
16.7M
Avg Stay (nights)
3.5
ADR Trend by Month
Average Daily Rate per month — 2015 vs 2016 vs 2017
YoY
2015
2016
2017
Bookings Trend by Month
Total bookings per month — 2015 vs 2016 vs 2017
YoY
2015
2016
2017
Cancellation Rate by Hotel
City Hotel vs Resort Hotel
Compare
Revenue by Market Segment
Confirmed bookings only (€)
Revenue
Cancellation Rate by Lead Time
Longer lead time = higher cancellation risk
Risk
Top 10 Countries by Cancellations
Absolute number of cancelled bookings per country
Geo
Cancellation Share by Country
% of total cancellations — top 10 countries
Geo
Bookings by Market Segment
Distribution of total bookings per segment (%)
Segment
Cancellations by Market Segment
Distribution of cancellations per segment (%)
Segment