Tableau Case Studies China Eastern Airlines: Using Tableau to Optimize Routes and Increase Revenue

Edit This Case Study Record

	China Eastern Airlines: Using Tableau to Optimize Routes and Increase Revenue Tableau

China Eastern Airlines: Using Tableau to Optimize Routes and Increase Revenue

Tableau

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Industries	Aerospace
Applicable Functions	Sales & Marketing
Use Cases	Demand Planning & Forecasting
Services	Data Science Services
Challenge	China Eastern Airlines, the second-largest carrier in China and the ninth-largest worldwide, was struggling with data analysis. The airline had a vast amount of data to share with management, sales, pricing, and other departments. However, the existing system, an Oracle database and IE browser, was slow and made it difficult to utilize the data effectively. The airline needed a tool that was not only easy for IT to use but also for business people. Read More
About Customer	China Eastern Airlines is a major Chinese airline that operates international, domestic, and regional routes. It is China's second-largest and the world's ninth-largest carrier by scheduled passengers carried. The airline has a vast amount of data to share with various departments, including management, sales, pricing, and others across the airline business. The data is stored in an Oracle database and displayed through an IE browser. However, the system was slow and made it difficult to utilize the data effectively. Read More
Solution	China Eastern Airlines discovered Tableau about six months ago and has since developed nine dashboards for separate uses. The dashboards are used by 500 people to analyze marketing, competition, other carriers, and flights-to-revenues. Tableau allows users to drill down to the core of the data easily. The airline uses marketing data from the ARC for the entire aviation industry to analyze market shares of some origin-to-destination (OD) routes. This analysis helps the airline open new flights where the market share is bigger, picking up passengers for increased revenues. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Aerospace

Applicable Functions

Sales & Marketing

Use Cases

Demand Planning & Forecasting

Services

Data Science Services

Challenge

China Eastern Airlines, the second-largest carrier in China and the ninth-largest worldwide, was struggling with data analysis. The airline had a vast amount of data to share with management, sales, pricing, and other departments. However, the existing system, an Oracle database and IE browser, was slow and made it difficult to utilize the data effectively. The airline needed a tool that was not only easy for IT to use but also for business people.

About Customer

China Eastern Airlines is a major Chinese airline that operates international, domestic, and regional routes. It is China's second-largest and the world's ninth-largest carrier by scheduled passengers carried. The airline has a vast amount of data to share with various departments, including management, sales, pricing, and others across the airline business. The data is stored in an Oracle database and displayed through an IE browser. However, the system was slow and made it difficult to utilize the data effectively.

Solution

China Eastern Airlines discovered Tableau about six months ago and has since developed nine dashboards for separate uses. The dashboards are used by 500 people to analyze marketing, competition, other carriers, and flights-to-revenues. Tableau allows users to drill down to the core of the data easily. The airline uses marketing data from the ARC for the entire aviation industry to analyze market shares of some origin-to-destination (OD) routes. This analysis helps the airline open new flights where the market share is bigger, picking up passengers for increased revenues.

Impact #1	The airline has seen a significant reduction in the time it takes to generate reports. Previously, hundreds of Excel reports would take two to four weeks to create with multiple tables. Now, it takes half an hour or 20 minutes.
Impact #2	The airline has been able to respond quicker to the market and make faster decisions for marketing and sales.
Impact #3	Tableau has been found to be easy to use and provides a fast response compared to other business intelligence tools.

Impact #1

The airline has seen a significant reduction in the time it takes to generate reports. Previously, hundreds of Excel reports would take two to four weeks to create with multiple tables. Now, it takes half an hour or 20 minutes.

Impact #2

The airline has been able to respond quicker to the market and make faster decisions for marketing and sales.

Impact #3

Tableau has been found to be easy to use and provides a fast response compared to other business intelligence tools.

Benefit #1	Using Tableau, the airline saw a 2 percent increase in revenue, equating to $200 million U.S. dollars.

Benefit #1

Using Tableau, the airline saw a 2 percent increase in revenue, equating to $200 million U.S. dollars.

Download PDF Version

Overview

China Eastern Airlines: Using Tableau to Optimize Routes and Increase Revenue

Operational Impact

Quantitative Benefit