Unlocking the Power of Airport Slot Data

How ACL are utilising Power BI to revolutionise slot data for our airport customers.

By Shahbaz Bhatti – Airport Slot Coordinator 

Data Analytics has come a long way over the last decade and the aviation industry has been quick to benefit from the wealth of information available. Whilst it is good to have access to huge sets of data, however, being able to uncover insights or visualise this to a non-technical audience is often more challenging.  To achieve this Airport Coordination Limited (ACL) have invested in Microsoft Power BI (PBI) to present our valuable data. PBI is a Microsoft business intelligence tool which allows users to connect multiple sources of data into powerful and interactive visuals that can be shared and collaborated on to inform important decision making.

Uses in the Aviation Industry

PBI is widely used within the aviation industry. Some of our biggest customers, including Heathrow Airport Ltd and Manchester Airport Group, have heavily invested in PBI to provide them ‘on the go’ data to drive their business needs. Click here to view an article and video where the CIO of Heathrow Airport Ltd describes how PBI has helped their day-to-day operations. Over the last two years, more of our airport and airline customers have started to invest in PBI; allowing us to collaborate better, provide more insightful analytics and enhance our service by providing reports in ways never seen before.

How ACL Utilise PBI:

ACL’s database is a comprehensive portfolio of airport slots. This asset is the fundamental driver of databases, operations, and resources for all our airport customers. As well as populating Flight Information Display Systems (FIDs), the raw data can be analysed and manipulated in ways to provide useful insights for various themes. ACL has used this data to create reports related to coordination activities, growth forecasts and slot usage investigations and monitoring.

 

Figure 1 – Dashboard showing Seats and ATM’s comparison at different points of the coordination cycle.

 

PBI has been an essential tool during the recent pandemic. To preserve their business, one of our biggest customers faced the decision to close more than 60% of their infrastructure. ACL adapted to the new environment and provided quick, precise and simple demand forecast histograms, to assist decision making on falling demand. The interactive visuals allowed users to filter different operators and terminals to understand and predict the result of various scenarios. At a time where our customers required immediate assistance, PBI has delivered on efficiency.

 

Figure 2 – Terminal Demand Histograms comparing current and projected passenger movements given Covid-19 assumptions.

 

This has been equally helpful in forecasting uplifts in demand. ACL worked with the same customer to produce histograms providing scenarios for when demand returns and the impact of social distancing measures. These insights allow airport customers to make informed decisions for re-opening in the most economical way.

“ACL produced a very useful power BI report to help us better understand and analyse our flight schedules. The ability to filter by different elements of our schedule – such as terminal, airline, date, arrival or departure – gave us access to the next level of detail beyond a standard coordination report and help understand what was behind our demand. This saved lots of discussion … and made much better use of everyone’s time!  It’s a tool we’d find very useful going forward.” – ACL Airport Customer

Reporting can be utilised across the aviation community for groups such as the Industry Resilience Group (IRG) and NATS. The IRG is a collaboration of leading aviation bodies looking at enhancing day to day operating resilience, reducing delays and costs. PBI is effective for them as it allows us to store, visualise and refresh data ahead of the summer season and over several iterations. By building a PBI dashboard we can enhance the raw schedule data. This provides NATS with insights into the levels of congestion and where these are likely to take place. The daily updates we provide to NATS mean they can make reliable decisions on staffing, coinciding with the fall of traffic volumes and, more recently, with the signs of ramp-up in flights. This allows them to anticipate increases in traffic and the effect this has on their own resource planning.

 

Figure 3 – Example Page from IRG Dashboard showing the decline in ATM’s as a result of the Covid-19 pandemic.

 

ACL also utilise PBI internally to improve our own KPI performance and help us reach our customer service goals. Combined data from our SQL and Excel databases are dynamically fed to our centralised intranet page, providing colleagues with accurate, up-to-date data which can be used to assess our own performance objectives and source solutions to benefit our customers.

 

Figure 4 – ACL’s Internal KPI Dashboard showing Waitlist Management target and position.

 

