Case Study | June 2022
MerakiPoint enabled a Paper & Pulp manufacturer to gain full supply chain visibility
MerakiPoint created a Data Foundation layer to manage business-critical supply chain KPIs across all business units and manufacturing sites. It enhanced data scalability, flexibility and governance while providing reliable generation of Advanced Analytics and Insights. The solution helped identify critical KPIs with relevant operating levers.
Background
Our client is a Manufacturer of Paper, Pulp and Compostable Tableware products. They had disparate data sources with a lack of consistent, high-quality data. Hence, the client wanted to enable end-to-end visibility across the supply chain, covering pillars such as Plan, Source, Make, and Deliver. They were also looking for dynamic dashboarding and reporting capabilities to make the process faster and smarter.
Key Challenges
Manual MIS & Reporting: No automation of MIS or reporting. SAP data was manually worked in large excel sheets and person dependent.
​
Non-Consistent Metrics: Different business units operated with their own definition and calculation of metrics.
​
Data quality issues: Lack of Data Governance led to inconsistencies and poor data quality, with reliance on manual data extraction.
Our Solution
MerakiPoint developed a Data Foundation layer to ensure the monitoring and reporting of key supply chain metrics.
The team conducted Empathy Sessions to understand key personas and existing KPI definitions/calculations. Design Thinking Workshops followed it to prioritize KPIs based on business value and implementation complexity.
The team also performed Data Engineering and held business SMEs-specific sessions to understand data definitions, source identification, and source-to-target mapping. Initial wireframing was developed before creating the prototype and incorporating end-user feedback.
The team took on Dashboard and Report Automation by translating wireframes into the design.
Tech Stack
\ Azure \ SAP \ Power BI
Value Delivered
Automated End-to-End MIS and Reporting reduced monthly P&L generation by 10 days.
​
User Persona specific Power BI dashboards created reflecting the KPI’s user is responsible for.
Contextual insights were provided, enabling a deeper understanding of the factors contributing to enhancing customer service and plant efficiency