Fivetran Case Studies Paul Hewitt's Transformation into a Data-Driven Business with Fivetran & Databricks

Edit This Case Study Record

	Paul Hewitt's Transformation into a Data-Driven Business with Fivetran & Databricks Fivetran

Paul Hewitt's Transformation into a Data-Driven Business with Fivetran & Databricks

Fivetran

Technology Category	Analytics & Modeling - Machine Learning Platform as a Service (PaaS) - Application Development Platforms
Applicable Industries	Construction & Infrastructure Retail
Applicable Functions	Maintenance Sales & Marketing
Use Cases	Predictive Maintenance Time Sensitive Networking
Services	Cloud Planning, Design & Implementation Services Data Science Services
Challenge	Paul Hewitt, a jewellery and accessory brand, was facing challenges in managing and analyzing its advertising spend due to the limitations of its existing tool, Supermetrics. The analytics team, consisting of three employees, had to manually enter data into spreadsheets to determine the most effective marketing channels, a process that was both time-consuming and prone to errors. To meet the needs of an increasingly complex supply chain, the company had invested in an ERP system, Microsoft Dynamics NAV, and began to make data available for analysis with Microsoft Power BI. However, the company wanted to take its data strategy to the next level by integrating data from across the business into one place on a cloud data platform, with the objective of transforming into a data-driven business. Read More
About Customer	Paul Hewitt is a renowned jewellery and accessory brand that was in the early stages of its online journey. The company was using Supermetrics for analyzing advertising spend but soon outgrew its capabilities. The analytics team was manually entering data from Supermetrics into spreadsheets to determine which channels were delivering the best return. To meet the needs of an increasingly complex supply chain, the company had invested in an ERP system, Microsoft Dynamics NAV, and began to make data available for analysis with Microsoft Power BI. The company's objective was to transform into a data-driven business by integrating data from across the business into one place on a cloud data platform. Read More
Solution	Paul Hewitt decided to use Databricks, a first-party Microsoft provider, as its data analytics platform. This was a natural choice as the company already had the Microsoft Azure cloud platform in place. Databricks helped eliminate data silos, enabling holistic analytics and data science, and setting the stage for future machine learning use cases. The company also used Azure and Delta Lake by Databricks for the data lake, and Power BI for visualization. To automate the pipeline from the data sources, the company chose Fivetran, an ELT provider, for its functionality and ease of use. Fivetran was set up to automatically load data from multiple advertising channel APIs into the data lake, providing better insights into marketing spend. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Machine Learning

Platform as a Service (PaaS) - Application Development Platforms

Applicable Industries

Construction & Infrastructure

Retail

Applicable Functions

Maintenance

Sales & Marketing

Use Cases

Predictive Maintenance

Time Sensitive Networking

Services

Cloud Planning, Design & Implementation Services

Data Science Services

Challenge

Paul Hewitt, a jewellery and accessory brand, was facing challenges in managing and analyzing its advertising spend due to the limitations of its existing tool, Supermetrics. The analytics team, consisting of three employees, had to manually enter data into spreadsheets to determine the most effective marketing channels, a process that was both time-consuming and prone to errors. To meet the needs of an increasingly complex supply chain, the company had invested in an ERP system, Microsoft Dynamics NAV, and began to make data available for analysis with Microsoft Power BI. However, the company wanted to take its data strategy to the next level by integrating data from across the business into one place on a cloud data platform, with the objective of transforming into a data-driven business.

About Customer

Paul Hewitt is a renowned jewellery and accessory brand that was in the early stages of its online journey. The company was using Supermetrics for analyzing advertising spend but soon outgrew its capabilities. The analytics team was manually entering data from Supermetrics into spreadsheets to determine which channels were delivering the best return. To meet the needs of an increasingly complex supply chain, the company had invested in an ERP system, Microsoft Dynamics NAV, and began to make data available for analysis with Microsoft Power BI. The company's objective was to transform into a data-driven business by integrating data from across the business into one place on a cloud data platform.

Solution

Paul Hewitt decided to use Databricks, a first-party Microsoft provider, as its data analytics platform. This was a natural choice as the company already had the Microsoft Azure cloud platform in place. Databricks helped eliminate data silos, enabling holistic analytics and data science, and setting the stage for future machine learning use cases. The company also used Azure and Delta Lake by Databricks for the data lake, and Power BI for visualization. To automate the pipeline from the data sources, the company chose Fivetran, an ELT provider, for its functionality and ease of use. Fivetran was set up to automatically load data from multiple advertising channel APIs into the data lake, providing better insights into marketing spend.

Impact #1	The new data architecture has significantly improved Paul Hewitt's operations. The single source of truth now accelerates the path to better reporting and enables dashboards that surface a wealth of data to more employees. Fivetran connectors took over the heavy lifting for the marketing analytics team, enabling a holistic overview of their channels for the first time. The company was also able to quickly shift their business from around 50% traditional retail to 100% eCommerce when the pandemic hit. The long-term business benefits will be about fulfilling the company’s goal to become data driven, democratising data by enabling non-technical people to access insights that inform better decision making.

Impact #1

The new data architecture has significantly improved Paul Hewitt's operations. The single source of truth now accelerates the path to better reporting and enables dashboards that surface a wealth of data to more employees. Fivetran connectors took over the heavy lifting for the marketing analytics team, enabling a holistic overview of their channels for the first time. The company was also able to quickly shift their business from around 50% traditional retail to 100% eCommerce when the pandemic hit. The long-term business benefits will be about fulfilling the company’s goal to become data driven, democratising data by enabling non-technical people to access insights that inform better decision making.

Benefit #1	Fivetran saves cost equal to one full-time engineer’s salary (60,000 to 80,000 € per year)
Benefit #2	The Modern Data Stack empowers Paul Hewitt to shift business from 50% traditional retail to 100% eCommerce during the pandemic
Benefit #3	The time it now takes to turn insights into actions is significantly shorter

Benefit #1

Fivetran saves cost equal to one full-time engineer’s salary (60,000 to 80,000 € per year)

Benefit #2

The Modern Data Stack empowers Paul Hewitt to shift business from 50% traditional retail to 100% eCommerce during the pandemic

Benefit #3

The time it now takes to turn insights into actions is significantly shorter

Download PDF Version

Overview

Paul Hewitt's Transformation into a Data-Driven Business with Fivetran & Databricks

Operational Impact

Quantitative Benefit