<img src="https://ib.adnxs.com/pixie?pi=27b33857-af8c-4738-9b7c-8bad7e7554f3&amp;e=PageView&amp;script=0" width="1" height="1" style="display:none">

Customer Story | Google Cloud

Global eCommerce Company Accelerates Growth with Data and Analytics

Pythian empowers this global eCommerce company to streamline data management and enhance customer insights with Google BigQuery, boosting strategic decision-making capabilities.

Global eCommerce-CSSimg
    

Customer

Industry

eCommerce & POS

Location

Global, headquartered in Canada

Solution

Google BigQuery and Dataform

Platform

Google Cloud Platform


    

Overview

Based in Canada, the organization is a global provider of eCommerce and point-of-sale (POS) solutions. They serve businesses worldwide by integrating data analytics into their offerings to facilitate seamless transactions and operations for retailers, restaurateurs, and other business owners.

 

The eCommerce company faced significant challenges following a series of acquisitions that left their data strategy fragmented. The lack of a centralized data view impeded their ability to answer critical questions, such as customer count and acquisition costs, due to disparate data sources and inadequate integration. The absence of a unified data structure complicated efforts to track key performance indicators (KPI) and strategically upsell products.

    

What we did

  • Developed a GTV data mart to enable accurate reporting and analysis.
  • Utilized Dataform and BigQuery for advanced data analytics.
  • Developed Jupyter Notebooks for effective data comparison and validation.
  • Implemented data pipelines to streamline data flow across departments.
    

Technologies used

  • Google Cloud
  • Google BigQuery
  • Dataform
  • Jupyter Notebook
        

Key Outcomes

The collaboration with Pythian transformed the eCommerce company’s data management capabilities, enabling a unified view of customer data across departments. This integration improved strategic decision-making, as they could now effectively track and measure KPIs, enhancing their ability to upsell products.

“Wayfair has thousands of SQL applications and petabytes of data across our architecture. As we thought about modernization and leveraging Google Cloud, we relied on Pythian to be the experts on how to do it from an architectural perspective and then execute with our data team in actually getting it done.”
Matthew Ferrari

Head of Martech, Data and Machine Learning Platforms, and Infrastructure, Wayfair

Want to see similar results for your company?

Leverage our data analytics experts to get the most out of your data.
Related resources

Learn more about cloud infrastructure operations

Gain deeper insights into the advantages of the cloud. Check out our resources below.

What Google’s New BigQuery Pricing Tiers Mean For You

What Google’s New BigQuery Pricing Tiers Mean For You

May 9, 2023 12:00:00 AM 3 min read
Cloud Armor pt. 1 – Securing your Application with Google’s WAF Cloud Armor

Cloud Armor pt. 1 – Securing your Application with Google’s WAF Cloud Armor

May 31, 2022 12:00:00 AM 6 min read
An Initial Test of Google’s AlloyDB Columnar Engine

An Initial Test of Google’s AlloyDB Columnar Engine

May 30, 2022 12:00:00 AM 12 min read