Excel Dashboard & Data Analysis for Business Insights

# Hotel Booking Data Analysis & Interactive Excel Dashboard

I provide professional data analysis services using Microsoft Excel, transforming raw hotel booking data into meaningful insights through data cleaning, analysis, and interactive dashboards.

**The project includes:**

* Importing and exploring the dataset to understand each column and its values.

* Cleaning the data by removing duplicates, handling missing values, standardizing text fields, and identifying date inconsistencies.

* Creating calculated columns such as Total Stay Nights, Guest Type, Total Guests, Revenue per Booking, Booking Status, Lead Time Category, Payment Risk, and other useful metrics.

* Building Pivot Tables to answer key business questions and uncover valuable insights.

* Designing professional charts to visualize trends, performance, and customer behavior.

* Developing a fully interactive Excel Dashboard with KPIs including Total Bookings, Total Revenue, and Cancellation Rate, along with slicers and filters for Hotel Type, Year, Customer Type, and other dimensions.

* Delivering a clean, well-organized, and visually appealing Excel workbook with a modern color palette and user-friendly design.

The final deliverable is a professional Excel file containing cleaned data, calculated fields, Pivot Tables, insightful visualizations, and an interactive dashboard to support data-driven decision-making.