Figure 5 -ACL’s Internal KPI Dashboard displaying Message Handling statistics.

 

Next Steps:

ACL are committed to our values and to ‘Striving for Better’. We endeavour to explore and endorse new and innovative avenues, stay up to date with industry norms and enhance our services. PBI has allowed us to expand our data analytics knowledge which will only increase through further use and collaboration, allowing us to better support our customers and the aviation industry.

If you would like to explore how PBI and ACL analytics can support your airport please email us at pbihelp@acl-uk.org.

 

Understanding Airport Slot Cancellations in a Global Pandemic – What the Numbers Say

As reports of decreasing flights become more and more familiar, ACL’s Data Analyst, Chris Butler, looks at how cancellation activity can help us understand how allocated slots have declined, as well as what to expect as the summer season progresses.

Following the granting of widespread alleviation from the use-it-or-lose-it rule for Summer 2020 there have been extensive cancellations of airport slots as a result of widespread travel restrictions, meaning that slot volumes have been substantially reduced. Airport Coordination Limited (ACL) has seen weekly slot volumes fall as low as 9% of the volume seen last summer, with weekly allocated seats falling further to less than 4% of last year’s volume in April.

Significant reduction in slot volume was first seen at the end of Winter 2019, where total allocated slots declined by 5.2% from the beginning of March to the end of the winter season, a fall of over 70,000 slots. Slot decline accelerated through March, with weekly volumes falling to just 60% of the volume seen in the previous winter season.

This decline only worsened as the Summer 2020 season began. At the beginning of June, total allocated summer season slots at UK airports were 48% lower than at the same point last year. This represents a sharp decline, with a deficit of over 730,000 slots year on year.

To date, decline in slot volume has substantially affected the early months of the Summer season, as airlines focus on their schedules held at the beginning of the season. By observing the total slot volume at monthly snapshots we can see how slot decline at the beginning of April was focussed on the first month of the season, with decline further into the summer months emerging at subsequent monthly snapshots.

Slots scheduled in June fell by 73% from the beginning of May to the beginning of June (a decline of over 185,000 slots), indicating the rate at which slots are being cancelled. These monthly snapshots show significant slot decline continuing as the season progresses, resulting from airlines cancelling slots on a piecewise basis due to resource restrictions and continued uncertainty regarding the possibility of increased flying.

As of 1 June, using S19 weekly slot volumes as a comparison, substantial decline is seen as far as the end of June (W13), where allocated slots are currently around 30% of the volume seen last year with some airlines yet to cancel slots held in July.

This currently represents a slight increase versus May, where slot volume was around 10% of last year’s volume. Caution should be taken however when looking further into the season (where slot volumes remain as high as 95%) as analysis of cancellation patterns indicates that slot decline is expected to roll into the coming months, as airlines amend their schedules further into the summer.

This chart breaks down the total cancelled slots by the month that those cancellations were made. The data indicates the pattern seen in cancellation activity, suggesting that the remaining summer volume will also reduce as cancellations reach further into the summer months. The scale of this reduction, however, is difficult to predict whilst the ongoing challenges posed by travel restrictions and quarantine periods remain unclear.

Whilst positivity is emerging from airlines regarding the re-introduction of air travel this summer, any uplift in flying will be difficult to forecast due to the rolling nature of cancellation activity. Despite this, ACL’s industry relations and the analysis of our schedule data will allow us to identify the early indications of any increases in flying, which may enable other members of the aviation industry to prepare for the challenges that an uplift in flying will bring.

By Chris Butler- Airport Capacity Analyst

W20 SALs for ACL airports

All W20 SALs for ACL airports have now been distributed. Please contact the coordinator if you have not received the message for a particular airport.

How to coordinate an airport from your daughter’s bedroom

Our experienced coordination manager, Pete Robinson, recalls his working from home journey and how he has coordinated some of the worlds busiest airports from his daughters bedroom.

