Optimizing Airlines with Insights Analytical Tool
Industry
Technologies
Country
Client Overview
Insights is a web tool designed to simplify and speed up research and analysis within an airline, handling the complex data that is constantly updated every second. It enables users to search and navigate data without writing SQL queries, making it accessible to all staff. Its risk-tracking features streamline risk management, auditing and collaboration, helping with proactive risk handling and regulatory compliance. Since its deployment, Insights has been crucial for airline analysts, providing real-time insights and optimizing resource utilization. One notable achievement was its role in managing overbookings, saving the airline several million dollars through optimized booking processes.
Client Needs
Efficient Data Procession & Search
Clear Data Visualization
Enhanced Passenger Data Analysis
System Development
The client's needs centered around developing a solution that could efficiently process and visualize extensive datasets related to passengers, flights, audits and airline risks. They required a system that could adapt to the evolving demands of the airline industry.
Services Provided
Big Data: Our data team assisted with the initial data analysis and the creation of a comprehensive data warehousing solution.
Data Visualization: Our team designed a data visualization layer that surfaces what is buried in airline data, so the decision-making team can interpret and analyse it.
Backend Development: We designed and developed a backend based on Java and Spring using a microservices architecture to handle the huge volumes of airline data.
Frontend Application Development: Development of an Angular-based frontend application for data search, visualization and audit management.
Customer Detection Algorithm: Research and development an algorithm to identify and unify airline passengers using residual data from various sources.
Scope of Work
Our team was involved from the beginning in the design and development process of the project. The main objective for the system was ability to process huge data sets from airline databases and make it easy effective to use for the airline analysts team. Our scope of work:
- Designing data visualization using D3 library for comprehensive and interactive graphs, enabling dynamic visualization of complex datasets. This allowed us to build custom, data-driven visual representation of passengers, flights and risks data that enabled in-depth analysis.
- Designing a Java/Spring backend based on a microservices architecture that was capable of processing and searching through large volumes of data.
- Designing and creating an Angular-based frontend application for search and visualizations of analytical data related to passengers, flights, audits, and airline risks.
- Engaging in ongoing cooperation with our client, including continuous development of new features to adapt to the constantly evolving business needs of airlines and incorporating feedback from the analysts' team. Utilizing machine learning to support the risk detection process in airlines and employing LLM large language model to assist analysts in finding information within large datasets.
- Researching and developing an algorithm to identify and unify airline passengers based on residual data from different sources.
Technologies Used
Development Process
Our development process involved close cooperation with the client to understand their needs and continuously adapt the system to their evolving requirements. We began with a series of workshops with the client to understand the intricacies of the aviation industry and familiarize ourselves with their complex data. Following these workshops we employed agile methodologies to ensure iterative development and timely delivery of features. Regular feedback from the client’s analysts was crucial in refining the functionalities. This close, adaptable way of working let us deliver a solution that clearly improved research and risk management at the airline. Upon witnessing Insights' ability to instantly display the history of intricate eTicket exchanges, the Internal Audit Manager remarked: "We have accomplished in 3 minutes what used to consume an entire afternoon."
Check our work on Clutch