Hotel Booking Data

● The dashboard was made with Excel and has four pages:

▷ Overview --> Total bookings, guests, cancellation rate, revenue, and reservation status by hotel

▷ Guests --> Guest breakdown by type, repeat guests, room bookings, and monthly trends

▷ Booking --> Market segment performance and customer type across regions

▷ Cancellation --> Cancellation patterns by hotel, market segment, lead time, and deposit type

Last step was pulling the charts together into one dashboard with navigation links between pages.

Some numbers that stood out: 117,428 total bookings, €25.99M in revenue, and a 37.48% cancellation rate — higher for the City Hotel than the Resort Hotel.