Versions Compared

Old Version 3

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.



Nb

NameSourceCalculationComments
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
Image Added
Air Overview
  • Total Spend
  • Number of O&D
  • Average O&D cost
AmexGBT- O&D
Filter
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)
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
Volume per airlines alliances
AmexGBT- Spend Analysis
Filter
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
Compliance evolution over time based on selection Month/Year
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)

∑Air Net Ticket Count in % of airline alliances (or number of tickets per airline alliances)
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 Filter on
% or number of tickets
Image Added
Air tickets volumes : Domestic/Regional vs Intercontinental
AmexGBT- Spend Analysis
Filter on Primary product code ="Air"
&
∑Air Net Tickets in % of "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)

Image Added
Air Tickets volume per booking class
AmexGBT- 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)

Image Added

Air ticket details amount above X EURAmexGBT- Spend Analysis

Filter on Primary product code ="Air"

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
AmexGBT- O&D
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"
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
Image Added
Hotel Overview*
  • Booked amount
  • Number of nights
  • Average daily rate
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

Image Added
Car Overview*
  • Booked Amount
  • Number of days
  • Average daily rate
AmexGBT - Car rental by city
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
∑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