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

Required Attributes

To get your Business Travel (Air) 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
    Airlines Name of the airlines
  • string
    Booking Class Business, Economy, First...
  • string
    Online Booking Flag "Y" is online booking
  • string
    Origin City Origin City
  • string
    Origin Country Origin Country
  • string
    Destination City Destination City
  • string
    Destination Country Destination Country
  • string
    Reason Travel Conference, Training, Relocation...
  • date
    Travel Start Date Travel Start Date
  • string
    Traveler Traveler Name, Number, Identifier...
  • numeric
    Lowest Available Fare Lowest Available Fare
  • numeric
    Ticket Amount Ticket Amount

KPIs

Your BUSINESS TRAVEL (AIR) dashboard will contain 15 KPIs

Dashboard Pages & Data Visualizations

Your Business Travel (Air) dashboard will contain 9 pages

Home

Business Travel (Air) Home

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

Cockpit

Business Travel (Air) Cockpit

Business Travel (Air) Cockpit
Business Travel (Air) CockpitBusiness Travel (Air) Cockpit
Get a complete overview on your Business Travels (Air spend, Bookings, Fare, Travelers...): What is our volume of Air Spend? How and when do travelers book their tickets? To what extent do travelers accept lowers fare? How many travelers do we have? What are the top routes by Total Air Spend?

Business Travel (Air) Top Performers

Business Travel (Air) Top Performers
Business Travel (Air) Top PerformersBusiness Travel (Air) Top Performers
Get an instant understanding of your top Business Travel (Air) 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

Ticket Price per Advance Booking Window

Ticket Price per Advance Booking Window
Ticket Price per Advance Booking WindowTicket Price per Advance Booking Window
Get a detailed understanding of the impact of Advance Booking on Ticket Price

Air Traveler Behavior

Air Traveler Behavior
Air Traveler BehaviorAir Traveler Behavior
Get a better understanding of travelers behavior when they book tickets

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 (Air) Adhoc Analysis

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

GeoAnalytics

Business Travel (Air) City Analysis

Business Travel (Air) City Analysis
Business Travel (Air) City AnalysisBusiness Travel (Air) City Analysis
Visualize the performance of any of your Business Travel (Air) KPIs, at City level

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

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

Using LinPack-for-Tableau.com, you can generate an eye-catching, fit-for-purpose Tableau Dashboard on your Business Travel (Air) 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 (Air) 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
    Airlines Name of the airlines
  • string
    Booking Class Business, Economy, First...
  • string
    Online Booking Flag "Y" is online booking
  • string
    Origin City Origin City
  • string
    Origin Country Origin Country
  • string
    Destination City Destination City
  • string
    Destination Country Destination Country
  • string
    Reason Travel Conference, Training, Relocation...
  • date
    Travel Start Date Travel Start Date
  • string
    Traveler Traveler Name, Number, Identifier...
  • numeric
    Lowest Available Fare Lowest Available Fare
  • numeric
    Ticket Amount Ticket Amount

2nd STEP: Upload your Tableau workbook file

On LinPack-for-Tableau.com, select 'create dashboard from template: Business Travel (Air)' 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 (Air) dashboard is already downloading :-)

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

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


Other Dashboard Templates