Hotel Booking Analysis Dashboard | Microsoft Excel

Project Overview This project presents an end-to-end Hotel Booking Analysis built entirely in Microsoft Excel. The analysis follows a complete data analytics workflow, from raw data cleaning to building an interactive business dashboard. Project Workflow ✔ Data Cleaning & Validation ✔ Missing Value Handling ✔ Calculated Columns ✔ Pivot Tables ✔ Pivot Charts ✔ Business Insights ✔ Interactive Dashboard Key Business Questions Overall booking cancellation rate Booking distribution by hotel Cancellation rate by hotel Monthly booking trend Revenue by guest type Revenue by season Cancellation rate by market segment Cancellation rate by lead time Revenue loss due to cancellations Dashboard Features Interactive Slicers KPI Cards Dynamic Charts Professional Dashboard Design Business Recommendations Tools Used Microsoft Excel Pivot Tables Pivot Charts Excel Functions Slicers Conditional Formatting Files Included Excel Workbook Interactive Dashboard Pivot Tables Business Insights Documentation