Challenge
Evaluating schedules across multiple resource areas to understand demand versus capacity at global hubs is a core focus for the analysis team. However, the sheer number of outstations, combined with tight planning timelines, has constrained the depth and speed of analysis.
As a result, schedules have often been reviewed separately for each operational company within the Group before being consolidated, limiting the ability to quickly identify efficiencies across different facilities within the airports.
- Significant time spent manually compiling and formatting data from multiple external sources within Power BI
- Limited ability to overlay schedules dynamically, restricting visibility of resource constraints across key operational areas
- Challenges in developing a consolidated, network-wide view of airport resource requirements
- Reduced visibility of potential operational risks and cost-saving opportunities without a fully integrated, strategic perspective