Yiwei Bao

Back to portfolio

Business Analytics

Hotel Booking Cancellation Analysis

Identify booking-risk patterns through cancellation analysis to help hotel teams improve channel strategy and reservation policy.

Focus

Revenue Risk

Lens

Booking Behavior

Use

Ops Decisions

Problem Statement

Hotel cancellations directly affect occupancy forecasting, revenue planning, and staffing decisions, so the main drivers of cancellation need to be identified clearly.

Key Finding

Lead time, room choice, and booking channel often combine to shape cancellation risk, which means a single uniform cancellation policy may be inefficient.

Business Context

Cancellation analysis works well in a portfolio because it ties directly to revenue, staffing, and inventory management.

This case can show how you start with a common business metric and trace it into a more specific operational explanation.

Analytical Angle

If you add charts later, the strongest views will likely compare channel mix, lead-time groups, price bands, and cancellation rates.

That structure makes the page read partly like a project retrospective and partly like a compressed business report.