CCBPI Accelerates Business and Drives Performance with Sales Capability Tool
Customer Company Size
Large Corporate
Region
- Asia
Country
- Philippines
Product
- Azure
- Azure Data Lake
- Azure Databricks
- Azure Synapse Analytics
- Power BI
Tech Stack
- Azure
- Azure Data Lake
- Azure Databricks
- Azure Synapse Analytics
- Power BI
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Cost Savings
- Digital Expertise
- Productivity Improvements
Technology Category
- Analytics & Modeling - Big Data Analytics
- Analytics & Modeling - Predictive Analytics
- Platform as a Service (PaaS) - Data Management Platforms
Applicable Industries
- Consumer Goods
Applicable Functions
- Business Operation
- Sales & Marketing
Services
- Cloud Planning, Design & Implementation Services
- Data Science Services
- System Integration
About The Customer
Coca-Cola Beverages Philippines (CCBPI) is a major manufacturer and distributor of soft drinks and other consumer beverages in the Philippines. As a large corporate entity with over 10,000 employees, CCBPI operates in the consumer goods industry, focusing on delivering high-quality beverages to its customers. The company recognized the importance of leveraging data to drive efficiency and reduce costs, prompting them to seek a solution that would enhance their data management and reporting capabilities. By partnering with Lingaro, CCBPI aimed to overcome its data challenges and accelerate its business operations through improved data insights and automation.
The Challenge
CCBPI recognized the need to integrate and automate its data processes to enhance operational efficiency and maintain data transparency. Previously, Power BI reports were generated using data from manually edited Microsoft Excel files, which involved multiple users and steps prone to human error. The leadership team, led by CIO Winnie Talosig-Rebancos, identified the automation of report creation as a critical component of their digital transformation strategy.
The Solution
Lingaro delivered a comprehensive data and analytics solution for CCBPI, centered around the deployment of a new Azure-based Sales Capability tool. This solution involved structuring data from various CCBPI systems and consolidating it into secure SFTP storage. Azure Synapse Analytics was utilized as the database, while Azure Data Lake and Azure Databricks ensured proper data flow and processing. The solution also included the development of new dashboards that provided actionable insights and supported in-depth market data analysis. The Power BI reports, featuring over 52 tabs, enabled precise and consistent KPI presentation, aligning with global standards.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
.png)
Case Study
Improving Vending Machine Profitability with the Internet of Things (IoT)
The vending industry is undergoing a sea change, taking advantage of new technologies to go beyond just delivering snacks to creating a new retail location. Intelligent vending machines can be found in many public locations as well as company facilities, selling different types of goods and services, including even computer accessories, gold bars, tickets, and office supplies. With increasing sophistication, they may also provide time- and location-based data pertaining to sales, inventory, and customer preferences. But at the end of the day, vending machine operators know greater profitability is driven by higher sales and lower operating costs.
Case Study
Series Production with Lot-size-1 Flexibility
Nobilia manufactures customized fitted kitchens with a lot size of 1. They require maximum transparency of tracking design data and individual processing steps so that they can locate a particular piece of kitchen furniture in the sequence of processes.
Case Study
American Eagle Achieves LEED with GE LED Lighting Fixtures
American Eagle Outfitters (AEO) was in the process of building a new distribution center. The AEO facility management team decided to look at alternate options for lighting layout that could provide energy and maintenance savings. AEO would need a full-time maintenance employee just to replace burned-out fluorescent tubes.
Case Study
Revolutionizing Rodent Control
From pet- and child-safe traps, to touch-free and live-catch rodent control solutions, Victor continues to stay committed to producing superior products that meet the varying needs of today’s pest control professionals. And, with a long standing history supporting customers in the food processing, service, and retail settings, Victor knew that strict regulations were costing organizations thousands of dollars in excess overhead trying to manage their rodent-control solutions. Trap inspections in these environments are often difficult and time consuming, requiring personnel to manually check a trap’s status multiple times per day, amounting to over six hours of manual labor. Victor is looking for an innovative way to increase operational efficiencies with the use of technology.
