CASE STUDY 03 / PYTHON · SQL · EXCEL
Hotel booking & inventory
A planned study of occupancy, cancellations, booking channels, and the patterns behind room demand.
Planned project01
Problem
How do booking channels, lead times, and room categories relate to occupancy, cancellations, and demand?
02
Data
Dataset selection is pending. Booking data will be assessed for the availability and quality of stay dates, room categories, channels, and cancellation fields.
03
Approach
Planned: clean booking records, validate date logic, define room-night measures, and document assumptions around available inventory.
04
Analysis
Planned: examine occupancy where inventory data supports it, cancellation patterns, booking-channel mix, lead times, and seasonal demand.
05
Insights
This project is in the planning stage. Results and limitations will be documented once a dataset has been analyzed.
06
Outcome
Planned deliverables include a booking-performance report and clearly qualified recommendations for inventory and channel decisions.