Business dashboard template: BUSINESS TRAVEL (HOTEL)

dashboard template for tableau on General Services Travel Management Business Travel (Hotel) cockpit

Providea workbookcontaining at least14 attributes

Geta ready-to-use,best-in-marketBUSINESS TRAVEL (HOTEL) dashboard

Business Travel (Hotel) Home

Get a Home Page for your Business Travel (Hotel) dashboard

Business Travel (Hotel) Cockpit

Get a complete overview on your Business Travels (Total Booking Volume, Bookings, Rate, Travelers...): What is our volume of Hotel Spend? How and when do travelers do their bookings? To what extent do travelers accept the lowest fare? How many travelers do we have? What are the top Hotel Chains?

Hotel Traveler Behavior

Get a better understanding of travelers behavior when they book hotel rooms

Evolution of Online Booking Adoption Rate

Visualize the evolution of Online Booking Adoption Rate

14 required attributes

Invoice Date
Booking Date
Country PoS
Hotel
Hotel Chain
Online Booking Flag
Hotel City
Hotel Country
Reason Travel
Hotel Check-in Date
Traveler
Lowest Rate Available
Hotel Room Amount
Hotel Room Nights
...add your own attributes!

18 KPIs

8 dashboard pages

Required Attributes

To get your Business Travel (Hotel) dashboard, you need to provide a Tableau workbook file with (at least) the following 5 attributes (the name of your attributes can differ):

Invoice Date Invoice Date (Date used for time-series analysis)
Booking Date Booking Date
Country PoS Country Point of Sales
Hotel Name of the hotel
Hotel Chain Name of Hotel Chain
Online Booking Flag "Y" is online booking
Hotel City Hotel City
Hotel Country Hotel Country
Reason Travel Conference, Training, Relocation...
Hotel Check-in Date Hotel Check-in Date
Traveler Traveler Name, Number, Identifier...
Lowest Rate Available Lowest room rate available
Hotel Room Amount Amount for the hotel room (one night)
Hotel Room Nights Number of nights booked

KPIs

Your Business Travel (Hotel) dashboard will contain 18 KPIs

Total Booking VolumeTotal Booking Volume
Nb of BookingsTotal number of bookings
Nb of NightsTotal number of nights booked
Nights per BookingAverage number of nights per booking
Avg Room PriceAverage room price
ABW - Advance Booking WindowDays between booking date and hotel check-in date
Nb of Tickets (booked online)Total number of tickets booked online
OAR - Online Adoption RateShare of online bookings
Lowest Rate Accepted %Share of bookings where the lowest rate was accepted
Nb of TravelersTotal number of distinct travelers
Booking Volume per TravelerAverage booking volume per traveler
Total △ Booking vs Lowest RateTotal difference between Room Price vs Lowest Rate
Avg △ Ticket vs Lowest RateAverage difference between Room Price vs Lowest Rate
Ticket vs Lowest Rate %Over price vs Lowest Rate in %
Bookings per TravelerAverage number of bookings per Traveler
Nights per TravelerAverage number of nights per Traveler
Destination CitiesTotal number of distinct destination cities
Destination CountriesTotal number of distinct destination countries

Dashboard Pages & Data Visualizations

Your Business Travel (Hotel) dashboard will contain 8 pages

Home

Business Travel (Hotel) Home

Get a Home Page for your Business Travel (Hotel) dashboard

Cockpit

Business Travel (Hotel) Cockpit

Business Travel (Hotel) Top Performers

Get an instant understanding of your top Business Travel (Hotel) performers: current, mid and long term performance

Top 4 KPIs Trends (MTD/YTD)

Visualize how your Performance is evolving (Month-to-Date and Year-to-Date)

Travel Analytics

Hotel Traveler Behavior

Get a better understanding of travelers behavior when they book hotel rooms

Evolution of Online Booking Adoption Rate

Visualize the evolution of Online Booking Adoption Rate

Behavioral Analytics

Business Travel (Hotel) Adhoc Analysis

Perform simple ad-hoc analysis on your Business Travel (Hotel) data set: analyze any of your KPIs across any dimension (trends, distribution and pareto analysis)

GeoAnalytics

Business Travel (Hotel) City Analysis

Visualize the performance of any of your Business Travel (Hotel) KPIs, at City level

Creating your BUSINESS TRAVEL (HOTEL) dashboard Step-by-Step

You want to get a clear understanding on your Business Travel (Hotel) results? You want to build a Tableau dashboard to better understand your Business Travel (Hotel) data?

Using LinPack-for-Tableau.com, you can generate an eye-catching, fit-for-purpose Tableau Dashboard on your Business Travel (Hotel) data in less than 5 minutes!

Business Travel (Hotel) dashboard Live Demo

1st STEP: Create the initial Tableau workbook file

Create a Tableau workbook in which you map your Business Travel (Hotel) data (whether it comes from: ERP, database, Excel, CSV file...)

You must retrieve at least the following attributes (it is ok if the names don't match, and it is better to add additional attributes to analyze):

Invoice Date Invoice Date (Date used for time-series analysis)
Booking Date Booking Date
Country PoS Country Point of Sales
Hotel Name of the hotel
Hotel Chain Name of Hotel Chain
Online Booking Flag "Y" is online booking
Hotel City Hotel City
Hotel Country Hotel Country
Reason Travel Conference, Training, Relocation...
Hotel Check-in Date Hotel Check-in Date
Traveler Traveler Name, Number, Identifier...
Lowest Rate Available Lowest room rate available
Hotel Room Amount Amount for the hotel room (one night)
Hotel Room Nights Number of nights booked

2nd STEP: Upload your Tableau workbook file

On LinPack-for-Tableau.com, select 'create dashboard from template: Business Travel (Hotel)' and upload your Tableau workbook (note: your data is NOT uploaded).

Collapse All Expand All