Pentaho Helps Lufthansa Quickly Identify Passenger Data Transmission Errors in Its Partner Airline Network
Customer Company Size
Large Corporate
Region
- Europe
Country
- Germany
Product
- Pentaho Business Analytics
- Pentaho Data Integration
- Pentaho Consulting Services
Tech Stack
- MySQL
- Enterprise Service Bus (ESB)
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Customer Satisfaction
- Productivity Improvements
Technology Category
- Analytics & Modeling - Real Time Analytics
- Platform as a Service (PaaS) - Data Management Platforms
Applicable Industries
- Transportation
Applicable Functions
- Business Operation
Use Cases
- Predictive Maintenance
- Real-Time Location System (RTLS)
Services
- Software Design & Engineering Services
- System Integration
About The Customer
Deutsche Lufthansa AG is a global aviation company and the largest European airline. It operates in five business areas: passenger traffic, logistics, technical services, catering, and IT services. Lufthansa, along with its airlines Austrian, Swiss, and Germanwings, carries over 100 million passengers annually to more than 240 destinations. The company is headquartered in Frankfurt, Germany, and is a key player in the travel and airline industry. Lufthansa's passenger systems unit provides interfaces for network operations, ensuring smooth operations of the Inter Airline Through Check In (IATCI) process. This process allows passengers to check in for all flight legs at the start of their journey, involving the transmission of various passenger data to different airlines' IT systems. The company faced challenges with transmission errors, which could lead to passenger inconveniences and increased operational costs.
The Challenge
Lufthansa faced significant challenges in managing passenger data transmission errors within its partner airline network. The Inter Airline Through Check In (IATCI) process, which allows passengers to check in for all flight legs at the start of their journey, relies on the EDIFACT transmission standard. This standard is implemented on legacy mainframe systems, which are prone to errors, especially when airlines reconfigure their IT systems or introduce new functions. These transmission errors can lead to passenger inconveniences and increased operational costs. The existing system recorded EDIFACT transmissions in static log files, which were overwritten weekly, making error diagnosis a time-consuming manual process. Lufthansa needed a solution to make the IATCI process accessible, measurable, and available for real-time operational monitoring.
The Solution
Lufthansa implemented Pentaho's operational BI solution to address the challenges of managing passenger data transmission errors. The solution included Pentaho Data Integration for data retrieval, transformation, and loading, and Pentaho Business Analytics for real-time data analysis and report generation. Pentaho was installed on a powerful server with 16 CPU cores, and data was stored on a MySQL database. The initial data volume was about 10GB per month, expected to increase to 200GB per month as Pentaho expanded to cover more areas. An Enterprise Service Bus (ESB) was implemented around the existing system, creating additional interfaces for data retrieval and analysis. Pentaho's user-friendly interface allowed IT users to create new data links using drag-and-drop visual tools, enabling quick setup and operation. The solution provided real-time monitoring of the IATCI process, allowing Lufthansa to quickly identify and address transmission errors, improving operational efficiency and customer satisfaction.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
Case Study
Airport SCADA Systems Improve Service Levels
Modern airports are one of the busiest environments on Earth and rely on process automation equipment to ensure service operators achieve their KPIs. Increasingly airport SCADA systems are being used to control all aspects of the operation and associated facilities. This is because unplanned system downtime can cost dearly, both in terms of reduced revenues and the associated loss of customer satisfaction due to inevitable travel inconvenience and disruption.
Case Study
IoT-based Fleet Intelligence Innovation
Speed to market is precious for DRVR, a rapidly growing start-up company. With a business model dependent on reliable mobile data, managers were spending their lives trying to negotiate data roaming deals with mobile network operators in different countries. And, even then, service quality was a constant concern.
Case Study
Digitize Railway with Deutsche Bahn
To reduce maintenance costs and delay-causing failures for Deutsche Bahn. They need manual measurements by a position measurement system based on custom-made MEMS sensor clusters, which allow autonomous and continuous monitoring with wireless data transmission and long battery. They were looking for data pre-processing solution in the sensor and machine learning algorithms in the cloud so as to detect critical wear.
Case Study
Cold Chain Transportation and Refrigerated Fleet Management System
1) Create a digital connected transportation solution to retrofit cold chain trailers with real-time tracking and controls. 2) Prevent multi-million dollar losses due to theft or spoilage. 3) Deliver a digital chain-of-custody solution for door to door load monitoring and security. 4) Provide a trusted multi-fleet solution in a single application with granular data and access controls.
Case Study
Vehicle Fleet Analytics
Organizations frequently implement a maintenance strategy for their fleets of vehicles using a combination of time and usage based maintenance schedules. While effective as a whole, time and usage based schedules do not take into account driving patterns, environmental factors, and sensors currently deployed within the vehicle measuring crank voltage, ignition voltage, and acceleration, all of which have a significant influence on the overall health of the vehicle.In a typical fleet, a large percentage of road calls are related to electrical failure, with battery failure being a common cause. Battery failures result in unmet service agreement levels and costly re-adjustment of scheduled to provide replacement vehicles. To reduce the impact of unplanned maintenance, the transportation logistics company was interested in a trial of C3 Vehicle Fleet Analytics.
Case Study
3M Gains Real-Time Insight with Cloud Solution
The company has a long track record of innovative technology solutions. For example, 3M helps its customers optimize parking operations by automating fee collection and other processes. To improve support for this rapidly expanding segment, 3M needed to automate its own data collection and reporting. The company had recently purchased the assets of parking, tolling, and automatic license plate reader businesses, and required better insight into these acquisitions. Chad Reed, Global Business Manager for 3M Parking Systems, says, “With thousands of installations across the world, we couldn’t keep track of our software and hardware deployments, which made it difficult to understand our market penetration.” 3M wanted a tracking application that sales staff could use to get real-time information about the type and location of 3M products in parking lots and garages. So that it could be used on-site with potential customers, the solution would have to provide access to data anytime, anywhere, and from an array of mobile devices. Jason Fox, Mobile Application Architect at 3M, upped the ante by volunteering to deliver the new app in one weekend. For Fox and his team, these requirements meant turning to the cloud instead of an on-premises datacenter. “My first thought was to go directly to the cloud because we needed to provide access not only to our salespeople, but to resellers who didn’t have access to our internal network,” says Fox. “The cloud just seemed like a logical choice.”
