The Alliance Impact dashboard, depicted in Figure 1, provides a summary of the impact for each alliance, detailing factors of local traffic, connectivity, and alliance city presence. It consists three waterfall charts and one table, each serving a distinct purpose.
Dashboard Description
The first two waterfall charts on the left showcase the annual passenger traffic impact and revenue impact on each airline alliance. Traffic or revenue increases are denoted by green bars, while decreases are represented by red bars. These bars are sorted based on absolute change values.
On the right, the third waterfall chart breaks down the sources contributing to revenue changes, offering insights into the selection of the Alliance filter control at the top. 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 charts, 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.
Data Table Description
Table 1 below outlines the data table structure, with the data metrics aggregated by the field with a key icon (
).
| Field | Description |
| Alliance | Alliance name. “Non-Alliance” for the aggregation of all independent airlines. |
| 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) |