Reliable sell-out, governed point-of-sale master data, 1-3 year network planning and executive performance analytics across a synthetic multi-market beauty landscape.
A reproducible operating model connecting SAP-shaped master data, Data Entry v2, retailer feeds, SimpliField audits, GCP/BigQuery, Anaplan planning, Newviz reconciliation, Excel and Power BI.
Synthetic data only. Independent methodological case study; no affiliation with or access to any company system.
Ten headline metrics summarising scope, commercial scale, data reliability, planning quality and operating support.
Coverage uses eligible active POS. WAPE uses the March–June 2026 time-based holdout.
Raw evidence is preserved. Critical curated controls must pass before any consumer refresh.
The Excel workbook also shows a 99.62% weighted rule-level first-pass rate; record-level and rule-level rates answer different questions.
Stable natural key · surrogate version key · valid_from · valid_to · current_flag.
Synthetic values only — figures illustrate the operating model, not real company performance.
Approved plan = statistical baseline
+ network uplift
+ baseline × (market override + category mix override + central challenge)(gross local − discount local − returns local) / local-per-EUR FX
distinct reporting POS / eligible active POS
sum |forecast − actual| / sum actual
sum(forecast − actual) / sum actual
(GCP EUR − Newviz EUR) / GCP EUR
beginning POS + openings − closures
Public references inform the workflow; they do not imply certification, formal compliance, endorsement or proprietary-system access.
Synthetic data only. Independent methodological case study; no affiliation with or access to any company system.
Open the repository