Unified Retail Analytics Platform — UK & France
Medallion architecture on Databricks + Power BI consolidating 12+ retail and internal data sources into a single platform delivering real-time pricing intelligence, market share tracking, and commercial performance across two markets.
1The Challenge
The UK and France commercial teams were manually consolidating data every week from Tesco, ASDA, Carrefour, Leclerc, Nielsen, IRI, and SAP — all in separate spreadsheets with different product hierarchies, currencies, and update cycles. This fragmentation delayed pricing decisions by weeks and made promotional analysis nearly impossible in real time.
The SKU mismatch problem was particularly acute — the same product was named differently across every retailer system. Without a master product map, cross-retailer comparison was impossible. The goal was a single governed platform spanning both markets where pricing, share, and commercial decisions could be made in days, not weeks.
2The Solution
Bivonix designed a full medallion architecture on Databricks — Bronze ingestion, Silver cleansing, Gold business-ready datasets — then delivered five Power BI dashboards covering every commercial decision layer:
- Fuzzy SKU matching engine aligning retailer product hierarchies across UK and France
- Azure Data Factory orchestration with pricing feeds refreshing every 4 hours
- Master Product Mapping Table validated through manual and automated workflows
- Price elasticity DAX measure and simulation dashboard
- Market share velocity metric with trend tracking vs. named competitors
- Retailer × category performance heat matrix with country filter
- RLS enforced per market — UK teams, France teams, regional directors
- Dashboard load time optimised from 45s to under 8s via aggregation tables
3What This Dashboard Solves
4Business Impact
- Pricing decision cycle reduced from 3 weeks to 3 days — immediate competitive advantage
- E-commerce sales lifted 17% through better channel-level visibility and faster reaction
- Total sales growth of 24.7% across UK and France for FY 2024
- Dashboard load time reduced from 45 seconds to under 8 seconds
- 12+ data sources unified into a single governed medallion platform
- Promotional lift tracking enabled before, during, and after each campaign
- Became the global BI template scaled to other Danone regions worldwide
Technology Stack
Live interactive dashboard — switch tabs, filter retailers by country, explore pricing and market share
Databricks Medallion · Power BI RLS3 days
Pricing Decision Cycle
+24.7%
Total Sales Growth FY 2024
+17%
E-Commerce Sales Lift
12+
Data Sources Unified
Operational Intelligence Capabilities
Eight integrated capabilities giving commercial, pricing, and finance teams complete real-time visibility across two markets and 12+ data sources.
Commercial Overview
5 KPI banners, dual-market revenue trend, category mix donut, promotional campaign lift, SKU performance snapshot, and quarterly growth bars.
Pricing Intelligence
Monthly price index by category, competitive price gap analysis vs. private label and named brands, price elasticity simulation, and DAX elasticity measure.
Retailer Performance
Revenue ranking with UK/France filter, e-commerce vs. in-store split, distribution coverage radar, and retailer × category performance heat matrix.
Market Share
Yogurt market share trend for UK and France, competitive share breakdown, market share velocity DAX measure, and category radar UK vs. France.
Architecture & Stack
Medallion pipeline diagram (Bronze → Silver → Gold → Power BI), refresh schedule, business impact scorecard, and data source reliability chart.
Medallion Architecture
Bronze raw ingestion → Silver cleansed layer → Gold business-ready datasets with pricing models, share velocity, and incremental refresh policies.
Fuzzy SKU Matching
Python + Spark fuzzy matching engine aligning UK and French retailer product hierarchies — e.g., 'Yogurt Strawberry 150g' vs 'Yaourt Fraise 150g'.
Role-Level Security
UK teams see UK data only, French teams see France data, regional directors get cross-country access — GDPR-compliant RLS enforced via Power BI.
Key Features
Need a similar retail analytics platform?
Book a free discovery call. We'll audit your current data landscape and show you exactly what's possible.