Skip to content
  • What we do
  • Our approach
  • Our work
  • Insights
  • Careers
  • Connect
Menu
  • What we do
  • Our approach
  • Our work
  • Insights
  • Careers
  • Connect
Back to insights

Retail experimentation with real-time analytics

By Gary Nakanelua

The Background

In the retail clothing market, retailers often purchase clothing from a brand manufacturer with a purchase agreement that includes a buy-back clause. This clause stipulates that if the merchandise doesn’t sell, then the manufacturer must buy it back. This overstock is often then sold to off-price retailers, such as TJ Maxx, at a substantial discount. For clothing retailers that are also brand manufacturers, such as Gap, the excess inventory is heavily discounted in their brick-and-mortar locations.

The Scenario

Consider a scenario where a large clothing retailer is looking to transform its brick-and-mortar overstock tactics into a hybrid commerce strategy. An idea was proposed to offer overstock as a limited-time promotion where the price would automatically be optimized according to purchase popularity. As more people purchased an item, the transaction price would drop for everyone within the offer period. Initially, the promotion was considered an initiative to be integrated into the existing e-commerce solution. However, to mitigate the risks and costs associated with such an initiative, the decision was made to run a two-week experiment resulting in a functional proof of concept (POC) that would be used to measure the effectiveness of the idea within a single 12-hour shopping period.

Microsoft Azure was the primary cloud provider for the organization, so the architecture for the POC was based upon the Demand Forecasting and Pricing Optimization Azure solution. Azure App Service would be used for the web application and Azure Databricks would be used to build the pricing optimization model. Due to the desired speed of the experiment, data from the POC could not be integrated into the existing enterprise data warehouse within an acceptable timeframe. As a result, transactional data from the POC would be stored in Azure PostgreSQL.

The desired pricing optimization model wouldn’t simply adjust the price as more people made a purchase. Other factors, such as historical transactions, current inventory, seasonality, and purchase timing would need to be incorporated into the model, which presented an unforeseen challenge.

The Problem

Depending upon the learnings from the experiment, the organization intended to run a pilot of the initiative during the winter holiday shopping season, meaning that the POC had to be completed quickly. A small team was assembled to run the experiment and build the POC. Although the web application was completed very quickly, building the pricing optimization model proved to be far more difficult than originally expected. The immediate availability of additional resources was limited and the timeframe for the POC to go live could not be adjusted. A short-term alternative for the pricing optimization model was needed in order to keep the initiative on track and to give the data scientists additional time to complete the model for use in the pilot.

The Solution

Considering the short, 12-hour shopping period the POC would operate within, an alternative to the automatic pricing optimization model was to manually adjust the pricing of the offers based on the real-time recommendations of a group of seasoned analysts. With the proper access to purchase data and inventory counts, the analysts could provide real-time recommendations for POC product pricing. 

The analysts utilized Power BI for reporting and dashboard activities. To achieve real-time connectivity to the POC transactional data and take advantage of regional inventory data from multiple sources, Conduit, Blueprint’s lightweight data virtualization product, was incorporated into the solution. 

The Results

The analysts were able to leverage the capabilities of Conduit to build a series of dashboards, enabling pricing decisions to be made in real-time and the POC to be completed on time and ready for its initial test. Rather than investing heavily in an unproven concept, the retailer, using Azure services and Conduit, was able to experiment to validate the idea rapidly. Once the pilot is complete and moved into production, the retailer will be able to sell through overstock inventory much faster and repurpose more clearance space in its brick-and-mortar locations for seasonal displays and other purposes.

Learn More

Find out more about Conduit’s features and how you can access the data you need today.

Let's build your future.

Contact us

Share with your network

Share on twitter
Share on facebook
Share on linkedin
Share on email

You may also enjoy

Localization - How to localize your searches for an international market

How to apply smart localization approaches to online searches

While online searches are intuitive to every web user, complexities around language and cultural references make non-English searches more of a challenge.
Let's talk Conduit: Part 2

Let’s talk Conduit: Part 2

Looking for a data virtualization tool that’s light on your wallet? Conduit is the perfect solution for businesses looking to connect disparate data sources without incurring growing costs.

What we do

  • Cloud and infrastructure
  • Data migration
  • Modern data estate
  • Modern workplace
  • Data science and analytics
  • Application development
  • IoT enablement
  • Video analytics
  • Support engineering
  • Localization
Menu
  • Cloud and infrastructure
  • Data migration
  • Modern data estate
  • Modern workplace
  • Data science and analytics
  • Application development
  • IoT enablement
  • Video analytics
  • Support engineering
  • Localization

Our approach

  • Business strategy
  • Facilitated innovation
  • Managed services
  • Product development
  • Project definition workshop
  • Proof of concept
  • Solution development
Menu
  • Business strategy
  • Facilitated innovation
  • Managed services
  • Product development
  • Project definition workshop
  • Proof of concept
  • Solution development

Our work

Insights

Careers

Contact us

Nash Video Analytics
Linkedin
Youtube
Twitter
Facebook
Instagram

© 2021 Blueprint Technologies, LLC.
505 106th Avenue Northeast, Third Floor 
Bellevue, WA 98004

All rights reserved.

Privacy Policy

  • What we do
  • Our approach
  • Our work
  • Insights
  • Careers
  • Connect
Menu
  • What we do
  • Our approach
  • Our work
  • Insights
  • Careers
  • Connect
Follow
  • LinkedIn
  • Youtube
  • Twitter
  • Facebook
  • Instagram
Menu
  • LinkedIn
  • Youtube
  • Twitter
  • Facebook
  • Instagram