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

Princess Polly Leverages Modern Data Stack for Enhanced Retail Analytics

Fivetran Logo
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
About The 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.
The 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.
The 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.
Operational Impact
  • 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.
Quantitative Benefit
  • Onboarding Fivetran saved the equivalent of hiring one full-time data engineer
  • Princess Polly saved six months of vital setup time, enabling immediate business impact at the beginning of the pandemic
  • Centralized insights allowed the ecommerce site to allocate the right resources at the right time, growing the business

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.