Presentation
Perform a Pareto Analysis on any of your Business Travel (Air) KPIs.
The Pareto Principle (also known as the 80/20 rule) the idea that by doing 20% of the work you can generate 80% of the benefit of doing the entire job.
You can dynamically select the KPI and the Dimension for your Pareto Analysis (see "Select KPI" and "Select Dimension" sections).
Select KPI
'Select KPI' selector allows you to easily switch from one KPI to another, so you can analyze your data from any point of view.
The list of available KPIs is defined during the configuration of your dashboard in LinPack.
In your Business Travel (Air) dashboard, you will be able to select the following KPIs:
- Total Air Spend Total tickets amount
- Nb of Tickets Total number of tickets
- Avg Ticket Price Average ticket amount
- ABW - Advance Booking Window Days between booking date and travel start date
- OAR - Online Adoption Rate Share of online bookings
- Lowest Fare Accepted Rate Share of bookings where the lowestfare was accepted
- Nb of Travelers Total number of distinct travelers
- Air Spend per Traveler Average air spend per traveler
- Total △ Ticket vs Lowest Fare Total difference between Ticket vs Lowest Fare
- Avg △ Ticket vs Lowest Fare Average difference between Ticket vs Lowest Fare
- Total Lowest Fare Total Lowest Fare
- Ticket vs Lowest Fare % Over price vs Lowest fare in %
- Tickets per Traveler Average number of tickets per Traveler
- Destination Cities Total number of distinct destination cities
- Destination Countries Total number of distinct destination countries
- (+ any KPI you want to add to your Business Travel (Air) dashboard)
Select Dimension
'Select Dimension' selector allows you to easily switch from one dimension (analytical axis) to another, so you can analyze your data from any point of view.
The list of available dimensions is defined during the configuration of your dashboard in LinPack.
In your Business Travel (Air) dashboard, you will be able to select the following dimensions:
- Invoice DateInvoice Date
- Booking DateBooking Date
- AirlinesName of the airlines
- Booking ClassBusiness, Economy, First...
- Online Booking Flag"Y" is online booking
- Origin CityOrigin City
- Origin CountryOrigin Country
- Destination CityDestination City
- Destination CountryDestination Country
- Reason TravelConference, Training, Relocation...
- Travel Start DateTravel Start Date
- TravelerTraveler Name, Number, Identifier...
Filter on Date
This data visualization comes with a filter on the Date value. This feature enables you to focus on the period you are interested in.
You can filter dates at multiple levels: Day, Week, Month, Quarter or Year.
Filter your data
This data visualization comes with four top filters:
In your Business Travel (Air) dashboard, you will be able to filter on:
- Booking ClassBusiness, Economy, First...
- Origin CountryOrigin Country
- Destination CityDestination City
- Destination CountryDestination Country