Business Travel (Hotel)

The Tableau Accelerator for Business Travel (Hotel) helps give you data-driven insights into your hotel travel spend. Travel managers can use this Accelerator to:

• Efficiently manage their hotel travel program by optimizing costs and ensuring that travelers follow booking policies
• Have a clear view of their travelers' booking behavior
• Understand how booking in advance impacts the hotel room price
• Identify most booked hotel chains and negotiate better conditions

Answer key business questions

• What is our volume of hotel spend?
• How and often do travelers do their booking, and what is their booking behavior?
• 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

• Total Booking Volume
• Nb of Bookings
• Nb of Nights
• Nights per Booking
• Avg Room Price
• Nb of Tickets (booked online)
• ABW - Advance Booking Window
• OAR - Online Adoption Rate
• Lowest Rate Accepted %
• Nb of Travelers
• Total △ Booking vs Lowest Rate
• Avg △ Ticket vs Lowest Rate
• Destination Cities
• Destination Countries
• Booking Volume per Traveler
• Ticket vs Lowest Rate %
• Bookings per Traveler
• Nights per Traveler

Required attributes

• Invoice Date (date)
• Booking Date (date)
• Country PoS (string)
• Hotel (string)
• Hotel Chain (string)
• Online Booking Flag (string)
• Hotel City (string)
• Hotel Country (string)
• Reason Travel (string)
• Hotel Check-in Date (date)
• Traveler (string)
• Lowest Rate Available (numeric)
• Hotel Room Amount (numeric)
• Hotel Room Nights (numeric)