Shortly before the UK went into official lockdown, I spent a day in mid-March touring London’s airports. Aviation was just beginning to slow down, and I was conscious of the noticeable reduction in movements and the presence of stationary aircraft at Stansted, Luton, Heathrow and Gatwick.

On the second day of the lockdown I celebrated 15 years at Airport Coordination Limited (ACL). During those years I have experienced closures and disruption of all kinds from severe weather, natural disasters, terrorism, conflicts and the grounding of aircraft fleets. Even the week-long closure of European airspace due to an Icelandic volcano in 2010 pales into insignificance next to the impact of Covid-19 on the worldwide aviation industry.

The first week of working from home was strange. I usually spend two and a half hours a day on my M25 commute and contrary to most, I was strangely experiencing withdrawal symptoms. I had to accept, with the schools closed, and my partner also working from home, finding a quiet place to work was going to be difficult. Luckily, only a few months earlier, we had bought each of our girls’ desks for their bedrooms and so, kicking my 5-year-old out, I began coordinating slots from my daughter’s bedroom, with her surrounding toys for company.

Some of the “winged” toys keeping me company in lieu of real aircraft!

So how do you coordinate some of the worlds most complex airports when your whole team is working from home? Less than 12 months earlier, ACL had invested in Microsoft Teams and trained all our staff in its use. Whilst its need had been limited before, this investment truly paid off. Video calls, screen and document sharing are the new norm across ACL. Guests from outside our organisation can easily join video calls and it has allowed us to provide the same level of communication with our customers in other remote locations. Each week ACL’s CEO, Edmond Rose, hosts a Q&A session and updates us on company affairs, and colleagues take it in turns to host regular afterwork quizzes, helping to maintain social contact with the wider ACL team.

During lockdown, I begin each morning running reports for the four international airports I manage. This helps me understand the schedule movements from the last 24 hours. I monitor travel restrictions, UK Foreign and Commonwealth travel advice and the international press for any significant developments. I then correlate these against the schedule changes we have received from airlines. This information is then fed to the rest of my team via my daily Teams update. Communication with colleagues has certainly changed, but video calls have allowed us to continue enjoying face-to-face interaction. I have a daily call with my Head of Coordination and then a further call between myself and my own team. These calls are crucial for relaying updates and activity across ACL and are an opportunity to agree any actions for the coming days.

My usual morning tea break with colleagues has now been replaced with a short stroll around my garden and tending to my plants. Some great weather and the additional time at home has left my garden looking in fine shape. What started as a home-schooling project, growing some vegetable seeds with my daughters, has developed into a gardening obsession, and I have proudly been sharing updates with my colleagues on my horticulture successes.

The evolution of my horticultural obsession. 

A further highlight has been the successful roll-out of virtual coordinator training. My initial nerves over conducting training online have not been met and Teams has allowed me to share my screen with multiple users demonstrating tasks, encouraging discussions, and continuing the high level of training we provide to our coordinators.

After two months of daily cancellation activity across ACL’s airport portfolio, we are beginning to see signs of easing across Europe and there are indications that planes may return to the skies. One thing is for sure, the Summer 20 season will look very different from how it was first coordinated. The industry continues to consider how social distancing can be enacted and without concreate plans or guidance, it remains difficult to predict how demand and capacity will look in the coming twelve months.

So, as many of us adapt to the new normal, I have found myself a more suitable home and am coordinating from our spare bedroom, which I have temporarily converted to a home office. Working from home is staying a little while longer, but ACL will continue to provide our expert coordination services from whatever locations our staff find themselves, and we will continue to be both proactive and reactive to the challenges ahead.

Coordinating slots from my new temporary home office

 

By Pete Robinson

Starting at ACL during Covid-19

ACL’s newest recruit, Wade Chan, discusses what it’s like starting a new job during a nation-wide lock-down.

Wade performing coordination from the comfort of her living room

 

On March 18th I received joining instructions from Marion, reconfirming my new role as a Coordinator at Airport Coordination Limited (ACL). To the amusement of my then colleagues, my start date was April 1st, April Fool’s Day; making them joke I had accepted a prank job. Whilst, I knew this was not true, with COVID-19 beginning to impact many jobs in aviation, I did start to worry.

