Skyscanner takes data to new heights with Tableau and Amazon Redshift

Skyscanner is flying high—but believes it can fly even higher. Skyscanner has a highly successful travel search product and loyal global customer base, in a fast-paced, ever-changing environment. According to Mark Shilton, Principal Analyst at Skyscanner, “We were quickly outgrowing our old data models, so we set about changing that.”

The outcome was the development of Squads and Tribes: groups of individuals coming together from cross-functional teams like marketing, commercial, product engineering, and other Skyscanner departments to innovate new ideas that help grow the business.

For these Tribes to thrive, Skyscanner needed to become a more data-driven organization, with results calculated using business-relevant metrics. Until recently, however, the organization relied on a dedicated business intelligence (BI) department, tasked to deliver the analytics needed for decision-making. The BI team would source data from the company’s SQL Server data warehouse, and ultimately delivered the data to teams using Excel spreadsheets.

As the business grew, Tribes had overwhelming volumes of data, ranging from web traffic to flight schedules and marketing campaign data—all buried in tens of thousands of spreadsheet rows. As a result, Tribes often overlooked important details. And the inflexible nature of spreadsheets meant that they couldn’t efficiently test hypotheses or react to new market opportunities.

This issue was prevalent in marketing campaign management. Each campaign came with a new spreadsheet. People would manually pull data, ‘copying and pasting’ the data that was relevant to them, leading to inaccurate reporting.

Skyscanner’s leadership also identified an opportunity to offer insights from the data they collect to business-to-business (B2B) partners, like airports, hotels, and car hire companies through the Skyscanner for Business Insights service. Partners use the data to gain insight into customers’ travel habits and plan for demand. For example, a hotel chain might mine the data to discover how many customers are browsing flights to Rome or Athens, increasing room capacity in these destinations with demand. Providing interactive dashboards via Tableau Server allows partners to dive deeper into the data.

To start, Shilton and his team trialed Tableau Cloud. “Tableau Cloud gave us a quick way to learn more about the technology, without getting involved in any complex set-up. In a few hours, with no training, we could create our own dashboards, drill down instantly into the data, and edit views,” he says.

After evaluating several other vendors, they quickly found that Tableau best suited their needs. Shilton said, “Compared with solutions from Microstrategy and Qlik, Tableau is more flexible and easy to use. It allows us to be agile and experimental; to share ideas at the click of a mouse.”

Skyscanner opted to purchase Tableau Desktop and Tableau Server. In Tableau, teams can connect directly to their data stored in Amazon Redshift. This solution provides a flexible, scalable data architecture alongside powerful visual analytics.

“We can spin up an Amazon Redshift cluster very easily; there’s no need to buy or administer any servers,” says Shilton. “When a dashboard is published to Tableau Server, the Tribes can access it securely from any browser or mobile device. We even track and monitor the monthly cost of the Amazon environment in Tableau.”

Skyscanner also uses Google BigQuery with Tableau and Python. “While in the past it was tricky to get a fully unsampled report based on specific segments of users flowing directly from Google Analytics Premium into a Tableau dashboard, now it is simply a matter of writing the query, creating a connection in Tableau to automatically refresh the data daily, and publishing this dashboard to the rest of the company.”

The company accesses free training videos, live online training, and the Tableau community forums to answer questions and develop their Tableau skills.

Today, Skyscanner uses a self-service analytics model. Many of Skyscanner’s staff of 800 relies on Tableau to conduct their own analysis and guide decision making, relying on a small team of data engineers for data preparation and quality control and freeing up more time for data scientists to concentrate on more complex, higher value work.

Skyscanner benefits from enhanced travel intelligence—sharing insights across the business in record time. The company now has easier access to analytics around campaign success, ROI, and forecasting.

Shilton commented, “By teaching everyone how to handle data in the tools they’re familiar with, you’ll move the focus of their questions. People would previously ask, “Can you put this in a dashboard for me?” Now they ask, “Where can I get the data I need?”

Opportunities for growth: With Tableau, Skyscanner’s Growth teams can easily track the performance of their campaigns and experiments, getting top-level performance metrics and easily drilling down to specifics. This enables the organization to fine-tune their growth efforts in a truly agile way in line with Skyscanner’s working methods.

With scheduled refreshes in Tableau Server, teams work off of current data for accurate forecasting. Instead of spending several hours a week compiling data, leadership now has the data they need, when they need it.

Within Skyscanner’s Wi-Fi sponsorship program, the Growth Tribe compared activated Skyscanner customers against their Wi-Fi use in particular airports. The Tribe uses this data to determine the program’s return on investment. “This instant analysis means we can be more agile as an organization, moving more quickly to capitalize on market opportunities,” says Shilton.