Hotel Booking Cancellations Dashboard
An interactive Excel dashboard to analyze hotel booking cancellations, uncovering trends over 3 years.
Project Overview
Created an interactive dashboard to analyze hotel booking cancellations. The dashboard provides detailed insights into booking trends, cancellations, and client preferences based on data collected over three years. It uses data visualization to identify patterns and provide actionable insights for improving booking strategies and customer retention.
Data Analysis Workflow
The analytical process moves from raw data to an actionable executive dashboard:
Raw Data
Booking Data
Python EDA
Data Cleaning
Excel
Pivot Tables
Dashboard
Insights
Key Insights Discovered
Every graphic on the dashboard tells a story. Here are the key findings:
City hotels dominate total bookings (67%) but also contribute to the vast majority (76%) of cancellations.
October stands out as the peak month for cancellations.
Desired rooms surprisingly face higher cancellation rates than undesired ones.
Trends can be filtered dynamically by Arrival Date, Year, and Month.
Tools & Technologies
Built completely using foundational data tools:
Microsoft Excel (Pivot Tables, Advanced Charting, Dashboards)
Python (Data Cleaning & EDA)
Data Storytelling & Analytical Thinking
Project Demo
Project Note
Download the Excel dashboard file and dataset from GitHub to explore the complete interactive dashboard locally.