The UK went into lockdown the following week and I began to consider if a new job was a wise decision. A few days later an email from ACL pinged on my phone ‘Change of joining Instructions’: my heart sunk. Expecting the job to be put on hold, I was relieved to read that my arrival time had merely been adjusted to a new time.

By the time I received my next email a week later my heart was pounding, and I delayed opening it for several hours. Again, my fears were misplaced, and it was simply another information update. I began to feel more confident. ACL were an organised company and I was looking forward to a new start in a new job.

April 1st came and mercifully it was not an April Fool’s joke! With great excitement, I entered ACL’s office and was immediately struck by its emptiness. A man quickly appeared with a welcoming smile and introduced himself as Richard Cann, Head of Coordination. Richard gave me a quick run down of the company, his job role, the plan for my induction and how I would immediately be working from home. Communication between the company was taking place across Microsoft Teams. Richard bought up the programme and demonstrated a call to Ingrid Hainy, my new line manager. Soon after I was given a work laptop and shown how I could access our system remotely. Within an hour I was back home; I had met only one colleague and was continuing my first day from my living room.

I successfully managed to log into the company VPN and made my first Teams call to my new manager. It was strange communicating in this method. Ingrid was extremely organised, welcoming and had crafted a whole training schedule via Teams. I met my first teammate online, Kavi Ghanasegaram, a coordinator like me. I would be shadowing Kavi to get an idea of what coordination involves. It was interesting to see how the slot system worked. Ingrid then began teaching me SSIM training and on my third day a meeting was arranged for me to meet ACL’s CEO, Edmond. Throughout my working life, I have never met the CEO of a company I worked for. To meet a CEO, almost in person, was another first for me; Edmond was very friendly and supportive.

My next week could be summarised as meetings galore! I met various members of ACL’s management and learnt about their roles. My first team meeting felt strange and I had little clue what was being discussed but working alongside Kavi made understanding and learning easier. Any issues were just a Teams call away; this made settling in easy despite being at home. Shahbaz Bhatti, another coordinator, was to be my daily trainer and mentor. Training sessions with him are very precise and detailed. Distance training feels odd initially but is easily adaptable.

A month on in my coordination role at ACL I feel comfortable handling messages. I was even entrusted with the responsibility of running Heathrow’s operation for a day! Though nervous initially, it allowed me to handle tasks myself and I gained direct expose to dynamic operational changes. I was grateful to Ingrid for giving me both the opportunity and for a chance to grow my confidence, something which is increasing day by day. Working from home is a unique experience. Everyone I have met at ACL (virtually) has been very friendly, helpful, and supportive. I look forward to meeting them all in person once lockdown ends.

 

By Wade Chan

What does coordination activity look like after widespread alleviation?

As our industry navigates one of the biggest challenges to aviation, we look at the more localised impact of Covid-19 and how Airport Coordination Limited (ACL)’s coordinator’s workloads have changed in the weeks following widespread alleviation.

by Chris Butler- Airport Capacity Analyst

The upheaval caused by Covid-19 and the associated granting of alleviation from the need to use slots to maintain historic rights in the summer season has resulted in mass flight cancellations, airport closures and other disruptions. This has meant that the usual volume of coordination messages received has varied significantly from what ACL would expect at the beginning of a ‘normal’ summer season and as such resulted in a significant increase in activity required by the coordinator community.

Towards the end of the Winter coordination season the volume of messages per week closely followed the levels seen in 2019. Following the increased impact of the outbreak of coronavirus however, the volume of messages received by ACL steadily increased. With alleviation of slots for the summer season granted, this culminated in an unprecedented peak in messages received, as the airlines responded by cutting back their schedules. At this peak, ACL managed over 13,500 individual messages in one week at over 40 different airports, from hundreds of different airlines.

This peak in coordination messages represented a 300% increase versus the same week in 2019, with substantial increases seen in the weeks leading up to the peak.

