Google Cloud Platform Case Studies Werkspot Leverages Looker to Improve Home Services

Edit This Case Study Record

	Werkspot Leverages Looker to Improve Home Services Google Cloud Platform

Werkspot Leverages Looker to Improve Home Services

Google Cloud Platform

Technology Category	Analytics & Modeling - Data-as-a-Service Analytics & Modeling - Real Time Analytics Infrastructure as a Service (IaaS) - Cloud Computing
Applicable Industries	Consumer Goods Professional Service
Applicable Functions	Business Operation Sales & Marketing
Use Cases	Demand Planning & Forecasting Inventory Management Supply Chain Visibility
Services	Data Science Services System Integration
Challenge	Werkspot, an online marketplace for home improvement services, faced the challenge of balancing supply and demand. With over 12,000 service professionals and two million jobs posted on its platform, analyzing data from various sources became a daunting task. The company's BI team was overwhelmed with pulling reports, building dashboards, and handling ad-hoc requests, leading to a two-week turnaround time for business users to get the insights they needed. Werkspot needed a data analytics and visualization tool to streamline this process and provide real-time, actionable insights to its employees. The company also wanted to avoid hiring additional analysts and instead focus on more valuable data engineer and data scientist roles. Read More
About Customer	Founded in The Netherlands in 2005, Werkspot is an online marketplace for individuals to find and connect with trusted service professionals for home improvement, renovation, maintenance, and repair. As of 2018, Werkspot serves over 12,000 service professionals in the Netherlands and Italy, with homeowners posting over 2 million jobs. Werkspot’s mission is to be the easiest and most reliable way to arrange home services. The company achieves this through marketplace management – maintaining a balance of supply and demand. Demand is represented by the number of jobs consumers are posting, and the service professionals that can carry out these jobs constitute the supply. Keeping these two numbers in harmony is a key factor in Werkspot’s success as a business – it helps ensure both homeowners’ and service professionals’ needs are met, and therefore, increases the likelihood of them coming back (and referring others) to the platform. Read More
Solution	Werkspot turned to Looker, a unified Platform for Data, to deliver actionable insights to every employee at the point of decision. More than half of Werkspot’s employees across various departments now use Looker every day to get real-time insights from their data. This has helped the company to make informed decisions about which advertising campaigns to ramp up or down and which job postings to improve. Werkspot also set up a data warehouse to get a better overview across its business. They worked with the Looker team to set up a Redshift instance and create a reusable, scalable model for tracking their consumer insights metrics using LookML. By setting up its consumer insights report in a Looker dashboard, decision makers at Werkspot could find their own answers to all of the follow-up questions they had due to the drill-down nature and interactivity of the platform. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Data-as-a-Service

Analytics & Modeling - Real Time Analytics

Infrastructure as a Service (IaaS) - Cloud Computing

Applicable Industries

Consumer Goods

Professional Service

Applicable Functions

Business Operation

Sales & Marketing

Use Cases

Demand Planning & Forecasting

Inventory Management

Supply Chain Visibility

Services

Data Science Services

System Integration

Challenge

Werkspot, an online marketplace for home improvement services, faced the challenge of balancing supply and demand. With over 12,000 service professionals and two million jobs posted on its platform, analyzing data from various sources became a daunting task. The company's BI team was overwhelmed with pulling reports, building dashboards, and handling ad-hoc requests, leading to a two-week turnaround time for business users to get the insights they needed. Werkspot needed a data analytics and visualization tool to streamline this process and provide real-time, actionable insights to its employees. The company also wanted to avoid hiring additional analysts and instead focus on more valuable data engineer and data scientist roles.

About Customer

Founded in The Netherlands in 2005, Werkspot is an online marketplace for individuals to find and connect with trusted service professionals for home improvement, renovation, maintenance, and repair. As of 2018, Werkspot serves over 12,000 service professionals in the Netherlands and Italy, with homeowners posting over 2 million jobs. Werkspot’s mission is to be the easiest and most reliable way to arrange home services. The company achieves this through marketplace management – maintaining a balance of supply and demand. Demand is represented by the number of jobs consumers are posting, and the service professionals that can carry out these jobs constitute the supply. Keeping these two numbers in harmony is a key factor in Werkspot’s success as a business – it helps ensure both homeowners’ and service professionals’ needs are met, and therefore, increases the likelihood of them coming back (and referring others) to the platform.

Solution

Werkspot turned to Looker, a unified Platform for Data, to deliver actionable insights to every employee at the point of decision. More than half of Werkspot’s employees across various departments now use Looker every day to get real-time insights from their data. This has helped the company to make informed decisions about which advertising campaigns to ramp up or down and which job postings to improve. Werkspot also set up a data warehouse to get a better overview across its business. They worked with the Looker team to set up a Redshift instance and create a reusable, scalable model for tracking their consumer insights metrics using LookML. By setting up its consumer insights report in a Looker dashboard, decision makers at Werkspot could find their own answers to all of the follow-up questions they had due to the drill-down nature and interactivity of the platform.

Impact #1	Faster time to action: From two weeks to 20 minutes. Today, over half of the employees at Werkspot across marketing, sales, support, product, and the management team use Looker to make decisions about the business. And they have gone from waiting up to two weeks, to having the data they need at their fingertips to help them do their jobs better.
Impact #2	More insights, without more analysts: Looker has helped Werkspot increase the amount of insights it gets into its business, without needing to hire more analysts. Instead, they’ve been able to put this headcount towards more valuable roles such as data engineers and data scientists.

Impact #1

Faster time to action: From two weeks to 20 minutes. Today, over half of the employees at Werkspot across marketing, sales, support, product, and the management team use Looker to make decisions about the business. And they have gone from waiting up to two weeks, to having the data they need at their fingertips to help them do their jobs better.

Impact #2

More insights, without more analysts: Looker has helped Werkspot increase the amount of insights it gets into its business, without needing to hire more analysts. Instead, they’ve been able to put this headcount towards more valuable roles such as data engineers and data scientists.

Benefit #1	Looker saved Werkspot from having to hire five additional analysts.
Benefit #2	Reduced turnaround time for business users to get insights from two weeks to 20 minutes.

Benefit #1

Looker saved Werkspot from having to hire five additional analysts.

Benefit #2

Reduced turnaround time for business users to get insights from two weeks to 20 minutes.

Download PDF Version

Overview

Werkspot Leverages Looker to Improve Home Services

Operational Impact

Quantitative Benefit