www.matillion.com Open in urlscan Pro
2a04:4e42:200::645  Public Scan

Form analysis
1 forms found in the DOM

GET /

<form method="get" id="searchForm" class="mega-search expand-to-left" action="/"> <span class="search-btn"></span>
  <div class="search-cover"> <input type="submit" id="searchsubmit" value="Search"> <input type="text" value="" name="s" id="s" placeholder="What are you looking for?"></div>
</form>

Text Content

MENUMENU
 * Support
   * Mission Critical Support
   * Support Portal
 * About
   * Leadership
   * News
   * Careers
   * Brand and Media Kit
   * Investors
 * Contact
 * Sign in

MENUMENU
 * Products
   * Matillion ETL
   * Matillion Data Loader
 * Solutions
   
   * * * TYPES OF SOLUTIONS
         
          * Data Transformation
          * Data Analytics
          * Data Integration
          * Data Lakes
          * Data Preparation
          * Data Governance
     
     * * SOLUTIONS FOR
         
          * Enterprise
          * SMB
 * Technology
   * Cloud Data Warehouse
     * Snowflake
     * Amazon Redshift
     * Google BigQuery
     * Microsoft Azure Synapse
   * Lakehouse
     * Delta Lake on Databricks
   * ELT
   * Integrations
   * Universal Connectivity
   * Security Portal
 * Pricing
 * Partners
   * Become a Partner
   * Partner Log-In
 * Resources
   * Blog
   * Events & Webinars
   * Case Studies
   * eBooks
   * Guides
     * What is ETL? The Ultimate Guide
     * What is Data Integration? The Ultimate Guide
   * Data Glossary
   * Documentation
   * Matillion Community
   * Matillion Exchange
   * Matillion Academy
   * Certifications
 * Get a demo
 * Get started

Close
 * Products
   * Matillion ETL
   * Matillion Data Loader
 * Solutions
   * Data Transformation
   * Data Analytics
   * Data Integration
   * Data Lakes
   * Data Preparation
   * Data Governance
   * SMB
   * Enterprise
 * Technology
   * Cloud Data Warehouse
     * Amazon Redshift
     * Google BigQuery
     * Microsoft Azure Synapse
     * Snowflake
   * Lakehouse
     * Delta Lake on Databricks
   * ELT
   * Integrations
   * Universal Connectivity
   * Security
 * Pricing
 * Partners
   * Become a Partner
 * Resources
   * Blog
   * Events & Webinars
   * Case Studies
   * Guides
     * What is ETL? The Ultimate Guide
     * What is Data Integration? The Ultimate Guide
   * Data Glossary
   * Documentation
   * Matillion Community
   * Matillion Exchange
   * Matillion Academy
   * Certifications
 * About
   * Leadership
   * News
   * Careers
   * Investors
   * Contact
 * Support
   * Mission Critical Support
   * Support Portal
 * Request a Demo


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


TUI GROUP CASE STUDY: INTEGRATING MULTIPLE DATA SOURCES IN ONE WAREHOUSE WITH
ETL

DOWNLOAD
2:57










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: https://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.

> “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

 * 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.

DOCUSIGN CASE STUDY: MIGRATING TO SNOWFLAKE CASE STUDY

DUO SECURITY CASE STUDY: FINANCIAL REPORTING IN THE CLOUD CASE STUDY

FITNESS & LIFESTYLE GROUP CASE STUDY: ETL FOR DATA MIGRATION DURING ACQUISITIONS
CASE STUDY

 * Cloud ETL Products
   * Matillion ETL
   * Matillion Data Loader
   * Pricing
   * Try Matillion
 * Solutions
   * Data Transformation
   * Data Analytics
   * Data Integration
   * Data Lakes
   * Data Preparation
   * Data Governance
   * Enterprise
   * SMB
 * Technology
   * Cloud Data Warehouse
   * ELT
   * Integrations
   * Universal Connectivity
   * Security
 * Resources
   * Blog
   * Events & Webinars
   * Case Studies
   * eBooks
   * Data Glossary
   * Documentation
   * Matillion Community
   * Matillion Exchange
   * Matillion Academy
   * Certifications
 * About
   * Leadership
   * News
   * Careers
   * Investors
   * Brand and Media Kit
   * Contact
 * Support
   * Mission Critical Support
   * Support Portal

 * MANCHESTER
 * DENVER
 * MADRID

© Copyright 2022 Matillion Ltd

 * Legal
 * Privacy Policy
 * Disclaimer

 * 
 * 
 * 
 * 
 * 

×
×
×
Notice

We and selected third parties use cookies or similar technologies for technical
purposes and, with your consent, for other purposes as specified in the cookie
policy. Denying consent may make related features unavailable.

In case of sale of your personal information, you may opt out by using the link
"Do Not Sell My Personal Information".

To find out more about the categories of personal information collected and the
purposes for which such information will be used, please refer to our privacy
policy.

Use the “Accept” button to consent to the use of such technologies.

Press again to continue 0/2
Learn more and customize
Accept