Company Size
1,000+
Region
- Europe
Country
- Italy
- Netherlands
Product
- Looker
- Amazon Redshift
- Snowplow
- Stitch
- Talend
Tech Stack
- MySQL
- Google Sheets
- Mandrill
- Google Analytics
- Salesforce CRM
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Cost Savings
- Customer Satisfaction
- Productivity Improvements
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
About The 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.
The 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.
The 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.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
Case Study
Improving Vending Machine Profitability with the Internet of Things (IoT)
The vending industry is undergoing a sea change, taking advantage of new technologies to go beyond just delivering snacks to creating a new retail location. Intelligent vending machines can be found in many public locations as well as company facilities, selling different types of goods and services, including even computer accessories, gold bars, tickets, and office supplies. With increasing sophistication, they may also provide time- and location-based data pertaining to sales, inventory, and customer preferences. But at the end of the day, vending machine operators know greater profitability is driven by higher sales and lower operating costs.
Case Study
Series Production with Lot-size-1 Flexibility
Nobilia manufactures customized fitted kitchens with a lot size of 1. They require maximum transparency of tracking design data and individual processing steps so that they can locate a particular piece of kitchen furniture in the sequence of processes.
Case Study
American Eagle Achieves LEED with GE LED Lighting Fixtures
American Eagle Outfitters (AEO) was in the process of building a new distribution center. The AEO facility management team decided to look at alternate options for lighting layout that could provide energy and maintenance savings. AEO would need a full-time maintenance employee just to replace burned-out fluorescent tubes.
Case Study
Revolutionizing Rodent Control
From pet- and child-safe traps, to touch-free and live-catch rodent control solutions, Victor continues to stay committed to producing superior products that meet the varying needs of today’s pest control professionals. And, with a long standing history supporting customers in the food processing, service, and retail settings, Victor knew that strict regulations were costing organizations thousands of dollars in excess overhead trying to manage their rodent-control solutions. Trap inspections in these environments are often difficult and time consuming, requiring personnel to manually check a trap’s status multiple times per day, amounting to over six hours of manual labor. Victor is looking for an innovative way to increase operational efficiencies with the use of technology.