Project NGAP | AnalyticaAdvisory

AVIATION FORECASTS AND HISTORICAL

Regional Outlook - Comparison of Selected Years (Forecasted and Historical SUM's)

14-10-2018

Three responsive and dynamically related charts are included:

1.Top flight regions by selected years in terms of dynamic parameters

2. Share of all flight regions in a given year in terms of dynamic parameters

3. The distribution of a selected parameter for the selected regions by years (historical and forecasted values.

Parameters:

The views can be updated to show these parameters:

  • Total Pax

  • Total Seats

  • Total Flights

  • Total ASK

  • Total RPK

It is also possible to view and compare top 5/10/15/20 countries by selected years by using 'Top Ranking' parameter box.

Top Flight Regions by Selected Parameters - Comparison of Selected Years (Forecasted and Historical AVERAGE's)

14-10-2018

This dashboard is designed to reveal distribution of Average Load Factor, Average Seats, Average Pax, Average Flights, Average RPK, Average ASK,  Average Distance by flight regions (LTF) for the selected years.

By using dropdown boxes, located above the dashboard:

  • You can select multiple years, for comparison reason

  • You can select Top Rankings to view and compare top 5/10/15/20 countries by selected years by using 'Top Ranking' parameter box.

  • You can select one of these parameters (variables) to re-design all the views  accordingly:

    • ​Average Load Factor,

    • Average Seats,

    • Average Pax,

    • Average Flights,

    • Average RPK,

    • Average ASK, 

    • Average Distance

Three responsive and dynamically related charts are included:

1.Top flight regions by selected years in terms of average of selected dynamic parameters (variables)

2. Selecting a bar within the above chart, will trigger two tables which will reveal the distribution by regions for the selected year and the routes by country pairs in the actively selected region.

3. Selecting another region in the second table will re-filter the view in the third (routes) table

Flight Regions and Country Pairs for the Selected Year

14-10-2018

This dashboard depicts the forecasted or historical outlook for flight regions in terms of Total Pax, Total Seats, Total Flights, Total ASK, Total RPK for selected year.  It is also possible to query the country pairs within the flight region. You can select a year from the dropdown box located on the right hand side upper corner of the dashboard.

Four responsive and dynamically related charts are included:

1.Distribution of selected parameters by flight regions (LTF Regions) for a selected year.

2.Upon clicking and selecting a flight region:

  •  The summary box for the selected region and year including average values for Seats, Flights, Pax, RPK, ASK, Load Factor.

  • A multi-index table bar chart revealing the country pairs for the selected flight region and year.

  • Upon selecting a country pair, the distribution of historical and forecasted values among the years for the selected country pair.

Parameters:

The views can be updated to show these parameters:

  • Total Pax

  • Total Seats

  • Total Flights

  • Total ASK

  • Total RPK

Country Outlook

14-10-2018

This dashboard is built to make queries on the outgoing traffic of any selected country for the selected year. Using the country filter box located above the dashboard; it is possible to query any country in the forecast database.

 

It is also possible to make a selection of a year between 2000-2045 to view the historical or forecasted results. All the charts will be updated accordingly.

It is possible to make queries for 5 main parameter variables:

  • Total PAX

  • Total Flights

  • Total ASK

  • Total RPK

  • Total Seats

The dashboard consists of 4 interactive and responsive charts:

  1. Pie chart depicting the distribution of the selected parameter variable by flight regions for the selected country and year.

  2. Table view (right hand-side of the piechart) showing the tabular results same as the pie chart to provide easier understanding.

  3. On clicking the table or piechart, the line chart showing the distribution of the selected parameters (such as Total Pax) for the selected country-flight region through the years ( both historical and forecasted results). 

  4. Table view (tabular view) of destination countries from the selected origin country for the selected flight region and year.

Clicking on a flight region in the pie chart or relevant table will update the line chart and destination countries table.

Please reload

AIRCRAFT CATEGORIES - QUERY TOOLS

Traffic Diversification by Aircraft Categories - Cross Check File

14-10-2018

This file has been created so as to cross check the manipulations of the data and data management procedures.

There exists 6 tabs in the workbook:

  1. Number of Records: Showing the number of records for each year in the dataset. It also gives the distinct counts for departure countries, arrival countries and routes (country pairs)

  2. Route Descriptions: The calculated fields on the dataset's departure and arrival fields. Please see the caption for the calculations and queries.

  3. Parameters: The created breakdowns of the parameters (columns of the original dataset) which illustrates the number of routes (country pairs) for the selected year interval.

  4. Breakdown of the parameters: Another view as the 'Parameter' worksheet which gives filter options for: Parameter Type, Share or Total, Departure or Seat Kms.

  5. Sample Query (Shares): A sample query tool illustrating the percentage distributions by created parameters

  6. Sample Query (Totals): A sample query tool illustrating the value distributions by created parameters

Query by Departure, Arrival and Year

14-10-2018

This dashboard which consists of 4 main tables/charts illustrates the breakdown of departures and seat kms variables by air craft types at country pair and year level. 

Select a departure and arrival country pair and a year among 1995-2018 in order to query.  Clicking on the summary box which illustrates the total Departures and Seat Kms for the selected route/year will trigger additional explanatory tables, for Departures / Seat Kms accordingly.

There are 4 interactive and responsive charts in the dashboard. Clicking on Passenger, Freighter or Air Craft Types fields in the middle tables will update the following charts accordingly.

Global Totals Query by Years

14-10-2018

​The dashboard consists of 3 interactive and responsive charts. 

  • Line Chart: It shows the percentage diversification of the selected parameter (Departures or Seat Kms) through the years. Hovering the cursor over the line chart will trigger tooltip boxes with additional information.

  • Tree Chart: Clicking on a filed corresponding a year on the line chart will reveal the tree chart which shows the diversification of global traffic by air craft types for the relevant year.

  • Table: Clicking on an aircraft type box in the tree chart will reveal a table which shows the sorted list of country pair routes for the selected air craft type and selected year for the active parameter (departures / seat kms)

Please reload