Unified Retail Analytics Platform — UK & France
Pricing Intelligence · Market Share · Commercial Performance · Powered by Bivonix
Medallion Architecture
Databricks · Power BI
Data Pipeline Active
Commercial Overview
Pricing Intelligence
Retailer Performance
Market Share
Architecture & Stack
Commercial KPIs — UK & France Combined · FY 2024
Revenue Trend by Country — Monthly €M · Jan–Dec 2024
UK (€M) France (€M) Combined target
3 days
Pricing decision time
▼ from 3 weeks before Bivonix
12+
Sources unified
Tesco, Carrefour, Nielsen, SAP…
Category Performance Mix
Yogurt 38%
Water 22%
Dairy 19%
Plant 14%
Early Life 7%
Promo Effectiveness by Campaign Lift % · 2024
Summer Yogurt Push
+31%
Back-to-School Water
+24%
Activia Spring
+21%
Plant-Based Launch
+18%
Volvic Winter FR
+12%
Q4 Festive Dairy
+9%
SKU Performance Snapshot
Activia UK
+22%
growth
Volvic FR
+18%
growth
Alpro Plant
+34%
growth
Aptamil UK
+11%
growth
Danio FR
88%
distrib.
Oykos UK
94%
coverage
Actimel FR
€2.49
VWAP
Evian FR
-2%
margin
Growth by Quarter
UK France
Pricing Intelligence — Competitive Landscape & Elasticity
VWAP Yogurt UK
£2.18
▲ +£0.08 vs Jan
Price Gap vs Private Label
+14%
— managed premium
Avg Price Elasticity
-1.4
Elastic — price sensitive
Pricing Refresh Time
3 days
▼ from 3 weeks
Price Trend by Category — Monthly Indexed to Jan = 100
Yogurt Water Plant-based Dairy
Competitive Price Gap — Yogurt UK £/unit shelf price
Danone
£2.18—
Chobani
£2.39+9.6%
Müller
£2.05-5.9%
Yeo Valley
£2.55+17%
Private Label
£1.89-13.3%
Price Elasticity by Category
Bottled Water-2.1
Elastic
Yogurt Premium-1.6
Elastic
Plant-Based-0.9
Neutral
Early Life Nut.-0.4
Inelastic
Medical Dairy-0.2
Inelastic
Price Elasticity DAX Measure
-- Volume change / Price change ratio Price_Elasticity = DIVIDE( CALCULATE( SUM(Sales[Volume_Change]), Sales[Price_Change] <> 0 ), CALCULATE( SUM(Sales[Price_Change]), Sales[Price_Change] <> 0 ) )
Elasticity Simulation — Yogurt Price Scenarios
Price change % → projected volume impact %
Retailer Intelligence — UK & France Top Accounts
All Markets
🇬🇧 UK
🇫🇷 France
Retailer Revenue Ranking YTD contribution
🇬🇧Tesco
£42.1M+18%
🇫🇷Carrefour
€38.6M+22%
🇬🇧ASDA
£34.8M+14%
🇫🇷Leclerc
€32.4M+27%
🇬🇧Sainsbury's
£30.2M+11%
🇫🇷Intermarché
€27.1M+19%
🇬🇧Morrisons
£23.4M-3%
🇫🇷Auchan
€19.8M+1%
E-commerce vs In-Store Split
In-store E-commerce
Distribution Coverage by Retailer
Retailer × Category Performance Matrix Revenue index — darker = stronger
Market Share Intelligence — FMCG Competitive Position
UK Yogurt Share
28.4%
▲ +3.2pts YoY
FR Yogurt Share
31.7%
▲ +2.8pts YoY
UK Water Share
19.2%
▲ +1.1pts YoY
FR Plant-Based
22.6%
▲ +4.9pts YoY
Market Share Trend — Yogurt Category UK + France · 2024
Danone UK Danone FR
Competitive Share — UK Yogurt
Danone
28%
28.4%+3.2
Müller
22%
22.0%-1.4
Yeo Valley
14%
14.0%+0.8
Chobani
11%
11.0%+1.2
Private Label
16%
16.0%-2.1
Market Share Velocity DAX
Market_Share_Velocity = DIVIDE( [Current_Market_Share] - [Previous_Market_Share], [Previous_Market_Share] )
Share by Category — UK vs France Radar
Data Architecture — Medallion Pipeline & Tech Stack
Medallion Architecture — Bivonix Implementation for FMCG Retail Client UK & France
Sources
Tesco / ASDA
POS data UK
Carrefour / Leclerc
FR retail
Nielsen / IRI
market data
SAP / Navision
ERP financial
SFA Systems
field sales
↓ Azure Data Factory — Orchestration · Scheduling · Error Handling ↓
Bronze Layer
Raw Ingestion
No transforms
Schema Validation
Data contracts
SKU Fuzzy Match
Python / Spark
Audit Trail
Full lineage
↓ Databricks + Apache Spark — Transformation · Enrichment · Aggregation ↓
Silver → Gold
Silver Layer
Cleansed data
Gold Layer
Business-ready
Pricing Model
Elasticity calc
Share Velocity
DAX measures
Incremental Refresh
Daily + real-time
↓ Power BI Semantic Model — Import Mode + DirectQuery Hybrid ↓
Outputs
Exec Dashboard
Full RLS
Pricing Intel
Category mgr
Retail Perf
KAM filtered
Self-Service
Power BI app
Global Template
Scalable globally
Databricks Azure Data Factory Power BI Apache Spark Python SQL Power Query DAX Medallion Architecture Row-Level Security Fuzzy SKU Matching
Pipeline Refresh Schedule
Retailer POS dataDaily 06:00
Nielsen market shareWeekly Mon
SAP financialsMonthly
Pricing feedsEvery 4 hours
SFA field dataIntraday
Promo resultsPost-campaign
Business Impact Scorecard
Decision time
3 days
▼ from 3 weeks
Sources unified
12+
All integrated
Sales growth
+24.7%
FY 2024
Ecomm growth
+17%
Digital shift
Global template
Yes
Scaled globally
Gross margin
38%
+2.1pts
Data Source Reliability