下载PDF
Pepsico's Transformation to Smarter Sales Forecasting with Designer Cloud
适用行业
- 消费品
- 零售
适用功能
- 采购
- 销售与市场营销
用例
- 需求计划与预测
- 时间敏感网络
服务
- 云规划/设计/实施服务
挑战
为了向零售商提供正确数量的产品,百事公司必须不断校准销售预测。任何给定的销售预测都可能包含仓库数据、商店库存数据或促销预测数据,所有这些数据均由零售商以各种不同的文件格式提供,并使用各种不同的方法传递给百事公司。百事公司的游戏名称是速度——足够快地准备销售预测,团队就可以预测需求激增并增加产品出货量。但在基于 Microsoft Access 和 Excel 的流程下,准备这些数据所需的大量时间意味着分析师每月只能利用一次(或根本不利用),这可能会导致零售商供应不足或过剩。
关于客户
全球 200 多个国家和地区的消费者每天享用百事可乐产品超过 10 亿次。百事公司的产品组合包括各种令人愉悦的食品和饮料,其中包括 23 个品牌,每个品牌的预计年零售额超过 10 亿美元。
解决方案
PepsiCo 构建了 Microsoft Azure 数据湖,可实现集中数据存储和访问。经过 Excel 和 SQL 培训的分析师可以轻松适应 Designer Cloud,现在可以更快地准备和标准化各种零售商数据,以便在 Tableau 中进行可视化。由于 Excel 的大小限制,PepsiCo 分析师经常不得不将多个电子表格拼接在一起;借助 Designer Cloud,百事可乐可以全面了解其数据并快速发现任何错误或不一致之处。由于花在数据准备上的时间减少了,百事公司分析师现在能够将大部分时间用于分析数据和预测趋势,从而为公司带来更多价值。
运营影响
数量效益
相关案例.
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
Improving Production Line Efficiency with Ethernet Micro RTU Controller
Moxa was asked to provide a connectivity solution for one of the world's leading cosmetics companies. This multinational corporation, with retail presence in 130 countries, 23 global braches, and over 66,000 employees, sought to improve the efficiency of their production process by migrating from manual monitoring to an automatic productivity monitoring system. The production line was being monitored by ABB Real-TPI, a factory information system that offers data collection and analysis to improve plant efficiency. Due to software limitations, the customer needed an OPC server and a corresponding I/O solution to collect data from additional sensor devices for the Real-TPI system. The goal is to enable the factory information system to more thoroughly collect data from every corner of the production line. This will improve its ability to measure Overall Equipment Effectiveness (OEE) and translate into increased production efficiencies. System Requirements • Instant status updates while still consuming minimal bandwidth to relieve strain on limited factory networks • Interoperable with ABB Real-TPI • Small form factor appropriate for deployment where space is scarce • Remote software management and configuration to simplify operations
Case Study
How Sirqul’s IoT Platform is Crafting Carrefour’s New In-Store Experiences
Carrefour Taiwan’s goal is to be completely digital by end of 2018. Out-dated manual methods for analysis and assumptions limited Carrefour’s ability to change the customer experience and were void of real-time decision-making capabilities. Rather than relying solely on sales data, assumptions, and disparate systems, Carrefour Taiwan’s CEO led an initiative to find a connected IoT solution that could give the team the ability to make real-time changes and more informed decisions. Prior to implementing, Carrefour struggled to address their conversion rates and did not have the proper insights into the customer decision-making process nor how to make an immediate impact without losing customer confidence.
Case Study
Digital Retail Security Solutions
Sennco wanted to help its retail customers increase sales and profits by developing an innovative alarm system as opposed to conventional connected alarms that are permanently tethered to display products. These traditional security systems were cumbersome and intrusive to the customer shopping experience. Additionally, they provided no useful data or analytics.