Hotel Booking Analysis Dashboard –power bi

An interactive Hotel Booking Dashboard developed using Microsoft Excel to analyze hotel booking performance and customer booking patterns.

The dashboard provides insights into:

Total number of bookings.

Average Daily Rate (ADR).

Total adults and special requests.

Bookings by hotel type: City Hotel vs. Resort Hotel.

Booking trends by arrival day of the month.

Average ADR by hotel type.

Cancellation analysis.

Bookings by market segment.

Interactive filtering by hotel type, arrival year, market segment, and customer type.

The project demonstrates the use of Pivot Tables, KPIs, Charts, Slicers, and Data Visualization to transform hotel booking data into an interactive and easy-to-understand dashboard for business analysis.