Download PDF
GetYourGuide Experiences Hike in Growth with Looker
Technology Category
- Analytics & Modeling - Real Time Analytics
- Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Functions
- Business Operation
- Sales & Marketing
Use Cases
- Predictive Quality Analytics
- Real-Time Location System (RTLS)
Services
- Data Science Services
The Challenge
GetYourGuide, a travel experience booking platform, was facing challenges with its open source Relational Online Analytical Processing (ROLAP) cube. The tool required basic database skills to use, limiting the number of employees who could utilize it. As the company expanded, data volumes and the number of employees needing insights increased, resulting in sluggish query performance and an increase in time-outs. This led to an overburdened Data Platform team, as they were inundated with ad-hoc requests for insights. The team realized that they needed a new solution that could scale with the company's growth and make data accessible to all team members.
About The Customer
GetYourGuide is a travel experience booking platform that allows individuals to book travel experiences at over 7,500 destinations worldwide. From skip-the-line tickets to the top of the Eiffel Tower, to a walking tour through the ruins of Rome, more than 15 million individuals use GetYourGuide each month. Since its founding in 2009, travelers from more than 170 countries have used GetYourGuide to book over 20 million tours, activities, and attraction tickets. With more than 15 million monthly active users, GetYourGuide's business depends on making sure they are able to book the experience they want, when they want. The only quantitative way to know if they are meeting consumer needs and desires, is through data.
The Solution
GetYourGuide turned to Looker, a modern platform for data that delivers data analytics and business insights to every department at the point of decision. Looker's HTML5-based interface was accessible from any location and any web-enabled device, meeting GetYourGuide's first criterion of bringing data to every team member. Looker also provided productivity gains for the Data Platform team. With Looker's easy-to-use interface and LookML, Looker's SQL abstraction layer, the Data Platform team was able to answer user requests in less than an hour, a process that previously could take weeks. In less than a month, with only one engineer's time, GetYourGuide was able to migrate all of its critical data points to Looker.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Leading Tools Manufacturer Transforms Operations with IoT
Stanley Black & Decker required transparency of real-time overall equipment effectiveness and line productivity to reduce production line change over time.The goal was to to improve production to schedule, reduce actual labor costs and understanding the effects of shift changes and resource shifts from line to line.
Case Study
IoT Data Analytics Case Study - Packaging Films Manufacturer
The company manufactures packaging films on made to order or configure to order basis. Every order has a different set of requirements from the product characteristics perspective and hence requires machine’s settings to be adjusted accordingly. If the film quality does not meet the required standards, the degraded quality impacts customer delivery causes customer dissatisfaction and results in lower margins. The biggest challenge was to identify the real root cause and devise a remedy for that.
Case Study
Jaguar Land Rover Speeds Order-to-Cash Cycle
At Jaguar Land Rover, vehicles physically move around the facility for testing, configuration setting, rework and rectification, leading to a longer search time to get each vehicle to its next process facility. The main goal is to minimize the vehicles' dwell time between end of line and the delivery chain which was previously a manually intensive process. Jaguar Land Rover's goal was to build on the success of an earlier RFID project and improve the efficiency of delivering vehicles to meet dealer orders.
Case Study
Improve Postal Mail and Package Delivery Company Efficiency and Service
Postal mail and package delivery company wanted to replace legacy yard management system, increase inbound and outbound yard velocity, improve priority parcel delivery time and accuracy, reduce workload and overtime, reduce driver detention and measure performance and utilization of yard resources.
Case Study
Hospital Management Solution
The Oncology Diagnosis and Treatment Center of Brasov wanted to give patients as much freedom to roam as possible, while at the same time ensuring optimal patient safety and security. The centre was in need of an adequate wireless voice communication and messaging solution that would give patients the confi dence that medical staff is always on call, and reduce stress levels of nurses and doctors when called in case of urgent need.
Case Study
Worker Tracking & Safety Monitoring in Construction
One of the main challenges facing the technology was to create a network within underground tunnels and another was to provide products that can withstand harsh working environment. The team used amplifiers to enhance bandwidth and Litum produced IP67-rated hardware that is durable for harsh working conditions.