In addition to an increase in the volume of messages received during the peak period, the complexity of coordination also increased. This is due to unusual circumstances such as partial and full airport closures, as well as cancellation messages from airlines covering long periods of the season.

The result of this is a decrease in automation, meaning coordinators have a higher volume of messages that must be handled manually. The proportion of messages needing to be handled manually has nearly doubled.

Utilising our experience as the world’s oldest independent slot coordinator and from our frequent experience managing peak demand at airports during special or sudden events, ACL has responded to these challenges by providing flexible and efficient coordination in an extremely difficult time for the whole aviation industry.

Whilst it is likely that we have seen the initial peak of message volumes for the season, these challenges will continue. It is likely that we will see further cancellation activity in the weeks ahead as airlines adjust to changing circumstances throughout the summer season. ACL will continue to react to these challenges, benefitting from our experience and unique industry relationships, aiming to continue to provide coordination excellence in these difficult circumstances.

ACL TO GRANT ALLEVIATION FROM USE-IT-OR-LOSE-IT RULE, SUMMER 2020

ACL acknowledges that the European institutions have decided to extend the temporary waiver from non-use of slots proposed by the European Commission so that it covers the full Summer 2020 season.

ACL will grant alleviation from non-use of slots to airlines at the 11 airports it coordinates across the European Union and the United Kingdom from 1 March 2020 to 24 October 2020; and alleviation from non-use of slots for flights to and from mainland China and Hong Kong for the period from 23 January 2020 to 29 February 2020.

Airlines are required to hand back slots that they seek to claim alleviation for at the earliest opportunity. Slots that are held and are not subsequently operated will not be granted alleviation as other carriers will have been denied the opportunity to use the available capacity.

27 March 2020

London City announces temporary suspension of flights.

London City Airport temporarily suspends commercial and private flights . London City Airport have provided ACL with the following statement;

Following the Government’s latest instructions in response to the Coronavirus outbreak, we have made the decision to temporarily suspend all commercial and private flights from the airport.

This will begin in the evening on Wednesday 25 March and is expected to last until the end of April. We will keep this under review.

At this point in this fast-moving and unprecedented situation, we think this is the responsible thing to do for the safety and wellbeing of our staff, passengers and everyone associated with the airport.

During this period, we will continue to follow official guidance and work with the authorities to understand the situation and how best to respond.

We will keep you up to date with relevant information and news, as and when we have it.

The full London City Airport statement can be found here

Important Coronavirus update- ACL’s full service continues

During the current Covid-19 outbreak, ACL is pleased to maintain its full service to customers, continuing to support the aviation industry through the current crisis. In March, we’ve handled more than double the usual number of schedule messages, as well as providing many bespoke reports for airports, support for airport planning and extra reports for data customers.

ACL’s staff will continue to be available during normal working hours for all our offices, whether in New Zealand, the UAE or the UK. We continue to follow official government advice in each country we operate by limiting contact and working from home.

 

 

ACL, NATS and the IRG: Preparing for a challenging summer

As UK and European Airspace become more congested and airports look to squeeze maximum opportunity from their runway, we look at how NATS and ACL are working together through the Industry Resilience Group to better plan for the summer.

Aircraft cannot simply fly in straight lines between two points. The skies above our heads are made up of a mix of controlled, uncontrolled and military airspace. Almost all commercial airliners fly through controlled airspace where Air Traffic Control monitor and control which direction, how fast and at what altitude each flight can fly to keep passengers safe.

The controlled airspace above the United Kingdom is a set of pre-designated corridors that aircraft must follow. It was originally designed in the 1960s and in the main has remain unchanged for 50 years. As the demand for air travel has drastically increased since the 1960s, certain parts of the airspace network above the UK have come under significant pressure and it is at these airspace “hotspots” that the flow of air traffic may have to be regulated by Air Traffic Control leading to delays in flights planning to fly through regulated sectors.

