下载PDF
Pitney Bowes Revolutionizes Parcel Tracking with Fivetran
技术
- 分析与建模 - 预测分析
- 分析与建模 - 实时分析
适用行业
- 电子商务
- 运输
适用功能
- 设施管理
- 物流运输
用例
- 最后一英里交付
- 实时定位系统 (RTLS)
服务
- 硬件设计与工程服务
- 系统集成
挑战
Pitney Bowes 是一家简化电子商务、运输和邮寄的全球科技公司,其数据管理面临着重大挑战。该公司缺乏关键业务决策所需的高质量实时数据。其企业信息管理 (EIM) 团队正在努力解决孤立的数据、缺乏可扩展性和低效的技术支出等问题。员工将数据粘贴到 Excel 电子表格中以进行执行报告和分析,这往往会加剧问题。该公司还遇到了下游问题,例如影响服务水平协议 (SLA) 目标的延迟到达的软件包。他们缺乏检测延误并及时通知客户的能力,从而导致声誉风险。当在线购物增加十倍时,新冠疫情加剧了这些数据挑战,导致包裹数量增加十倍。该公司的旧数据基础设施无法处理每天 8 亿个包裹的基于事件和电子邮件的数据操作。捕获的数据至关重要,但将其聚合并整合到中央分析仓库需要数天时间,当到达领导团队时,这些数据就已经过时了。
关于客户
Pitney Bowes 是一家全球科技公司,致力于简化电子商务、运输和邮寄的复杂性。该公司每年通过 16 个配送设施管理 4 亿个邮件包裹,为全球 750,000 家企业提供服务。 Pitney Bowes 拥有超过 11,000 名员工,是电子商务、运输和邮寄行业的主要参与者。该公司的服务对于全球企业至关重要,其有效且高效地管理和跟踪包裹的能力是其成功的关键。该公司最近的数据堆栈现代化使其能够跟踪每个包裹并预测邮件量的变化,从而预测每个设施的劳动力需求。
解决方案
Pitney Bowes 决定通过实施 Fivetran 和 Snowflake 对其数据堆栈进行现代化改造。 Fivetran 取代了 Pitney Bowes 的所有自定义批处理脚本和提取、转换、加载 (ETL) 流程。该团队使用 Fivetran 的开箱即用连接器为 SAP、Salesforce、Facebook、Kafka 和 Kinesis 等多个关键业务应用程序快速构建管道。 Fivetran 能够将一批负载从 31 小时减少到不到两小时,另一批负载从几天减少到不到一小时。这种新的数据流有效地收集和汇总了来自 16 个设施的 700,000 个物联网设备的数据。 Fivetran 基于日志的变更数据捕获 (CDC) 连接器捕获所有数据更改,并消除了处理加载时间和对源系统的影响。 Fivetran 本地数据处理帮助 Pitney Bowes 移动大量数据并消除其基础设施瓶颈。该团队还利用 Fivetran 本地数据处理来同步 SAP 数据,这在以前是一个挑战。 Fivetran 的 SAP 连接器在七小时内将大量数据完全同步到 Snowflake,性能显着提高。
运营影响
数量效益
相关案例.
Case Study
Airport SCADA Systems Improve Service Levels
Modern airports are one of the busiest environments on Earth and rely on process automation equipment to ensure service operators achieve their KPIs. Increasingly airport SCADA systems are being used to control all aspects of the operation and associated facilities. This is because unplanned system downtime can cost dearly, both in terms of reduced revenues and the associated loss of customer satisfaction due to inevitable travel inconvenience and disruption.
Case Study
IoT-based Fleet Intelligence Innovation
Speed to market is precious for DRVR, a rapidly growing start-up company. With a business model dependent on reliable mobile data, managers were spending their lives trying to negotiate data roaming deals with mobile network operators in different countries. And, even then, service quality was a constant concern.
Case Study
Digitize Railway with Deutsche Bahn
To reduce maintenance costs and delay-causing failures for Deutsche Bahn. They need manual measurements by a position measurement system based on custom-made MEMS sensor clusters, which allow autonomous and continuous monitoring with wireless data transmission and long battery. They were looking for data pre-processing solution in the sensor and machine learning algorithms in the cloud so as to detect critical wear.
Case Study
Cold Chain Transportation and Refrigerated Fleet Management System
1) Create a digital connected transportation solution to retrofit cold chain trailers with real-time tracking and controls. 2) Prevent multi-million dollar losses due to theft or spoilage. 3) Deliver a digital chain-of-custody solution for door to door load monitoring and security. 4) Provide a trusted multi-fleet solution in a single application with granular data and access controls.
Case Study
Vehicle Fleet Analytics
Organizations frequently implement a maintenance strategy for their fleets of vehicles using a combination of time and usage based maintenance schedules. While effective as a whole, time and usage based schedules do not take into account driving patterns, environmental factors, and sensors currently deployed within the vehicle measuring crank voltage, ignition voltage, and acceleration, all of which have a significant influence on the overall health of the vehicle.In a typical fleet, a large percentage of road calls are related to electrical failure, with battery failure being a common cause. Battery failures result in unmet service agreement levels and costly re-adjustment of scheduled to provide replacement vehicles. To reduce the impact of unplanned maintenance, the transportation logistics company was interested in a trial of C3 Vehicle Fleet Analytics.
Case Study
3M Gains Real-Time Insight with Cloud Solution
The company has a long track record of innovative technology solutions. For example, 3M helps its customers optimize parking operations by automating fee collection and other processes. To improve support for this rapidly expanding segment, 3M needed to automate its own data collection and reporting. The company had recently purchased the assets of parking, tolling, and automatic license plate reader businesses, and required better insight into these acquisitions. Chad Reed, Global Business Manager for 3M Parking Systems, says, “With thousands of installations across the world, we couldn’t keep track of our software and hardware deployments, which made it difficult to understand our market penetration.” 3M wanted a tracking application that sales staff could use to get real-time information about the type and location of 3M products in parking lots and garages. So that it could be used on-site with potential customers, the solution would have to provide access to data anytime, anywhere, and from an array of mobile devices. Jason Fox, Mobile Application Architect at 3M, upped the ante by volunteering to deliver the new app in one weekend. For Fox and his team, these requirements meant turning to the cloud instead of an on-premises datacenter. “My first thought was to go directly to the cloud because we needed to provide access not only to our salespeople, but to resellers who didn’t have access to our internal network,” says Fox. “The cloud just seemed like a logical choice.”