Business Challenges
- Develop an Analytics Platform that caters to BU requirements across the globe
- Different BUs are at different levels of standardization and need a standards-based approach for faster adoption
- Merge bottler information with internal details, develop insights about consumers and customers to generate value for both the corporation and the bottlers
- Enable a subscription-based model to reduce the TCO for each unit
Solution Delivered
- Product based approach to drive standardization
- Tool kit to assess and onboard new bottlers across the globe
- Fine grained security to ensure right access for the right user
- Agile based development with 2-week sprints
- Integration of bottler data with internal data
- Azure cloud-based solution to support flexible subscriptions
- Big Data based data lake to support scalability
- Cosmos DB and Azure SQL to support geo-distribution
- Informatica BDE based standardized data processing
- AAS – Power BI based fine grained metrics to enable self-service
- Java based data steward application.
Benefits Delivered
- Rapid development of the product in 90 days
- 90-day plan for onboarding all bottlers
- Cloud based subscription option
- Option for bottlers to provide data in standard form or bottler specific form
- A platform that can provide consumer and customer insights by integrating revenue and volume information.