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.
EWD Digitized Analytics – APAC
EWD Digitized Analytics – APAC
Challenges
- Manual and Time-Consuming: The manual process is inefficient and can lead to errors due to human intervention.
- Multiple Data Sources: Relying on data from various systems (HFM, DAPLR, Oracle, Tm1, BI, Excel files) can complicate data consolidation and increase the risk of inconsistencies.
- Lack of Granular Forecasting: The absence of granular forecasting information for all markets limits the ability to make accurate predictions and strategic decisions.
- Scattered Information: Data is spread across multiple reports (Brand/Channel/Pack Size PL), making it difficult to get a comprehensive view of performance.
- Inconsistent Channel Data: Channel-level data is limited and inconsistent, hindering analysis of performance at the channel level.
Solutions
One common harmonized enterprise data warehouse platform integrating data from multiple source systems and acting as a single Source of Information. Automated
Dashboards on Power BI enabling self-service for deeper insights.
Results
Standardized and harmonized reporting, Automated dashboards, Real-time interface to source systems
Deeper Insights on channel/brand/pack size P&L up NOPBT
Ready reckoner of data for analysis
Automated KPI computations for NOPBT cause of change
Self-query and adhoc features
Export to excel and ppt
Elimination of manual effort. Productivity ~2000 hours P.A
Technology Stack: Power BI for Reporting and Analysis, Teradata – EDW (Enterprise Datawarehouse), MS Azure Blob Storage for upload of manual files
