Optimizing Hotel Bookings

Objectives & Precedents

• A Portuguese hotel chain has resorts in Lisbon and Algarve.
• They have analyzed data and identified some interesting insights and recommendations that they would like to share with their leadership team.
• However, they are worried that their presentation may not effectively communicate the findings as all they have are PivotTables in a workbook.
• Therefore, they are seeking help to design a dashboard that can clearly convey the insights

Key Objectives

1. Visualize each insight effectively.
2. Use color consistently & deliberately
3. Leverage dashboard layout & text to clearly communicate key insights and business recommendations

Dataset Summary

• Hotel booking data, from July 2015 to August 2017
• Dimensions: Booking ID, Hotel, Booking/Arrival Date, Distribution Channel, Customer Type, Country, Deposit Type, Status, Status Update, Cancelled (0/1)
• Measures: Lead Time, Nights, Guests, Revenue, Loss