The Airline Impact dashboard, as illustrated in Figure 1, provides a comprehensive view of the cumulative impact on individual airlines. It consists of two waterfall charts and one table, each serving a distinct purpose.
Dashboard Description
The left waterfall chart showcases the top 20 records with the most significant annual revenue impact on individual airlines. Revenue increases are denoted by green bars, while revenue decreases are represented by red bars. These bars are sorted based on absolute change values.
On the right, the second waterfall chart breaks down the sources contributing to revenue changes, offering insights into the selection of the three filter controls at the top. These controls pertain to airline alliance (Alliance), airline group (AL_Group), and specific airlines (AL). In Figure 1, the Alliance control is set to OneWorld, which means the right waterfall chart displays various drivers influencing revenue changes within the Oneworld Alliance. These drivers are categorized as Local (contribution from local traffic), Connection (contribution from connecting traffic), and City Presence (contribution resulting from changes in alliance presence in key cities). As with the left chart, green bars indicate revenue increases, while red bars signify revenue decreases. The total revenue change is visually depicted as the Total bar.
Finally, the table at the bottom provides detailed information on traffic and revenue changes for the target month and the entire year. Values in the first three columns are displayed in blue, indicating that you can click on any of them to adjust the filter controls at the top. Clicking on an AL value will set all three controls (Alliance, AL_Group, and AL) to the corresponding values in the record. Clicking on an AL_Group value will update only the Alliance and AL_Group controls, and selecting an Alliance value will solely modify the Alliance control. It’s important to note that altering control values functions as a toggle. If the same value is already selected in a control, clicking on that value in the table will clear the previous selection. For instance, clicking on OneWorld in the Alliance column of the table will set the Alliance control to OneWorld. Clicking OneWorld again will remove this selection. However, choosing a different value from OneWorld will switch the Alliance control to the newly selected value.
Data Table Description
Table 1 below outlines the data table structure, with the data metrics aggregated by the combination of fields with a key icon (
).
| Field | Description |
| Alliance | Alliance name. “Non-Alliance” for the aggregation of all independent airlines. |
| AL_Group | Airline group, which is defined in the Group_Airline table. “~ ~” for the aggregation of all other airlines in the alliance. |
| AL | Airline IATA code. “~ ~” for the aggregation of all other airlines in the Alliance and AL_Group. |
| Pax_Change | Variation in passenger count between the ‘before’ case and the ‘after’ case during the target month |
| Revenue_Change | Change in revenue, measured in USD, from the ‘before’ case to the ‘after’ case within the target month |
| Rev_Chg_Local | Change in revenue from organic and codeshare non-stop services between the ‘before’ case and the ‘after’ case |
| Rev_Chg_Cnx | Change in revenue from one-stop and connecting services between the ‘before’ case and the ‘after’ case |
| Rev_Chg_City_Presence | Revenue change attributed to the variation in alliance city presence between the ‘before’ case and the ‘after’ case |
| Annual_Pax_Chg | Annualized variation in passenger count (equals to Pax_Change * 12) |
| Annual_Rev_Chg | Annualized revenue change (equals to Revenue_Change * 12) |
| Annual_Rev_Chg_Local | Annualized revenue change from non-stop services (equals to Rev_Chg_Local * 12) |
| Annual_Rev_Chg_Cnx | Annualized revenue change from one-stop and connecting services (equals to Rev_Chg_Cnx * 12) |
| Annual_Rev_Chg_City_Presence | Annualized revenue change attributed to the variation in alliance city presence (equals to Rev_Chg_City_Presence * 12) |