Moving Beyond Excel: London Heathrow's Need for Business Intelligence

Business Case: London Heathrow Airport Launches BI and Machine Learning to Improve Airfield Management, Predict Passenger Flow, and Transform Airport Security
Heathrow airport in London is the second busiest international airport in the world, second only to Dubai international airport in number of airplanes landing and taking off each day and the seventh largest in terms of total passenger traffic. Managing over 215,000 passengers every day is a challenging task and requires a high degree of coordination to manage passenger traffic and give passengers a smooth airport experience. Any unexpected disruptions in the smooth workflow in operations at Heathrow such as damaged runways, storms, delayed or canceled flights, shifts in jet streams, etc. would disturb the entire functioning of the airport, passengers and airport employees.

Data analysts at London Heathrow were using Excel spreadsheets to analyze its airfield, passenger and flight data and sorely needed a centralized management system that would extract large volumes of data produced by airport operations and transform them into useful visual insights. Stuart Birrell, CIO at Heathrow was concerned that “We have tens of thousands of people who work around the airfield. Safety is critical. Adopting tools like Power BI makes life easier. It is the simple things. There is GPS in the airfield vehicles. If a driver finds a problem with the concrete, this can be recorded accurately.” Heathrow chose Microsoft Power BI as their BI solution. The reporting produced by its BI tool ensured airfield safety, allowed airport staff to function better and improved passenger management.

The key was moving from a paper-based, reactive operations model to a more predictive, proactive planning model in which staff were dealt fewer surprises on a day-to-day basis that enabled them to change their plans on-the-fly. The answer was BI reports and dashboards that were made available to airfield managers, security officers, transfers and customer service staff and a machine learning model that accurately predicts passenger flow in 15-minute increments into each terminal. Birrell says it's possible to mash up historical scheduling data and a feedback loop to provide more accurate forecasts. With insights from these data analytics tools managers could plan staff breaks, open and close security lanes as needed and schedule staff shifts to balance passenger flow across the airport in peak times. As Birrell said, “For passengers, it is all about getting them to aircraft on time.” The new system also helps manage arrivals. Under the old model, if several flights came into the airport an hour early because of tailwinds immigration and baggage staff would have to scramble to react to the sudden spike of arriving passengers. After the predictive model was deployed, the airport manager could share the insights with air traffic control and security staff to better schedule immigration and security lanes and teams by knowing where passengers are arriving, how many of them are arriving and at what terminal to ensure the right number of immigration/security lanes are open and reduce time and stress for both passengers and airport staff.

For Birrell, the biggest challenges were not technology-related but were about a culture and mindset shift to get people onboard. “It's easy to do a bit of data analysis with one or two experts. It's more about how you deploy this around your organization; how do you get that security team of 4,000 to start using that data and change the way they're working,” says Birrell. Now London Heathrow has people with its operations team who are deploying and building their own apps including one security officer who learned to build apps on his own with a little help from the IT department. So far, he has developed 12 apps to support his colleagues in security.

Questions:

Why did London Heathrow need to move up from Excel to a business intelligence platform?
What are the benefits that London Heathrow passengers experienced as a result of the new approach to data analytics?
Describe one specific way in which machine learning improved London Heathrow operations.
What was the biggest challenge that CIO Birrell faced in deploying BI and machine learning at London Heathrow?

Moving Beyond Excel: London Heathrow's Need for Business Intelligence London Heathrow, one of the world's busiest airports, faced various challenges that necessitated a transition from Excel spreadsheets to a business intelligence (BI) platform. Excel, while useful for basic data analysis, proved insufficient for managing the complex operations and vast amounts of data generated by the airport. The following reasons highlight the need for a more robust BI solution: Centralized Data Management: Excel spreadsheets lack the capability to handle large volumes of data effectively. With over 215,000 passengers daily, Heathrow needed a centralized system to extract, analyze, and transform data from various sources, such as airfield operations, passenger flow, and flight data. A BI platform provides a more efficient and streamlined approach to data management. Real-time Insights: Heathrow required timely and accurate insights to manage its operations effectively. Excel's static nature limited the ability to provide real-time updates and visualizations. By adopting a BI solution like Microsoft Power BI, Heathrow gained access to dynamic reports and dashboards that enhanced decision-making processes for airfield managers, security officers, transfers, and customer service staff. Proactive Planning: The transition from a reactive to a proactive planning model was crucial for Heathrow. BI reports and dashboards facilitated the shift by providing predictive analytics capabilities. By leveraging machine learning algorithms, the airport could accurately forecast passenger flow in 15-minute intervals, enabling staff to adapt plans on-the-fly and minimize surprises. Proactive planning allowed for better resource allocation, improved staff breaks, optimized security lanes, and reduced passenger stress. Benefits Experienced by London Heathrow Passengers: Improved Airport Experience: The adoption of a BI platform positively impacted passengers' experience at London Heathrow. With access to real-time data insights, airport staff could better manage passenger flow, ensuring smoother transitions between terminals. By balancing staff shifts and opening/closing security lanes as needed, the airport minimized wait times and reduced stress for passengers during peak periods. Timely Departures: The primary goal for passengers is to reach their aircraft on time. With the aid of BI tools, London Heathrow could optimize operations to facilitate timely departures. By using historical scheduling data and feedback loops, managers could make more accurate forecasts and adjust staff schedules accordingly. This resulted in efficient handling of passenger flows and reduced delays. Machine Learning's Impact on London Heathrow Operations: Machine learning played a crucial role in improving operations at London Heathrow. One specific way in which it made a significant difference was by enhancing the management of arrivals. Prior to implementing the predictive model, unexpected early arrivals caused challenges for immigration and baggage staff who had to react quickly to handle the sudden influx of passengers. With machine learning predictions, airport managers could share insights with air traffic control and security staff in order to schedule immigration and security lanes accordingly. This allowed for a smoother process, reducing congestion and ensuring an optimal number of lanes were open to handle arriving passengers efficiently. Challenges Faced by CIO Birrell: The biggest challenge CIO Stuart Birrell faced in deploying BI and machine learning at London Heathrow was not technology-related but centered around culture and mindset shifts within the organization. It involved getting people across various departments to embrace the use of data and change their work processes accordingly. Deploying such technologies required organizational-wide adoption and utilization. Birrell recognized that it wasn't just about data analysis expertise but about empowering teams and individuals to leverage data effectively. Overcoming resistance to change and fostering a culture of data-driven decision-making proved to be a significant obstacle in the successful implementation of BI and machine learning at London Heathrow.      

Sample Answer