Skip links

AI-Driven Pricing and Analytics for Global
Online Retail Firm

90,000+ items
offered online across
categories

500+
employees across North
America

50B
transaction rows migrated

Business Case

Leadership wanted quicker insight and a single source of truth. Here were some of the existing issues

Data silos

Sales, stock, and promo files lived in separate systems—making every report a hunt.

Long waits

Teams queued nightly SaS jobs and still relied on third-party extracts for ad-hoc questions.

Pricing blind spots

No clear view of how discounts pushed or hurt demand and margin.

Impact Delivered

80% faster
dashboard
creation

Hourly loads replace overnight
batches

90% fewer manual
data pulls

One Snowflake view ends ad-hoc
extracts

15% uplift promo-margin accuracy

Pricing guided by elasticity signals

Our Solution

We built a cloud warehouse and price-elasticity engine in 100 days that consisted of the following components:

Cloud warehouse

Python and Airflow landed 50 billion SaS rows in Snowflake, ready for near-real-time queries. 

Unified reporting

Tableau pulls Hyperion data directly, aligning reports across departments. 

Price elasticity modelling

Python models test price moves and highlight margin risk before campaigns launch. 

Reusable ingestion framework

New data sets plug in fast; no rewrite needed. 

Tech Stack

Snowflake

Hyperion

Python

Tableau

Airflow

SaS