Scales Analytics and Standardizes 10 Different CRMs with Dataprep by Trifacta
In 2019, Homeserve undertook the company’s biggest challenge yet: migrating from a 15-year-old on-premise data stack to Google Cloud Platform (GCP) and replacing its in-house CRM with Salesforce. Alongside this data modernization initiative, Homeserve needed to revamp its IT processes, too; instead of directly serving business units, Homeserve IT wanted to adopt technologies that would enable self-service and allow for increased autonomy among internal experts. Freeing up the IT team’s time was critical in allowing the team to accomplish its mounting list of projects—one of which was mapping data from 10 newly-acquired companies and their unique CRMs to Salesforce. Homeserve sought out a self-service, ETL-esque technology that would allow for increased data access among its business users and assist with data transformation challenges within IT.
How Dataprep Solved this Problem
Homeserve adopted Dataprep, a data engineering platform that integrates seamlessly with the Google Cloud ecosystem and Salesforce. Dataprep has become the go-to technology for Homeserve data analysts, marketers, and salespeople to access and prepare the data they need to build reports and manage KPIs. It has also greatly accelerated IT’s work in transforming and moving data from a variety of newly-acquired CRMs to the company standard, Salesforce. Finally, Dataprep has also allowed for the rapid transfer of product-related data from Salesforce to its Google Cloud data lake storage. Trifacta’s ease-of-use, cost-efficiency, and seamless integration has allowed Homeserve to scale analytics across the company and more easily move and transform data between sources.
Instead of costly licensing and enterprise fees, Homeserve only pays for what they use.
Seamless GCP integration
No struggling to integrate Dataprep with relevant services; Dataprep was built for the Google Cloud ecosystem.
Dataprep has a familiar spreadsheet look but has powerful data engineering capabilities.
Google Cloud Platform
Dataprep by Trifacta
HomeServe’s mission is simple: to free its customers from the worry and inconvenience of home emergency repairs.
“Early on, we recognized the benefits of building on top of Google Cloud Platform and a Cloud Data Warehouse, but needed a technology that would allow our data analysts to manage their own data pipelines instead of strictly relying on our data engineering team. Moving to Cloud Dataprep by Trifacta Premium, our analysts have more autonomy to manage and prepare their data than ever before, whether that’s leveraging Google Analytics data stored in BigQuery or migrating new data from or into Salesforce, which leads to enormous productivity gains.”
Thibaut GadioletProduct Manager of Data Platforms, HomeServe