For the Summer 2018 season the Voluntary Industry Resilience Group (VIRG) embarked upon trying to understand from ACL how the Coordination cycle works and if any useful information could be extracted from ACL’s schedules to highlight potential air traffic hotspots in advance. ACL and NATS worked together to create some basic high-level illustrations to show the changes in demand for the main directional flows in and out of the UK airspace versus the previous Summer.

Planning for Summer 2019

ACL’s role in the Summer 2019 process was far more involved, providing detailed schedule data for 26 UK & Republic of Ireland (ROI) airports to be combined with NATS capability at key points in the run up to the start of the season. ACL’s experience provided industry context and understanding to the data, a result of their unique proposition and close relationships with airlines and airports.

Each ACL review was made up of thousands of data entries providing information on the number of flights operating between airports. This, in combination with NATS’ own data allows airspace ‘hot spots’ to be identified ahead of time. Further analysis by week, weekday and time provide extended dimensions to the analysis, allowing NATS and the industry to understand the impact of the new schedule for the upcoming season and plan for expected congestion.

Delivering meaningful output for the industry

The outputs provided for Summer 2019 were significant in allowing the industry to better prepare for a busy summer season. The data showed a 0.4% growth against the previous summer, amounting to an increase of over 6,000 movements. Growth was strongest in the Republic of Ireland (+3.6%), with movements at London airports also higher than the previous summer (+0.5%).

Significantly for NATS, there was strong South-East axis growth (+5.7%) which indicated further congestion expected in an already busy airspace. There was however a decline in traffic on the East axis; knowledge of these trends allowed NATS and the industry to prepare for the specific airspace challenges ahead.

ATC Routing traffic forecast for Summer 2019 as of February 20, 2019.

For Summer 2020, ACL developed its contribution further, providing additional analysis alongside the data and utilising Power BI to make process more efficient, easily understood and dynamic.

Initial Summer 2020 analysis taken at the end of November showed movement growth of 0.7%. Expected growth for 2020 was driven primarily by the rise in scheduled flights with a South-East routing which increased by over 23,000 movements. Growth on the South-East axis has been a historic issue, and so advance warning for the upcoming summer allows the industry to react to the demand.

The picture has changed significantly at the second data iteration. Data updates now show a movement decline of -1.1% against the previous summer, demonstrating how regular provision of schedule data is essential due to the volatility of schedule changes that can occur.

ATC Routing traffic forecast for Summer 2020 as of February 3, 2020.

Growth on the South-East axis has now decreased to only +2.5%, with more significant growth on the NE axis (+4.2%). In addition to observing overall movements and axis growth, ACL provide information at a regional and airport level. This analysis shows decline in movements in all major UK and Ireland regions, except for growth in Scotland (3.9%). An area of specific airspace interest is London airports, which currently show an overall decline in movements of -0.2% versus last summer.

Changes between data updates underline the significance of schedule movements between initial allocation and the start of the season. As such, the ability to provide iterative updates using dynamic Power BI reporting allows NATS to have better visibility of schedule changes and to observe how trends are developing ahead of the start of the season.

A developing collaboration

Analysis of forecasting accuracy for Summer 2019 indicated that the quality of predictions improved as ACL provided later data iterations, showing the importance of the continued information provided up to the start of the season.

NATS were able to utilise a far more accurate data picture as a result of the final data iteration. Looking forward to Summer 2020, it was agreed that due to the increasing accuracy of later iterations, NATS and ACL would focus on high-level trends at the first iteration, building into a more detailed picture following slot return deadlines prior to the season starting.

Several further data iterations and trend updates will be provided to NATS and the IRG up to and including the start of the summer season, with the intention of allowing the industry to continue to improve its resilience against schedule changes and airspace congestion by utilising ACL’s unique resources.

Looking ahead

As ACL and NATS continue to collaborate through the sponsorship of the IRG the level of detail and insight is increasing with each iteration. The ultimate aim is to have a level of dynamic updates which will give the industry time to plan ahead to minimise the impact of congestion, leading to better operational performance and an improved customer experience for all those using the airspace.

Click here to download a longer article of our findings