下载PDF
Optimizing Coca-Cola's Vending Machine Sales with CARTO & Google BigQuery
技术
- 分析与建模 - 机器学习
- 平台即服务 (PaaS) - 应用开发平台
适用行业
- 设备与机械
适用功能
- 维护
- 销售与市场营销
服务
- 云规划/设计/实施服务
- 系统集成
挑战
Coca-Cola Bottlers Japan Inc. (CCBJI) 是亚洲最大的可口可乐装瓶公司，在日本运营着一个由超过 700,000 台自动售货机组成的网络。该公司收集了大量有关每台机器的整体销售业绩以及每台机器和地点的单个产品的表现的数据。历史上，CCBJI 必须从核心系统中提取分析所需的数据，建立自己的机制，使用 ETL 工具创建数据仓库，并执行各种分析。所产生的数据规模之大给该公司带来了多项挑战。其中包括返回简单查询结果所需的时间长度以及此类遗留系统的复杂维护。
关于客户
Coca-Cola Bottlers Japan Inc. (CCBJI) 是亚洲最大的可口可乐装瓶公司，也是全球 250 多家可口可乐装瓶商中的领先企业。该公司在日本生产和供应约 90% 的可口可乐系统产品，以满足全国各地客户和消费者的需求。 CCBJI 在日本拥有超过 700,000 台自动售货机网络，收集了大量有关每台机器的整体销售业绩以及每台机器和地点的单个产品表现的数据。
解决方案
为了克服这些挑战，CCBJI 构建了一个分析和机器学习平台，作为以 Google Cloud BigQuery 为中心的现有系统之上的一层，并使用 CARTO 可视化结果。这个新平台使他们能够使用不同类型的数据，例如兴趣点 (POI) 和人流量数据来了解网络中的差距和机会。他们还能够按地点预测绩效，为销售、营销和运营方面的主要利益相关者提供见解。 CARTO 的完全云原生平台使 CCBJI 能够在 BigQuery 中原生处理其空间数据。 Spatial Extension for BigQuery 使他们能够消除以前在旧 GIS 系统中遇到的 ETL 复杂性和可扩展性限制。 CCBJI 的数据科学团队现在可以通过 CARTO 的数据观测站搜索、可视化和订阅数千个相关位置数据集，并在 BigQuery 中轻松访问这些数据流。
运营影响
数量效益
相关案例.
Case Study
Smart Water Filtration Systems
Before working with Ayla Networks, Ozner was already using cloud connectivity to identify and solve water-filtration system malfunctions as well as to monitor filter cartridges for replacements.But, in June 2015, Ozner executives talked with Ayla about how the company might further improve its water systems with IoT technology. They liked what they heard from Ayla, but the executives needed to be sure that Ayla’s Agile IoT Platform provided the security and reliability Ozner required.
Case Study
IoT enabled Fleet Management with MindSphere
In view of growing competition, Gämmerler had a strong need to remain competitive via process optimization, reliability and gentle handling of printed products, even at highest press speeds. In addition, a digitalization initiative also included developing a key differentiation via data-driven services offers.
Case Study
Predictive Maintenance for Industrial Chillers
For global leaders in the industrial chiller manufacturing, reliability of the entire production process is of the utmost importance. Chillers are refrigeration systems that produce ice water to provide cooling for a process or industrial application. One of those leaders sought a way to respond to asset performance issues, even before they occur. The intelligence to guarantee maximum reliability of cooling devices is embedded (pre-alarming). A pre-alarming phase means that the cooling device still works, but symptoms may appear, telling manufacturers that a failure is likely to occur in the near future. Chillers who are not internet connected at that moment, provide little insight in this pre-alarming phase.
Case Study
Premium Appliance Producer Innovates with Internet of Everything
Sub-Zero faced the largest product launch in the company’s history:It wanted to launch 60 new products as scheduled while simultaneously opening a new “greenfield” production facility, yet still adhering to stringent quality requirements and manage issues from new supply-chain partners. A the same time, it wanted to increase staff productivity time and collaboration while reducing travel and costs.
Case Study
Integration of PLC with IoT for Bosch Rexroth
The application arises from the need to monitor and anticipate the problems of one or more machines managed by a PLC. These problems, often resulting from the accumulation over time of small discrepancies, require, when they occur, ex post technical operations maintenance.
Case Study
Robot Saves Money and Time for US Custom Molding Company
Injection Technology (Itech) is a custom molder for a variety of clients that require precision plastic parts for such products as electric meter covers, dental appliance cases and spools. With 95 employees operating 23 molding machines in a 30,000 square foot plant, Itech wanted to reduce man hours and increase efficiency.
