Cross-Functional KPI Dashboard Suite for FMCG
BUSINESS PROBLEM
- A leading FMCG company with high transaction volumes and wide retail reach struggled to track daily performance across channels. Disconnected data made it hard to monitor sales, inventory, and market trends in real time.
- The lack of unified insights hindered quick decision-making and operational agility, highlighting the need for a centralized, data-driven solution to stay competitive.
SOLUTION
- Built a business-aligned data foundation using Medallion, Data Mesh, and Lakehouse principles on Microsoft Fabric.
- Enabled structured ingestion and governed analytics via Bronze–Silver–Gold layers.
- Integrated SAP, Field Assist, and email-based logic into high-frequency Python pipelines with semantic models and automated recovery for resilient operations.
- Delivered scalable Power BI dashboards with real-time insights, drill-through navigation, stakeholder-driven prototyping cycles, and versioned development—enabling end-to-end KPI visibility across sales, secondary metrics, and performance dimensions.
Dashboard Image
* Disclaimer – Actual dashboards has not been shared; numbers has been simulated.
CHALLENGES
Data was dispersed across SAP, Field Assist, Excel sheets, and manual uploads—leading to inconsistencies, delayed updates, and disconnected reporting.
Without a consolidated view, business teams struggled to align on performance, respond quickly to demand shifts, and scale operations with confidence.
PERFORMANCE
- Built a trusted data foundation to strengthen channel strategies, trade execution, and supply chain responsiveness
- Achieved next-day visibility into sales and inventory across geographies and product categories
- Minimized manual effort through automated pipelines—streamlining daily reporting workflows
- Delivered a unified view of time-based metrics and key commercial indicators.
- Enabled real-time, daily-refreshed dashboards—driving alignment across commercial and operations teams
