Scoot Case Study


Faye Gillespie, | May 26, 2021

3 Minutes

About the Client

Scoot is one of the most high-growth and successful low-cost airlines in the Southern Asian region. As a value-oriented airline it focuses on innovation all along the way of the customer journey. Its aim is to provide an affordable service with great user experience for its clients. Nevertheless, in order to be able to grow and open up new destinations, Scoot needs to understand the profitability of their flights and the real challenges in their operation. In order to successfully achieve the above mentioned goals, it is very important for the company to have a unified data warehouse where they can get a clear view on their operations, flights and customers, learn from the recorded data, and make the necessary decisions to increase the customer experience while keeping the company financially successful as well.

Challenge: scattered data sources

Before starting to build up a data warehouse in Google Cloud Platform, there were several scattered, separated data sources which were not linked together and caused several problems for Scoot:

  • Not consistent and fully reliable data based on which reporting could be done
  • No single customer view, hard to identify interconnected bookings
  • Hard to analyze the profitability of each flight/segment/leg
  • No flexibility on reporting from the separate systems
  • No agreed and unified facts and dimensions across the system All in all, there was a not questionable need for a data warehouse which can serve as a source of truth and basis of business decisions.

Solution: Single, consistent, trustful picture

ALiZ developed a GCP based data warehouse in 1 year to Scoot which can provide a single, consistent, trustful picture following the below steps:

  • Specify reporting requirements with the client what each business user groups require
  • Connect to each data source and extract data to BigQuery, using Talend
  • Transform data in BigQuery using SQL transforms and create dimensions and facts in Enterprise Data Warehouse (EDW) tables, so the data is consumable by business users, using Tableau Setup a Database monitoring and Access management system to support the live system operation with security alerts, cost control and easy user access handling

Business Value

By providing an integrated source of data from connecting the most important systems, ALiZ helped Scoot to achieve its goal, and collect and combine data all along the way of the customer journey and able to differentiate profitability on different flights, segments and legs level. But the real business value comes from the insights and personalized interactions themselves that are built on the recorded data. An example use case is understanding the marketing channel effectiveness. With the Google BigQuery based data warehouse housing the necessary data sources together, Scoot is able to stitch each channel’s conversion at the booking and passenger level, unveiling insights that can help them better understand each channel’s effectiveness, optimise marketing spend and select more relevant routes in marketing efforts. Apart from complex reporting, machine learning use cases can be built upon the new system like predicting distressed routes. As the data is housed in EDW, this data feed can be automated in remarketing efforts, thus further optimising marketing spend.


We teamed up with Indonesian Bank Jago to deliver data and infra consulting services to help them achieve their goal of being a digital bank of the future.


We helped one of the largest independent marketing platform companies migrate from Heroku to GCP to benefit from better storage, seamless scaling and more.


We helped European electronics retailer Conrad Electronic decrease their customer churn and offer their customers a more personalized experience.


Ready for the future? Let’s talk!

Reach out, and let’s take your business to the next level.


By clicking submit below, you consent to allow Aliz.ai to store and process the personal information submitted above and share information about our products and services, as well as other content that may be of interest to you. For more information, please review our Privacy Policy.

I agree to receive other communications from Aliz.ai.


© Copyright 2022 Aliz Tech Kft.
Aliz is a proud Google Cloud Premier Partner with specializations in Data Analytics and Machine Learning. We deliver data analytics, machine learning, and infrastructure solutions, off the shelf, or custom-built on GCP using an agile, holistic approach.


designed and executed with kifli by kifli.tech