TUI Group Case Study: Integrating Multiple Data Sources in One Warehouse with ETL
Join us at the Snowflake Summit in Las Vegas, 26th - 29th June. Click for more information.
By leveraging the efficiency and scalability of Matillion ETL, TUI can now deliver more data insights to the business faster.
Their success
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: https://tuigroup.com/
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.
“Matillion’s scalability and efficiency were a game-changer for our growing, global business. We immediately leveraged the power of the cloud and saw instant value from increased performance. In Matillion, we found a modern, flexible solution that enables true data insights, and is fun to work with because it’s so easy to use.”
Kai Wolfram, Head of Analytics
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
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.