CASE STUDY
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 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 centralised , cloud-based data warehouse that included data from across all hotel brands .
The solution
Using the power of the cloud for data transformation
TUI sought a cloud-native solution that would enable an ultra-scalable , fast , simple and cost-effective modern data analytics tech stack . The company also 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 parameterised , reusable shared jobs
TUI selected Matillion ETL for Snowflake to help it move to the cloud , aggregate data sources and provide a flexible platform for data warehouse automation .
“ Matillion ’ s scalability and efficiency were a gamechanger for our growing , global business ,” said Kai Wolffram , Head of Analytics , TUI Group . “ 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 .”
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 datasets 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 prebuilt 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 easyto-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
www . intelligentcio . com INTELLIGENTCIO EUROPE 59