About the client:
The client is one of the world’s largest alcoholic beverages manufacturer with a portfolio of more than 200 brands and labels and employs more than 7,000 people across 170 countries.
Challenges:
- Complex data management: Consolidating and managing data with varying rules applicable across 29 Indian states.
- Data analytics: Lack of a centralized sales repository hampered business performance review.
- Delayed reporting: Manual business reporting and analysis resulted in delays and non-intuitive reporting.
- Governance: Lack of data governance and security protocols resulted in inconsistent data.
- Manual efforts: New KPI or data source addition required manual intervention by the MIS team.
Solution:
- Data-driven workflows: Created and scheduled data-driven workflows that process data from different sources.
- Data sharing: Shared primary sales report with stakeholders.
- Automation implementation: Scheduled scraping jobs for various government portals to extract, massage, and store the Secondary Sales data with unique transaction source.
- Data consolidation: Extracted data from diverse distributors’ system.
- Data processing: Data is further processed and then displayed in Secondary Closing/Depletion reports.
Benefits:
- Improved data analysis: Simplified sales performance analysis multiple portals and diverse systems.
- Enhanced stock mapping: Identification of unmapped retailer & SKUs.
- Improved data accuracy: Consistent and accurate sales reports for analysis.
