Hotel Bookings Cancellation Data Analysis Project

Overview

Welcome to the Hotel Bookings Cancellation Data Analysis project repository! This project involves an in-depth analysis of hotel booking cancellations using Excel. The dataset contains essential columns that shed light on the dynamics of hotel bookings and cancellations.

Dataset Columns

• hotel: Type of hotel (e.g., Resort Hotel, City Hotel)
• is_canceled: Cancellation status (0 for not canceled, 1 for canceled)
• arrival_date_year: Year of arrival
• arrival_date_month: Month of arrival
• ... (other columns listed)

Project Tasks

1. Understanding the Business Problem: Initial exploration of the hotel booking industry and the implications of cancellations.
2. Data Cleaning and Preparation: Ensured data accuracy through handling missing values, outliers, and formatting.
3. Pivot Tables and Charts:
   • Cancellation by Marital Status
   • Cancellation by Room Status
   • Month-wise Cancellation Trends
   • Comparison of Cancellation Rates by Hotel Type
4. Interactive Dashboard: Designed an intuitive dashboard for visually conveying analysis findings.

Getting Started

1. Clone the repository.
2. Open the provided Excel file containing dataset and analysis.
3. Explore sheets for data, pivot tables, charts, and the interactive dashboard.

Feel free to contribute, provide feedback, or leverage the insights for your use. Happy analyzing!