Messina Group
86 Case Studies
A Messina Group Case Study
The client, a $1B domestic regional airline partner for major carriers, faced a challenge with its pilot Trip Trade policy. Management was concerned that a contractual loophole was being exploited, leading to inefficient schedules and a potential net loss of pilot flight hours, but they lacked the data to analyze the issue. The Messina Group was engaged to provide its Analytics service to address this problem.
Messina Group integrated three disparate data sources and built models and visualizations using Microsoft SQL Server and Power BI. This data-driven solution enabled the airline to identify the net loss of scheduled hours and become more judicious in approving trades. The project identified a potential $3M in pilot capacity savings by exposing misuse and uninformed approvals, creating major operational efficiencies.
$1B domestic regional airline partner for United, AA, and Delta