Business Travel (Hotel)

This Tableau Accelerator allows you to:

• Assess & Optimise the volume of spend related to Hotel bookings
• Ensure that travellers follow booking policies
• Have a clear view of their travellers’ booking behaviour
• Understand how booking in advance impacts the hotel room price
• Identify most booked hotel chains and negotiate better conditions

Demo video

Answer key business questions

• What is our volume of hotel spend?
• How and often do travellers do their booking, and what is their booking behaviour?
• How is the online adoption rate changing? Does it translate into greater savings?
• Which hotel chains are the most booked in terms of volume of reservations?

Monitor and improve KPIs

Booking Volume

• Total Booking Volume: Total amount invoiced for hotel bookings over the period (expressed in currency)
• Number of Bookings: Total number of bookings invoiced over the period
• Number of Nights: Total number of Nights invoiced over the period
• Nights per Booking: Average number of nights per booking invoiced over the period
• Average Room Price: Average price of rooms invoiced during the period (expressed in currency)
• Number of Travellers: Total number of travellers invoiced over the period

Traveller Behaviour

• Number of Bookings Made Online: Total number of bookings made online and invoiced over the period
• OAR - Online Adoption Rate: Share of bookings made online in the total number of bookings invoiced (expressed in %)
• ABW - Advance Booking Window: Average number of days between the booking date and the check-in date. This indicator is used to determine whether reservations are made early enough to benefit from the best prices (expressed in days)
• Lowest Rate Accepted %: Share of bookings made at the lowest rate out of all bookings invoiced over the period (expressed in %)
• Booking Volume per Traveller: Average total expenditure by travellers over the period (expressed in currency)
• Price vs Lowest Rate %: Average difference between the price of rooms at their lowest rate and their actual purchase price (expressed in %)
• Total △ Booking vs Lowest Fare: Total difference between the lowest available rate and the actual price for the room (expressed in currency)
• Average △ Price vs Lowest rate: Average difference between the lowest available rate and the room price (expressed in currency)

Required attributes

• Invoice Date (date): Date of invoice (all calculations and visualisations are based on this date)
• Booking Date (date): Date of booking
• Country PoS (string; role: country): Country from where the booking was done
• Hotel (string): Hotel name
• Hotel Chain (string): Hotel chain name
• Online Booking Flag (string) ← expected values: “Y”, “N”. “Y” is online booking.
• Hotel City (string; role: city): Destination City
• Hotel Country (string; role: country): Destination Country
• Reason Travel (string): Customer meeting, Internal meeting...
• Hotel Check-in Date (date): Hotel check-in date
• Traveller (string): Traveller name
• Lowest Rate Available (numeric): Lowest rate available in this hotel
• Hotel Room Amount (numeric): Actual room price per night
• Hotel Room Nights (numeric): Number of nights there were booked