The client is a portfolio of global consumer brands and creates unique retail experiences with an eye toward creativity and a singular focus on pleasing customers.
The Challenge
The client is a leading lifestyle products and services company continually striving to connect with its customers through unique products and engaging store designs. Its brand identity closely mirrors its customers, based on a deep understanding of the clientele and the ability to pivot according to shifts in customer preferences. This required keeping a constant tab on customer behavior and purchase decisions.
To do this effectively, the client needed help fetching a consolidated view of sales, footfalls or online traffic, and conversion rates from its 700 global brick-and-mortar stores and an online storefront. It also lacked benchmarks to assess a day’s performance against business milestones.
The client commissioned Persistent to enable real-time data analysis with a store dashboard that acts as a single source of truth for online and offline stores and offers timely insights into customer preferences, conversion rates, and fast-moving products.
The Solution
Persistent started by creating a data foundation that integrates sales data from the client’s physical and digital storefronts into a Findable, Accessible, Interoperable, and Reusable (FAIR) format that enables the Machine Learning models to generate deeper and faster insights.
We created a data pipeline with Google DataFlow that extracts, transforms, and loads the streaming into a Machine Learning algorithm. The insights are displayed on BigQuery, a Google Cloud dashboard that can be queried for granular insights with Cloud SQL.
With over 50 Google Cloud expertise designations, Persistent quickly identified the right tools to build this solution, leveraging Google Cloud’s ready-to-go, off-the shelf accelerators to deliver this project within 15 weeks.
The Outcome
With the breaking of data silos, and an automated data pipeline that sourced and integrated data from multiple sources, the client was able to:
- Glean real-time insights from over 75,000 daily sale orders.
- Benchmark sales and other performance metrics with the store dashboard.
- Improved understanding of customer preferences.
