Versions Compared

Old Version 4

changes.mady.by.user Marie-Line Ardito

Saved on

compared with

New Version Current

changes.mady.by.user Cornemillot, Charlotte

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.





Info
iconfalse
titleProcess Owner
Excellence Center Demand Management & Purchasing


Info
iconfalse
titleT&E Expert
Claire Boursier


Info
iconfalse
titleD&PS Expert
Marie-Line Ardito


add screenshot of the dashboard with Numbers of final version in Qlik

Restricted on Scope, information at employee level


Info
iconfalse
titleTarget Users
  • ExCom
  • Leadership team
  • Financial Directors
  • Purchasing Function
  • Controllers


Info
iconfalse
titleAuthorization & Rights
All the accesses must be validated by:
Excellence Center / Purchasing
Click here for the Access form to get access to the T&E Dashboard.
Current authorizations are available on this file.

add screenshot of the dashboard with Numbers of final version in Qlik

This page will diplay data based on O&D (origin - Destination) basis, meaning a Oneway ticket
.
 



Restricted on Scope

Nb

NameSourceCalculationComments
1
Image Added
Air Overview
  • Total Spend
  • Number of O&D
  • Average O&D cost
AmexGBT- O&D
Filter on Primary product code ="Air"
Spend =
Column 1 : Origin -Destination (non directional)
Column 2: ∑O&D Net Amount
Number of O&D = ∑ O
"Selection"
Column 3: ∑O&D Net Count
Average O&D cost=
"Selection"
Column 4: % of ∑O&D Net Amount
/ ∑ O&D Net Count 2
"Selection" for each Origin - Destination
Column 5: Average cost per Origin - Destination "Selection"
Column 6: Average cost per Origin - Destination "Solvay
NB: 2 Origin - Destination = 1 roundtrip
Image Added
Volume per airlines alliances
AmexGBT-
O&D
Spend Analysis
Filter on Primary product code ="Air"
∑O&D
∑Air Net Ticket Count in % of airline alliances (or number of tickets per airline alliances)
This metric has 2 dimensions: % or number of tickets
3
Image Added
Air tickets volumes : Domestic/Regional vs Intercontinental
AmexGBT- Spend Analysis
Filter on Primary product code ="Air"
5
∑Air Net Tickets in % of "Regional or Intercontinental"
4Air Routes OverviewAmexGBT- O&D

Filter on Primary product code ="Air"

Column 1 : Origin -Destination (non directional)

Column 2: ∑O&D Net Amount "Selection"

Column 3: ∑O&D Net Count"Selection"

Column 4: % of ∑O&D Net Amount "Selection" for each Origin - Destination

Column 5: Average cost per Origin - Destination "Selection"

Column 6: Average cost per Origin - Destination "Solvay

NB: 2 Origin - Destination = 1 roundtrip

Image Added
Air Tickets volume per booking class
AmexGBT-
O&D∑O&D
Spend Analysis
Filter on Primary product code ="Air"
∑Air Net Ticket Count in % of "Class of Service - Invoice (Predominant)
∑O&D Net Amount in % of "Class of Service - Invoice (Predominant)
6

Rail Overview

    • Total Spend
    • Number of O&D
    • Average O&D cost
AmexGBT- O&D

Image Added

Air ticket details amount above X EURAmexGBT- Spend Analysis

Filter on Primary product code ="

Rail

Air"

Spend = ∑O&D Net Amount

Number of O&D = ∑ O&D Net Count

ATP= ∑O&D Net Amount / ∑ O&D Net Count

Details at ticket & traveler level, including Class of Service

One ticket = 2 O&D
Image Added
Rail Overview
    • Total Spend
    • Number of O&D
    • Average O&D cost
7Rail Routes Overview
AmexGBT- O&D
Filter on Primary product code ="Rail"
Column 1 : Origin -Destination (non directional)
Column 2: ∑O&D Net Amount "Selection"
Column 3: ∑O&D Net Count"Selection"
Column 4: % of ∑O&D Net Amount "Selection" for each Origin - Destination
Column 5: Average cost per Origin - Destination "Selection"
Column 6: Average cost per Origin - Destination "Solvay
NB: 2 Origin - Destination = 1 roundtrip
8
Image Added
Hotel Overview*
  • Booked amount
  • Number of nights
  • Average daily rate
AmexGBT - Hotels

Booked amount = ∑Period 1 Hotel Booked Amount

Nights = ∑ Period 1 Hotel Room Nights

ADR = ∑Period 1 Hotel Booked Amount/∑ Period 1 Hotel Room Nights

9Volumes per Hotel Chains (based on number of nights)*AmexGBT - Hotels∑ Period 1 Hotel Room Nights in % of Hotel Chain
10Hotel Bookings Overview*
AmexGBT - Hotels
Column 1 : Hotel City
Column 2: ∑Period 1 Hotel Booked Amount "Selection"
Column 3: ∑ Period 1 Hotel Room Nights "Selection"
Column 4: % of ∑Period 1 Hotel Booked Amount "Selection" for each Hotel City
Column 5: Average cost per Hotel City "Selection"
Column 6: Average cost per Hotel City "Solvay
1113Car rental Overview*AmexGBT - Car rental by city

Image Added
Car Overview*
  • Booked Amount
  • Number of days
  • Average daily rate
AmexGBT - Car rental by city

Booked amount = ∑Period 1 Car Booked Amount

Days = ∑ Period 1 Car Days

ADR= ∑Period 1 Car Booked Amount/∑ Period 1 Car Days

12Volumes per Car Rental Companies (based on number of days)*AmexGBT - Car rental by city

