Fivetran
Case Studies
Pitney Bowes Revolutionizes Parcel Tracking with Fivetran
Overview
Pitney Bowes Revolutionizes Parcel Tracking with FivetranFivetran |
Analytics & Modeling - Predictive Analytics Analytics & Modeling - Real Time Analytics | |
E-Commerce Transportation | |
Facility Management Logistics & Transportation | |
Last Mile Delivery Real-Time Location System (RTLS) | |
Hardware Design & Engineering Services System Integration | |
Operational Impact
The implementation of Fivetran and Snowflake revolutionized Pitney Bowes' data management, providing real-time data and eliminating performance issues. The company was able to create a real-time operational analysis dashboard, providing a comprehensive view into volume, labor, and efficiency across all facilities. This allowed executives to understand exactly what was happening across the entire business at any given time. Facility managers could drill down to see parcel volume and assess corresponding labor capacity. The company was also able to build predictive dashboards for facility volume, network volume, estimated delivery and return dates, harmonized system (HS) product classification, and delivery truck scheduling. This led to increased operational efficiency and the ability to proactively mitigate risks. The updated data architecture also provided the foundation for a new revenue-generating program called “Guaranteed Delivery.” The company could predict facility volumes and delivery dates, providing downstream delivery assurances through their vendors. They could even spot churn behaviors and mitigate that risk proactively. | |
Quantitative Benefit
Gained near real-time visibility and analytics for 16 global distribution centers and 800M+ packages per day | |
Achieved a 93 percent delivery estimate accuracy after a period of missed delivery SLAs, leading to new revenue-generating delivery guarantee program | |
Reduced batch load times by 94 percent from 31 hours to under two hours | |