Unified Analytics for Global Confectionery Company
The Pain
A global confectionery company with operations across multiple countries struggled with scattered data sources, manual harmonization processes, and inconsistent dashboard designs. Sell-in, sell-out, and SISO data lived in disconnected systems, and business teams spent excessive time manually mapping data. Country-specific dashboard customizations made it impossible to maintain global reporting standards [citation:4].
The Intervention
I led the development of a centralized data lake and standardized Power BI dashboards for Revenue Growth Management and Business Performance Management. The solution included SISO mapping, data squaring logic, and a star schema semantic model. I conducted workshops with global and local stakeholders to align KPIs, created standardized validation workflows, and implemented role-based access controls [citation:4].
The Profit
The client gained a single source of truth with harmonized data across all markets. Standardized dashboards reduced manual effort and improved time-to-insights by over 50%. The scalable framework now supports future expansion to additional countries and use cases, with clear documentation ensuring smooth handover to internal teams [citation:4].