CLIENT
Apex Consumer Group
INDUSTRY
CPG
THE CHALLENGE
Decisions were being made on data that lived in fifteen places at once
Global CPG organizations often struggle with fragmented reporting, inconsistent market coverage, limited distributor visibility, and difficulty tracking product performance across multiple regions. Leadership needed a centralized intelligence platform capable of delivering actionable insights across the entire distribution network.
OUR APPROACH
A single pipeline feeding one self-contained platform
Unify the data
A Python pipeline ingests and standardizes every regional feed into one clean, reconciled dataset.
Model what matters
Revenue, growth, market share, and distributor health modeled into clear, comparable metrics.
Build it to travel
A single-file HTML dashboard with a native SVG chart engine — zero external dependencies, so it opens anywhere, online or off.
Make it executive-ready
Light and dark themes, five linked modules, and a layout built for boardroom screens and laptops alike.
DATA FLOW
15 regional feeds
→
Python Pipeline
Clean Dataset
→
SVG Dashboard
THE PLATFORM
Five modules, one live view
Apex Consumer Group is a multinational consumer packaged goods company operating across 18 countries with 250 distributors, 2500 retail outlets, and 150 products. Leadership lacked visibility into distributor performance, market coverage, product contribution, and regional growth opportunities. RUSA Analytics developed a CPG Distributor Intelligence Platform to provide a unified view of business performance and support faster, data-driven decision-making.
THE OUTCOME
From week-long consolidation to a real-time answer
▼ from ~5 days
Minutes
Quarterly reporting that once took a week now updates the moment new data lands.
Single Source
15 → 1
Fifteen disconnected regional spreadsheets replaced by one reconciled platform.
Full Visibility
100%
Every distributor, product, and market visible in one view — no blind spots.
WALKTHROUGH
See the glimpse of the platform
A guided tour through the modules — how the data connects and how leadership uses it day to day.
TESTIMONIALS
"Testimonials are a great way to showcase positive feedback you've received. Click to edit and add yours."
Simone Woods
Simone Woods
"Testimonials are a great way to showcase positive feedback you've received. Click to edit and add yours."
Simone Woods
Simone Woods
"Testimonials are a great way to showcase positive feedback you've received. Click to edit and add yours."
Simone Woods
Simone Woods
