Refreshing Success: How Coca-Cola Andina Sparked Growth with AWS and Data Magic

About Coca-Cola Andina

Coca Cola Andina is a Chilean company with more than 17,500 employees, licensed to produce and market The Coca-Cola Company’s products in parts of Argentina, Brazil, and Chile and all of Paraguay. It is one of the leading bottlers in Latin America and one of the seven largest Coca-Cola bottlers in the world.

Overview

Coca-Cola Andina aims to foster the profitable growth of its business and enhance the experience for over 54 million consumers across Chile, Argentina, Brazil, and Paraguay. To achieve this, the company focuses on developing top-notch processes to improve productivity and service quality. A key initiative in this direction was the creation of a data lake on Amazon Web Services (AWS). By leveraging AWS’s storage, databases, computing, and analytical capabilities, Coca-Cola Andina significantly boosted its analytics team’s productivity by 80 percent. This not only empowered the company and its customers to make informed decisions based on reliable data but also contributed to the overall growth of the ecosystem. The move helped Coca-Cola Andina maintain a competitive edge and ultimately led to increased revenue for the company.

Opportunity

• Coca-Cola Andina operates in South America, distributing Coca-Cola Company’s products in parts of Chile, Argentina, Brazil, and the entire Paraguay.
• The company has 17,500 employees, serves 267,000 customers, and refreshes 54 million consumers.
• Focus on a vision beyond profitability, aiming for benefits to reach all of society through innovation and new capabilities like data lakes and analytics.
• Miguel Angel Peirano, EVP of Coca-Cola Andina, emphasizes sustainable growth for customers, consumers, and communities.
• Luis Valderrama, regional CTO, highlights the importance of customers as partners in the distribution and sales chain.
• Challenges in CPG industry data management due to massive volumes stored in different systems.
• Coca-Cola Andina uses SAP for transactional data, RPA systems, B2B solutions, CRM, smartphone apps, and other methods for personalized consumer interaction.

Opportunity for Coca-Cola Andina:

• Leveraging data lakes and analytics for more efficient analysis of the massive volumes of data generated in the CPG industry.
• Integration of systems to create a unified data ecosystem, enabling better insights and decision-making.
• Enhancing customer relationships and services through personalized and social experiences.
• Sustainable growth by aligning with the vision of benefiting society and leveraging innovation in data management.

Why AWS?

• Coca-Cola Andina sought an accessible architecture with reliable data and unlimited storage, response, and processing capacity.
• The goal was to integrate the traditional and digital worlds and incorporate cognitive technologies (artificial vision, machine learning, etc.) into the business.
• Amazon Web Services (AWS) was chosen as the provider for technology and architecture for the data lake.
• AWS was selected for its ability to meet all expectations for the data lake, offering a cloud solution with the necessary capabilities.
• The architecture required a Platform as a Service (PaaS) for quick and economical development and dismantling of solutions.
• Luis Valderrama expressed satisfaction with the decision, citing the company’s culture of learning by doing as a contributing factor.

Coca-Cola Andina chose Amazon Web Services (AWS) because it provided the accessible and robust architecture they needed to seamlessly integrate their traditional and digital operations. AWS’s capabilities were aligned with their goals of incorporating advanced technologies into their business. The decision was also influenced by AWS’s cloud solutions, including the necessary PaaS for agile and cost-effective solution development, a fit that resonated well with the company’s culture of learning by doing.

Solution | Architecture & Services

• The data lake serves as a unified source for SAP ERP, CSV files, and legacy databases at Coca-Cola Andina.
• Technical architecture covers data entry, analytics, and machine learning from data lake implementation.
• Amazon Simple Storage Service (Amazon S3) securely stores raw data for analytics and machine learning applications.
• Consumer layer utilizes Amazon QuickSight and Amazon Athena, while cognitive technologies like Amazon Personalize and Amazon SageMaker are used for machine learning.
• AWS Lambda for serverless compute, Amazon DynamoDB as a key-value and document database, and Amazon Redshift for data warehousing when needed.
• The architecture aligns with the Platform as a Service (PaaS) approach.
• AWS Professional Services team supported Coca-Cola Andina in implementing data lake and analytics knowledge in 2020.
• Resulted in a “data-driven decision” company, focusing on improving consumer and customer experiences, and enhancing productivity and efficiency in processes.
• As part of the digital strategy, Coca-Cola Andina extended cloud infrastructure on AWS beyond the data lake, developing additional digital products and solutions for various strategic verticals.

Coca-Cola Andina addressed its data management challenges by implementing a comprehensive solution on AWS. The data lake, powered by services like Amazon S3, Amazon QuickSight, and Amazon Athena, became the central hub for various data sources. This allowed the company to seamlessly integrate SAP ERP, CSV files, and legacy databases while leveraging AWS cognitive technologies for machine learning. The PaaS architecture, supported by AWS Professional Services, transformed Coca-Cola Andina into a “data-driven decision” company, emphasizing improved consumer and customer experiences and increased operational efficiency. Beyond the data lake, the company expanded its digital capabilities on AWS, developing products and solutions aligned with its overall digital strategy.

AWS Services Used

• Amazon Athena: It’s like a smart assistant for data. You can ask it questions in regular language, and it quickly looks through the data stored in Amazon S3 to give you answers, all without needing to manage any servers. You only pay for the queries you run.

• Amazon Lambda: Think of it as a magical helper that runs your computer code without needing you to worry about servers. You don’t have to set up servers or manage complicated stuff; it just takes care of executing your code whenever needed.

• Amazon SageMaker: This is your all-in-one toolkit for creating and using smart computer models. It helps scientists and developers easily build and deploy high-quality machine learning models without a lot of hassle.

• Amazon Professional Services: It’s like having a team of experts at your fingertips. These pros from Amazon can help you figure out how to use their cloud services to achieve the specific goals you have for your business. They’re like your guides to get the best results from AWS.

Conclusion

In conclusion, Coca-Cola Andina’s journey towards fostering profitable growth and enhancing consumer experiences exemplifies the transformative power of data and technology. By embracing Amazon Web Services (AWS) and developing a robust data lake architecture, the company not only streamlined its data management but also witnessed an impressive 80 percent boost in analytics team productivity.

The strategic use of AWS services like Amazon Athena, Lambda, and SageMaker allowed Coca-Cola Andina to seamlessly integrate various data sources, enabling informed decision-making based on reliable information. The company’s commitment to a “data-driven decision” approach has not only improved customer and consumer experiences but also contributed to overall productivity and efficiency gains.

The successful collaboration with AWS Professional Services underlines the importance of expertise in implementing advanced cloud solutions, ensuring that Coca-Cola Andina maximized the benefits of its data lake and analytics initiatives.

Moreover, the expansion of Coca-Cola Andina’s digital capabilities beyond the data lake, encompassing additional AWS services, demonstrates a holistic approach to digital transformation. This not only reinforces the company’s competitive advantage but also aligns with its broader vision of sustainable growth, benefiting society through innovation and data management excellence.

Ultimately, Coca-Cola Andina’s story highlights the pivotal role that technology and a strategic partnership with AWS can play in driving business success, enhancing customer relationships, and fostering a culture of continuous learning and innovation.