Download PDF
JetBlue's Real-Time Analytics Transformation with Fivetran and Snowflake
Technology Category
- Functional Applications - Computerized Maintenance Management Systems (CMMS)
- Infrastructure as a Service (IaaS) - Cloud Databases
Applicable Industries
- Buildings
- Cement
Applicable Functions
- Maintenance
- Warehouse & Inventory Management
Use Cases
- Asset Health Management (AHM)
- Predictive Maintenance
Services
- Cloud Planning, Design & Implementation Services
- Data Science Services
The Challenge
JetBlue, a major airline operating over 900 flights daily to more than 110 cities, was grappling with the challenge of managing and analyzing the vast amount of data generated by its operations. Every person, plane, and journey generated data points that could provide insights into customer sentiments, revenue forecasting, fuel consumption, aircraft maintenance, and operational readiness. However, the sheer volume of data, sourced from 130 different systems, was overwhelming and difficult to organize. The airline needed a solution that could centralize this data, making it readily accessible for analysis and decision-making. The challenge was to bring all this data into a single platform quickly and accurately for analysis.
About The Customer
JetBlue is a major airline that carries customers to more than 110 cities throughout the United States, Latin America, the Caribbean, Canada, and the United Kingdom. The airline operates an average of 900+ flights per day. Every person, plane, and journey generates data points that reveal customer sentiments, inform revenue forecasting, help predict fuel consumption, prescribe aircraft maintenance, and give critical insight into operational readiness. The airline was facing challenges in managing and analyzing this vast amount of data, which was sourced from 130 different systems.
The Solution
JetBlue decided to build a modern, cloud-based data stack using Fivetran and Snowflake. Fivetran's pipelining tools enabled JetBlue to move data from multiple sources to its Snowflake data cloud. This allowed the data engineering team to rapidly access information for analytic use cases and significantly reduced the time it took to manually build data pipelines. JetBlue's Snowflake data warehouse now contains over 115TB of data, and fresh data is readily available for analysis. The airline also built a suite of self-service analytics products, used by analysts and leaders across many workgroups to deliver meaningful insights. For instance, JetBlue integrated Qualtrics customer survey data into Snowflake using Fivetran's Qualtrics connector, enabling the airline to better understand its customers and enhance their experiences.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Energy Saving & Power Monitoring System
Recently a university in Taiwan was experiencing dramatic power usage increases due to its growing number of campus buildings and students. Aiming to analyze their power consumption and increase their power efficiency across 52 buildings, the university wanted to build a power management system utilizing web-based hardware and software. With these goals in mind, they contacted Advantech to help them develop their system and provide them with the means to save energy in the years to come.
Case Study
System 800xA at Indian Cement Plants
Chettinad Cement recognized that further efficiencies could be achieved in its cement manufacturing process. It looked to investing in comprehensive operational and control technologies to manage and derive productivity and energy efficiency gains from the assets on Line 2, their second plant in India.
Case Study
Intelligent Building Automation System and Energy Saving Solution
One of the most difficult problems facing the world is conserving energy in buildings. However, it is not easy to have a cost-effective solution to reduce energy usage in a building. One solution for saving energy is to implement an intelligent building automation system (BAS) which can be controlled according to its schedule. In Indonesia a large university with a five floor building and 22 classrooms wanted to save the amount of energy being used.
Case Study
Powering Smart Home Automation solutions with IoT for Energy conservation
Many industry leaders that offer Smart Energy Management products & solutions face challenges including:How to build a scalable platform that can automatically scale-up to on-board ‘n’ number of Smart home devicesData security, solution availability, and reliability are the other critical factors to deal withHow to create a robust common IoT platform that handles any kind of smart devicesHow to enable data management capabilities that would help in intelligent decision-making
Case Study
Commercial Building Automation Boosts Energy Efficiency
One of the challenges to building automation is the multitude of non-interoperable communications protocols that have evolved over the years. Buildings have several islands of automation. Bridging the islands of different automation without losing the considerable investment in each specialized control network is the main focus in this solution.
