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

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

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

KPIs

Your Business Travel (Hotel) dashboard will contain 18 KPIs

Dashboard Pages & Data Visualizations

Your Business Travel (Hotel) dashboard will contain 8 pages

Home

Business Travel (Hotel) Home

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

Cockpit

Business Travel (Hotel) Cockpit

Business Travel (Hotel) Cockpit
Business Travel (Hotel) CockpitBusiness 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?

Business Travel (Hotel) Top Performers

Business Travel (Hotel) Top Performers
Business Travel (Hotel) Top PerformersBusiness 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)

Top 4 KPIs Trends (MTD/YTD)
Top 4 KPIs Trends (MTD/YTD)Top 4 KPIs Trends (MTD/YTD)
Visualize how your Performance is evolving (Month-to-Date and Year-to-Date)

Travel Analytics

Hotel Traveler Behavior

Hotel Traveler Behavior
Hotel Traveler BehaviorHotel Traveler Behavior
Get a better understanding of travelers behavior when they book hotel rooms

Evolution of Online Booking Adoption Rate

Evolution of Online Booking Adoption Rate
Evolution of Online Booking Adoption RateEvolution of Online Booking Adoption Rate
Visualize the evolution of Online Booking Adoption Rate

Behavioral Analytics

Business Travel (Hotel) Adhoc Analysis

Business Travel (Hotel) Adhoc Analysis
Business Travel (Hotel) Adhoc AnalysisBusiness 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

Business Travel (Hotel) City Analysis
Business Travel (Hotel) City AnalysisBusiness 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!

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

  • date
    Invoice Date Invoice Date (Date used for time-series analysis)
  • date
    Booking Date Booking Date
  • string
    Country PoS Country Point of Sales
  • string
    Hotel Name of the hotel
  • string
    Hotel Chain Name of Hotel Chain
  • string
    Online Booking Flag "Y" is online booking
  • string
    Hotel City Hotel City
  • string
    Hotel Country Hotel Country
  • string
    Reason Travel Conference, Training, Relocation...
  • date
    Hotel Check-in Date Hotel Check-in Date
  • string
    Traveler Traveler Name, Number, Identifier...
  • numeric
    Lowest Rate Available Lowest room rate available
  • numeric
    Hotel Room Amount Amount for the hotel room (one night)
  • numeric
    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).

3rd STEP: Map your attributes

Map the attributes of your workbook on the attributes of the template.

Finally, click 'Confirm & Download'... and your Business Travel (Hotel) dashboard is already downloading :-)

Open the Tableau workbook file you received, it will automatically reconnect to your data sources.

Your Business Travel (Hotel) dashboard is now ready to be used or customized!


Other Dashboard Templates