Client is a Fortune Global 500company, leading in packaged foods and beverages. It has interests in the manufacturing, marketing, and distribution of grain-based snack foods, beverages, and other products.
Supply Chain KPI’s Reporting – AMESA & APAC
Supply Chain KPI’s Reporting – AMESA & APAC
Challenges
- Lack of Unified Platform: There’s no centralized reporting platform for monitoring performance across market teams for Demand Planning and Supply Planning KPIs.
- System Fragmentation: The use of multiple SAP Vistex AGRO instances in different regions creates a fragmented reporting environment.
- Inconsistent Data Sources: Data for reporting is scattered across different systems, making it difficult to consolidate and analyse.
Solutions
ISCP KPI Reporting – Developed a common KPI reporting platform for all ISCP DP and SP users.
Scope: Demand Planning – 16 Reports; Supply Planning – 14 reports; Executive Dashboard – 5 Dashboards
AGRO – Develop a common KPI reporting platform for Agro Digitization.
Scope: Farm Management – 4 Dashboards; Cold Store – 2 Reports / Dashboards; Executive Dashboards – 4
Results
Process automation and eliminating the manual work to reduce the manual efforts as the report generation and refresh is automated. Better business decisions and Productivity improvement using Reports/Dashboards. End user experience is improved as report rendering and performance is very fast on Power BI Service.
Technology Stack Used: Power BI for Reporting and Analysis.
SAP BW and Teradata – EDW (Enterprise Datawarehouse) for data acquisition and modelling JDA, SAP ECC, Oracle DPP databases (Databases)
