Fivetran Case Studies Princess Polly Leverages Modern Data Stack for Enhanced Retail Analytics

Edit This Case Study Record

	Princess Polly Leverages Modern Data Stack for Enhanced Retail Analytics Fivetran

Princess Polly Leverages Modern Data Stack for Enhanced Retail Analytics

Fivetran

Technology Category	Functional Applications - Inventory Management Systems
Applicable Industries	E-Commerce Retail
Applicable Functions	Procurement Warehouse & Inventory Management
Use Cases	Picking, Sorting & Positioning Time Sensitive Networking
Services	System Integration
Challenge	Princess Polly, an Australian fashion boutique, was facing challenges in utilizing data effectively during a time of uncertainty. The company was preparing for a critical launch into the U.S. market and needed to support internal departments in making informed decisions. Anand Bhatt, the Head of Business Analytics, was tasked with building an analytics infrastructure that could demonstrate value quickly and efficiently. As the sole member of his team, Anand needed to maximize his time generating value for the business and minimize manual, time-consuming tasks. A key area of focus was cash flow analysis, with the aim of understanding which decisions were impacting the business’ bottom line to make more effective decisions. Read More
About Customer	Princess Polly is an Australian fashion boutique that was founded in 2010. The company started in a beachside apartment on the Gold Coast of Australia and has since grown to a team of over 200, based both in the Gold Coast and Los Angeles. The company is a 100% ecommerce site and recently launched in the U.S. market. Anand Bhatt joined the fashion startup in May 2020 as Head of Business Analytics, shortly after the company’s U.S. launch. His role was to up-level how data was being used in the company, especially during a time of uncertainty. Read More
Solution	Anand decided to use Fivetran, a tool he had experience with, to build the analytics infrastructure. He required a well-established Shopify connector that could support both the company’s Australian and U.S. Shopify accounts and join the data from both accounts for analysis. He also needed a connector to pipe data from their PR system into their data warehouse, with Klaviyo support to import all NPS scores into their system. An AWS Lambda function was created for their Inventory Planner, Returns data pool, using the Fivetran connector for ingestion. After a two-week trial, Anand was able to connect the Shopify APIs into Fivetran, run successful tests, and begin a historical data sync. He also onboarded Mode Analytics to give the team access to the datasets that were beginning to populate. Read More Log in to view content
Contents

Technology Category

Functional Applications - Inventory Management Systems

Applicable Industries

E-Commerce

Retail

Applicable Functions

Procurement

Warehouse & Inventory Management

Use Cases

Picking, Sorting & Positioning

Time Sensitive Networking

Services

System Integration

Challenge

Princess Polly, an Australian fashion boutique, was facing challenges in utilizing data effectively during a time of uncertainty. The company was preparing for a critical launch into the U.S. market and needed to support internal departments in making informed decisions. Anand Bhatt, the Head of Business Analytics, was tasked with building an analytics infrastructure that could demonstrate value quickly and efficiently. As the sole member of his team, Anand needed to maximize his time generating value for the business and minimize manual, time-consuming tasks. A key area of focus was cash flow analysis, with the aim of understanding which decisions were impacting the business’ bottom line to make more effective decisions.

About Customer

Princess Polly is an Australian fashion boutique that was founded in 2010. The company started in a beachside apartment on the Gold Coast of Australia and has since grown to a team of over 200, based both in the Gold Coast and Los Angeles. The company is a 100% ecommerce site and recently launched in the U.S. market. Anand Bhatt joined the fashion startup in May 2020 as Head of Business Analytics, shortly after the company’s U.S. launch. His role was to up-level how data was being used in the company, especially during a time of uncertainty.

Solution

Anand decided to use Fivetran, a tool he had experience with, to build the analytics infrastructure. He required a well-established Shopify connector that could support both the company’s Australian and U.S. Shopify accounts and join the data from both accounts for analysis. He also needed a connector to pipe data from their PR system into their data warehouse, with Klaviyo support to import all NPS scores into their system. An AWS Lambda function was created for their Inventory Planner, Returns data pool, using the Fivetran connector for ingestion. After a two-week trial, Anand was able to connect the Shopify APIs into Fivetran, run successful tests, and begin a historical data sync. He also onboarded Mode Analytics to give the team access to the datasets that were beginning to populate.

Impact #1	The implementation of Fivetran and the modern data stack transformed Princess Polly's operations. The business moved from operating with siloed data to being able to ask deeper, more meaningful questions about business drivers and gather actionable insights. The impact was felt across the business, from the Finance department to the PR, Marketing, Sourcing and Merchandising teams. New dashboards and weekly reports allowed the entire business to understand their revenue, number of new customers, and the efficacy of marketing campaigns and conversion rates over time. The ability to join transaction data to inventory data enabled analysts to discover new sourcing themes and track success. The PR team could track the inventory impact of collaborations with influencers, and the Finance department could understand how the company was performing on a daily basis.

Impact #1

The implementation of Fivetran and the modern data stack transformed Princess Polly's operations. The business moved from operating with siloed data to being able to ask deeper, more meaningful questions about business drivers and gather actionable insights. The impact was felt across the business, from the Finance department to the PR, Marketing, Sourcing and Merchandising teams. New dashboards and weekly reports allowed the entire business to understand their revenue, number of new customers, and the efficacy of marketing campaigns and conversion rates over time. The ability to join transaction data to inventory data enabled analysts to discover new sourcing themes and track success. The PR team could track the inventory impact of collaborations with influencers, and the Finance department could understand how the company was performing on a daily basis.

Benefit #1	Onboarding Fivetran saved the equivalent of hiring one full-time data engineer
Benefit #2	Princess Polly saved six months of vital setup time, enabling immediate business impact at the beginning of the pandemic
Benefit #3	Centralized insights allowed the ecommerce site to allocate the right resources at the right time, growing the business

Benefit #1

Onboarding Fivetran saved the equivalent of hiring one full-time data engineer

Benefit #2

Princess Polly saved six months of vital setup time, enabling immediate business impact at the beginning of the pandemic

Benefit #3

Centralized insights allowed the ecommerce site to allocate the right resources at the right time, growing the business

Download PDF Version

Overview

Princess Polly Leverages Modern Data Stack for Enhanced Retail Analytics

Operational Impact

Quantitative Benefit