Update to Air Segments Dashboard

We have deployed an update to the Air Segments dashboard to display the number of international segments in the Airline Market Share and Air Ticket Class graphs.

Previously, the graphs displayed the number of trips based on the destination or turn around point of the itinerary.  This reduced the number of segments displayed in the airline market share and fare class graphs, which confused users expecting to see more segments than trips.

As an example, a trip to the USA (Melbourne to Sydney to Dallas Fort Worth to Washington to Dallas Forth Worth to Melbourne) would have previously displayed as the one trip across all of the graphs.  Now the same trip will display as five segments in the Airline Market Share and Air Ticket Class graphs, and one trip in the Advance Purchase and Destination graphs.

Number of Trips by Destination Graph displaying the number of trips to Countries. Clicking on the bars will drill down to display the destination (or turn around point) of the trip.
Number of Segments by Class of Travel graph displaying the number of segments for travel to and within the USA.  Note how the total number of segments is greater than the number of trips in the destination graph above.

The update also adjusts how international and domestic flights are treated.  Using the itinerary above as an example, the dashboard will now display the Melbourne to Sydney as a domestic segment.  However, in the Excel download, it will appear as international, if the domestic segment is booked as part of an international itinerary.

The Cost of Changes

When a change is made to a booking requiring the ticket to be reissued, most travel management mid office systems have the ability to tag the transaction as an exchange or an additional collection (adcol).  If they can do this, and more often that not they can, we are able to update the original policy code to ‘Exchange Ticket’ when we import data into Travel Analytics.

Identifying exchange tickets in this manner, allows Travel Analytics to display the data in the policy compliance chart within the Global Dashboard, making it simple for the customer to find information on changes.

Moreover, when the customer clicks on the Exchange Ticket segment within the chart, a table opens with a list of all the changes, including: booking reference, traveller name, airline and the cost.  And they can even download the data into Excel.

It is a great feature, and a fast way for customers to access the data they required to understand the cost of changes to the business.

Semi Colon

This is not a grammar lesson but a great tip on how to send downloadable reports to more than one person at the same time.

In the email field within the Report Download Request dialog box, you can enter multiple email addresses by separating them with a semi colon.  For example: john@movetech.com; sam@movetech.com; helen@movetech.com.

Saves downloading the report multiple times or forwarding the report onto your customers or colleagues after you receive it.

Spend by Hotel Download

The accommodation dashboard has two options to download data. The first is the Accommodation Spend Data download, which provides a comprehensive data set if you want to do a warts and all interrogation of the customers hotel data.

However, if you only want a summary of the spend, including: location, hotel name, room nights, spend, average nightly rate and preferred flag, then look no further than the second option – Spend by Hotel Excel download.

It is a great way to get the data you require quickly without having to set up pivot tables to do it.

Printable Report Update

We recently released an update to Printable Reports which enables users to run report by region and division.

This update assists Travel Managers who need to provide organisations printed reports across multiple areas of the business i.e. Region and Divisions.

To utilise this feature, navigate to the Global Dashboard and set the on screen filters to display the data you need in the report.  Click the download button, and select Printable Report from the report (type) drop down in the download box that appears on screen.

Screenshot displaying filter settings which can be used in the downloadable printable reports

When you click Submit, the request will be queued and the report emailed to you once it is processed.

Invoice Search

A big time saver for customers is our invoice search feature. It allows them to look up and download a copy of an invoice issued by the Travel Manager.

To access the feature, click the Search link at the bottom of the slider menu within any Travel Analytics dashboard.

When the link is clicked, a search box opens allowing them to enter details of the invoice they require.  Clicking the search button, opens another window providing a list of invoices that fall within the criteria entered in the previous screen.

To download the invoice, the user simply clicks on the invoice number (link) and it will automatically start to download.

The invoice is a recreation (copy) of the original invoice issued by the Travel Manager. The invoice is ATO compliant, and comes complete with details of the charges and any references the customer uses to track the invoice internally.

Carbon Emission Reporting

Air travel carbon emission reporting is now available to customers with access to the Air Segments dashboard in a downloadable Excel report.  CO2 emissions are shown in kilograms for each flight (or segment) which we calculate using methodology published by the International Civil Aviation Organisation (ICAO) and data sourced from the International Air Transport Association (IATA).

