Business dashboard template: BUSINESS TRAVEL (HOTEL)

/uploads/galerie/000231/Travel Hotel Cockpit.PNG

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 (Hotel): Total Booking Volume, Bookings, Rate, Travelers...

Business Travel (Hotel) Top KPIs Breakdown

Get a transverse view on your top 6 Business Travel (Hotel) KPIs, split by the dimension of your choice

Business Travel (Hotel) Top KPIs Trends

Visualize how your Business Travel (Hotel) KPIs are evolving (Month-to-Date, Year-to-Date)

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

17 KPIs

12 dashboard pages

Detailed presentation of the BUSINESS TRAVEL (HOTEL) dashboard

Your BUSINESS TRAVEL (HOTEL) dashboard will contain 17 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
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

and 12 dashboard pages

Home

Business Travel (Hotel) Home

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

Cockpit

Business Travel (Hotel) Cockpit

Get a complete overview on your Business Travels (Hotel): Total Booking Volume, Bookings, Rate, Travelers...

Business Travel (Hotel) Top KPIs Breakdown

Get a transverse view on your top 6 Business Travel (Hotel) KPIs, split by the dimension of your choice

Business Travel (Hotel) Top KPIs Trends

Visualize how your Business Travel (Hotel) KPIs are evolving (Month-to-Date, Year-to-Date)

Business Travel (Hotel) Performance Cockpit

Visualize the performance on your top 4 Business Travel (Hotel) KPIs, how this performance evolves over time and who contributes to this performance

Travel Analytics

Hotel Traveler Behavior

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

Online Booking Adoption

Visualize the evolution of Online Booking Adoption Rate

GeoAnalytics

Business Travel (Hotel) Country Analysis

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

Business Travel (Hotel) City Analysis

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

Trends Analytics

Business Travel (Hotel) Trends Analysis

Visualize the evolution of any of your Business Travel (Hotel) KPIs: Trends, Performance & Year over Year

Distribution Analytics

Business Travel (Hotel) Segmentation Analysis

Visualize the value of any of your Business Travel (Hotel) KPIs, split by the dimension you selected (market share analysis)

Business Travel (Hotel) Pareto Analysis

Perform a Pareto Analysis on any of your Business Travel (Hotel) KPIs: the 80/20 rule.

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!

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).