∑ Period 1 Car Days in % of Car Rental Vendor

Column 1 : Rental City
Column 2: ∑Period 1 Car Booked Amount"Selection"
Column 3: ∑ Period 1 Car Days "Selection"
Column 4: % of ∑Period 1 Car Booked Amount"Selection" for each Rental City
Column 5: Average cost per Rental City "Selection"
Column 6: Average cost per Rental City "Solvay

* booking costs might be different from final invoiced costs
NbNameSourceCalculationComments
1.1
1.2
1.3
1.4
Book Online KPI vs N-1
Details
Quarterly/Monthly evolution
Non Compliant Travelers (Online eligible)
AmexGBT- Spend Analysis
always filter on Primary product code ="Air"
∑Air Net Tickets YTD N with booking channel = "Online" / ∑ Air Net Tickets YTD N
vs ∑Air Net Tickets N-1 with booking channel = "Online" / ∑ Air Net Tickets N-1
Eligible Online = Yes if "Country (Point of Sale)" ≠ "India" ≠ "China" ≠"Taiwan" ≠" Latvia" and Primary Product Code ≠ "C" ≠"J"
Tickets Booked = ∑Air Net Tickets YTD N
Main non-compliant countries = Top 3 countries with lowest compliance to KPI (based on absolute value
∑Air Net Tickets "Selection" with booking channel = "Online" / ∑ Air Net Tickets "Selection" per period (quarter or month)

∑Air Net Tickets YTD N with booking channel = "Offline" & "Eligible" = Yes; sorted per traveler (descending)
Compliance evolution over time based on selection Month/Year
This metric has 2 dimensions: Month / Quarter
2.1
2.2
2.3
2.4
Book in Advance KPI vs N-1
Domestic & Regional Flights (min 14 days)
Details
Quarterly/Monthly evolution
Non Compliant Travelers
always filter on Primary product code ="Air" & Filter on "Regional or Intercontinental" = "Domestic - Regional"
∑Air Net Tickets YTD N with compliance = "Yes" / ∑ Air Net Tickets YTD N
vs ∑Air Net Tickets N-1 with compliance = "Yes" / ∑ Air Net Tickets N-1
∑Air Net Tickets "Selection" with compliance = "no"
Count number of travelers (no duplicate) with compliance = "No" (XX% represents 80%)
∑Air Net Tickets "Selection" with compliance = "Yes" / ∑ Air Net Tickets "Selection" per period (quarter or month)
∑Air Net Tickets YTD N with compliance = "No" sorted per traveler (descending)
Compliance evolution over time based on selection Month/Year
This metric has 2 dimensions: Month / Quarter
3.1
3.2
3.3
3.4
Book in Advance KPI vs N-1
Intercontinental Flights (min 21 days)
Details
Quarterly/Monthly evolution
Non Compliant Travelers
always filter on Primary product code ="Air" & Filter on "Regional or Intercontinental" = "Intercontinental"
∑Air Net Tickets YTD N with compliance = "Yes" / ∑ Air Net Tickets YTD N
vs ∑Air Net Tickets N-1 with compliance = "Yes" / ∑ Air Net Tickets N-1
∑Air Net Tickets "Selection" with compliance = "No"
Count number of travelers (no duplicate) with compliance = "No" (XX% represents 80%)
∑Air Net Tickets "Selection" with compliance = "Yes" / ∑ Air Net Tickets "Selection" per period (quarter or month)
∑Air Net Tickets YTD N with compliance = "No" sorted per traveler (descending)
Compliance evolution over time based on selection Month/Year
This metric has 2 dimensions: Month / Quarter
4.1
4.2
4.3
4.4
Book Lowest Logical Fare KPI vs N-1
Details
Quarterly/Monthly evolution
Non Compliant Travelers
Filter on Primary product code ="Air"
∑Air Net Tickets YTD N with LLA Acceptance = "Yes" / ∑ Air Net Tickets YTD N
vs ∑Air Net Tickets N-1 with LLA Acceptance = "Yes" / ∑ Air Net Tickets N-1
∑Air Net Tickets "Selection" with LLA Acceptance = "No"
Top 10 of ∑Air Net Tickets "Selection" with LLA Acceptance = "No" per traveler
∑ Lost Savings "Selection"
% of Spend= ∑ Lost Savings "Selection"/∑Air Net Tickets amount "Selection"
∑Air Net Tickets "Selection" with LLA Acceptance= "Yes" / ∑ Air Net Tickets "Selection" per period (quarter or month)
∑Air Net Tickets YTD N with LLA Acceptance = "No" sorted per traveler (descending)
Lowest logical fare means best financial option with same number of connections and flight schedule.
5
Trip Duration (based on number of air tickets booked)
Filter on Primary product code ="Air"
% of ∑Air Net Tickets "Selection" per "Days traveled" (excluding "Exchange refund code" = "Exchange" & "days travelled" = "Refund")
This metric has 2 dimensions: Month / Quarter
ADD OPTION TO FILTER ON RAIL IN THE FUTURE
6
Trip Purpose (based on number of air & rail tickets booked)
% of ∑Air Net Tickets "Selection" per "Trip Purpose Clean" (excluding "Exchange refund code" = "Exchange")
This metric has 2 dimensions: % or absolute value
ADD OPTION TO FILTER AIR OR RAIL IN THE FUTURE
7
Number of trip by air per traveler
Filter on Primary product code ="Air"
∑Air Net Tickets "Selection" per "Days traveled" sorted per traveler (descending)
Ability to filter on trip duration
8
Air Ticket above 5000 EUR
TBD