The starting point for calculating emissions is to calculate the circle distance between the city pairs (segments) provided by the Travel Managers in their air segment data.  Segments are then split into three categories: short, less than 550 km; mid, between 550 and 5500 kms; and long haul, greater than 5500 kms.  These categories are used to calculate fuel consumption, as fuel burn ratios are much higher on shorter flights than longer ones.

Extract of the Excel download displaying carbon emission data for individual flight segments

We also factor in a difference between economy and premium class travel for mid and long haul flights but not short haul, as most short duration flights  operate the one class (economy).  Finally, we factor in passenger load data published annually by IATA, however, we do not take into consideration the type of aircraft, as in most cases, the data.

Budget Tracking

The ability to track spend against a travel budget has been around for some time in Travel Analytics.  However, the feature was virtually unknown to most users, due to the complexity of setting it up in the system.

Fortunately, the introduction of Report Hierarchy has simplified the set up, providing customers the opportunity to take advantage of this great feature.

To activate budget tracking, administrators only need to add a figure in the budget column against each cost centre when they are setting up or modifying the customers report hierarchy.

To view the results, users simply navigate to the cost centre dashboard and the data is displayed within the headlines.  It’s pretty easy to determine how budgets are tracking; if the spend is within budget, the amount is shown in black, and if it’s over, it displays in red.

Cost Centre dashboard displaying Budget data

Adjusting the dates on the dashboard, will display a prorated amount for that period.  And using the region and division filters, allows users to drill down to determine how different areas of the business are tracking against budget.

International Destinations

When you select ‘International’ from the trip type filter on the Air Segments dashboard, the chart in the top left of the dashboard displays the number of trips – or stopovers (if we use industry jargon) – within a country i.e. USA, China, United Kingdom etc.

Number of trips displayed by Country

And if you click on the individual countries displayed in the chart, a list of cities (destinations) will appear.

Number of trips displayed by Destination (drill down from the previous display)

The question is how do we determine a destination or stopover?  We use the recognised industry (IATA) standard; any break in a journey for longer than 24 hours is regarded as a stopover.

Fortunately for us, the air segment data we receive from the Travel Managers makes it easy to calculate a stopover, as they provide us the date, arrival and departure times of each segment within the itinerary.  This allows us to calculate the order the flights to determine if the traveller spent longer than 24 hours at a destination.

So when your travel insurance premium is up for renewal, simply log into Travel Analytics and navigate to the Air Segments dashboard, and all the information you need on the number of trips to countries throughout the world is there at your fingertips.

Report Hierarchy

Arguably, Report Hierarchy was the most important enhancement Travel Anaytics deployed in 2016.  In a nutshell, Report Hierarchy allows administrators to download, amend and reload a new organisational structure (report hierarchy) for their data within a matter of minutes.

The functionality is a vast improvement on the traditional method of maintaining report hierarchy, which involves the Travel Manager updating individual traveller profiles within the mid office, reservation and online booking systems.  A process that often takes days, if not weeks to complete.

While the reduction in time and effort are substantial, so to are the improvements in the accuracy of the data presented to the customer.

Often travellers will travel across multiple cost centres belonging to different parts of the organisation.  Traditional travel management systems find it difficult to deal with this, as the traveller profile is linked to a static hierarchy and any variations cannot be matched to the correct structure.

Report Hierarchy turns this issue on its head, as the functionality automatically associates the correct organisational structure to the cost centre entered at the time of booking.

During development, we experimented with customer data with a little over 1500 cost centres, which over two-thirds were duplicates, obsolete, incorrectly entered or missing.  When it gets to this stage, the data becomes unless, forcing customers to manually download and correct the data to make sense of it.

Using Report Hierarchy we were able to download the existing data, remove the duplicates, merge obsolete data, correct mistakes and format the data into the correct hierarchy using the cost centre as a reference point.

Extract from the file used to upload an updated Report Hierarchy. In this example, we are splitting the cost centre to display the number as a code and the abbreviated name as the full name.

Therefore in matter of minutes, data is transformed from being almost unusable to highly structured reports, where little or no manual manipulation is required to get the information the customer needs.

However, cleaning up the data is the first part of the process.  The second part, and more important, is programming the system to identify and clean up rogue data when we import it.  We do this using aisles – you send me ‘HR Head Office’ and I am going to call it ‘Human Resources’.  What’s great about aisles, once it’s corrected, any subsequent errors are updated automatically.