CSE498, Collaborative Design, Spring 2022
Computer Science and Engineering
Michigan State University

United Airlines is a leading American airline headquartered in Chicago, Illinois. United Airlines connects people and unites the world with over 330 destinations served and over 3,000 departures daily in 2021 across its comprehensive network. With a workforce of over 70,000 employees throughout the world, United Airlines is positioned strongly to provide outstanding service to its customers.

To uphold its rigorous standards for safety and reliability, United Airlines requires routine inspection and maintenance for the hundreds of aircrafts in its fleet, which in turn requires properly trained technicians stationed in the right places at the right times across all of the airports it serves. Training resources must be allocated carefully to keep the skills of technicians in line with the demands of evolving flight schedules and fleet composition.

However, determining what training must be provided to keep United Airlines’ network operating smoothly is a complex task due to the large numbers of flights and airports involved.

Our Training Forecast Model predicts when and where unmet needs for technicians arise and guides decisionmakers toward where to provide additional training to bridge those gaps.

When United Airlines training staff opens our dashboard, displayed is an overview of understaffing risks at various airports, relaying key insights to staff. They are provided the ability to dig deeper into flight schedules and training data to analyze the most pressing needs on a finer scale. Predictive forecasting is included as well, to help determine what future risks may appear.

The information from our Training Forecast Model application enables United Airlines to reliably catch training risks in advance, reducing threats due to shortages of trained staff.

Our front-end interface is written as an SPA in TypeScript using the React framework. Back-end APIs written in Python are deployed on Azure Functions, backed by an Azure SQL database.