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

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

Fivetran Logo
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
About The 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.
The 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.
The 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.
Operational Impact
  • 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.
Quantitative Benefit
  • Fivetran saves cost equal to one full-time engineer’s salary (60,000 to 80,000 € per year)
  • The Modern Data Stack empowers Paul Hewitt to shift business from 50% traditional retail to 100% eCommerce during the pandemic
  • The time it now takes to turn insights into actions is significantly shorter

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.