TUI Group Case Study: Integrating Multiple Data Sources in One Warehouse with ETL

By leveraging the efficiency and scalability of Matillion ETL, TUI can now deliver more data insights to the business faster.

Their success

1

Up and running within five minutes, with first jobs in test within hours.

2

Processed volume of more than 150,000,000 rows per day

3

Achieved quick wins, with first results to the business in less than two days

About

TUI Group, based in Hanover, is the largest integrated tourism group worldwide, operating six airlines across Europe, 380 hotels in more than 30 destinations and approximately 150 medium and long-haul aircraft. TUI serves more than 27 million customers in 180 destinations around the world, and employs over 70,000 people. The TUI Group is listed in the FTSE 100 index, the leading index of the London Stock Exchange, and in the German open market.

Company: TUI Group

Location: Hanover

Industry: Travel and tourism

Employees: 70,000

Product: Matillion ETL for Snowflake

Use Case: Data Warehouse Modernization, Reporting & Analytics

Website: http://tuigroup.com/

The challenge

Migrating to the cloud for faster analytics and reporting

As the largest tour operator and leisure company in the world, TUI wanted to use vast amounts of data to glean answers to important questions about business performance. But its data warehouse architecture was limited to one on-premises system supporting only one of its hotel brands. In addition to being a partial data source, the existing system had long development cycles, in which it took weeks for developers to attach new data sources to the data warehouse and build complex business logic for analytics. TUI needed a more modern solution with a centralized, cloud-based data warehouse that included data from across all hotel brands.

The solution

Leveraging the power of the cloud for data transformation

TUI sought a cloud-native solution that addressed its vision for an ultra-scalable, fast, simple, and cost-effective modern data analytics tech stack. As part of that solution, the company needed a powerful ETL solution that could:

  • Consolidate multiple data sources, including Google Analytics, Salesforce, and third-party data such as currency exchange information
  • Orchestrate and schedule data loading and transformation for different source systems
  • Implement complex business logic and create parameterized, reusable shared jobs

After an in-depth evaluation, TUI selected Matillion ETL for Snowflake to best facilitate the transition to the cloud, aggregate its various data sources, and provide a flexible platform for data warehouse automation.

The benefits

Leveraging data to keep up with the pace of business

Once TUI selected Snowflake and Matillion, the company was able to move initial data sets into the Snowflake cloud data warehouse within minutes. Matillion ETL’s built-in features and native technologies allowed TUI to have its first jobs in test within a couple of hours, and running within one week. Matillion’s pre-built connectors allowed TUI developers to create data pipelines to multiple data sources quickly and easily.

TUI finds Matillion’s ELT approach (vs ETL) to be easy-to-maintain, expandable and stable, with a scalable data transformation platform for its cloud data warehouse solution. Since implementing Snowflake and Matillion, TUI has enabled teams across the business to answer more questions with data, faster, and have more confidence in the data behind those answers.

The results

  • Up and running within five minutes, with first jobs in test within hours

  • Achieved quick wins, with first results to the business in less than two days

  • Reduced run-time for large project builds

  • Processed volume of more than 150,000,000 rows per day

  • Received greater value for IT spend while mitigating risk

  • Experienced ease of use among both technical and non-technical teams

What's next?

Using Matillion to improve insight across the whole business

To increase access to and use of data to enable intelligent business decisions, TUI plans to move all of its systems, across all business units, to the cloud. With this expanded move to the cloud and to cloud-based data transformation, TUI hopes to achieve the same level of speed and insight across its other analytics departments.