Business Travel (Hotel) | 5e8b-表:Tableau Exchange|桜

Business Travel (Hotel)

299c-表:by Tableau|桜

99e5-表:Description|桜

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

4c7a-表:Features|桜

c0b5-表:Supports data mapping|桜

6d57-表:Resources|桜