下载PDF
Redwood Logistics' Supply Chain Transformation with Fivetran and Snowflake
技术
- 功能应用 - 运输管理系统 (TMS)
- 基础设施即服务 (IaaS) - 备份与恢复
适用行业
- 建筑物
- 运输
适用功能
- 物流运输
- 维护
用例
- 最后一英里交付
- 交通模拟
服务
- 云规划/设计/实施服务
- 系统集成
挑战
Redwood Logistics 是一家第三方物流和运输管理公司,该公司在管理依赖于多个孤立仓库的复杂报告结构方面遇到了困难。快速增长的业务需要一个现代化的数据堆栈来支持其并购战略,为领导层提供近乎实时的业务绩效的准确概览。该公司每小时生成 500,000 个数据点,这对管理和处理来说是一项重大挑战。旧系统每天只能加载一次数据,并且每天容易出现大量故障,成为巨大的维护负担。 Redwood 最初对使用 Fivetran 的大容量数据复制持谨慎态度,因为团队需要了解它如何与现有数据库交互。
关于客户
Redwood Logistics 是一家总部位于芝加哥的第三方物流和运输管理公司。该公司与客户合作,为其供应链的各个领域(从仓储到经纪和全面管理的运输产品)开发定制解决方案。快速增长的业务拥有复杂的报告结构,依赖于多个孤立的仓库。 Redwood 需要一个现代化的数据堆栈来支持其并购战略,并为领导层提供近乎实时的准确业务绩效概览。
解决方案
Redwood 求助于全球云服务公司 2nd Watch 的团队来构建现代数据架构。他们部署了 Fivetran 的大容量数据复制解决方案,以自动将数据从其本地 SQL 数据库复制到 Snowflake 数据云。 Fivetran 现在在 Redwood 的 Snowflake 数据云中复制多种数据类型,包括运营数据、发票和付款数据、TMS 数据、评级信息和广泛的审计数据。这些数据使领导团队可以轻松地在 Tableau 中进行快速、全面的报告。该企业应用程序已用 Tableau 中更现代的数据堆栈和数据可视化取代了大量电子表格和临时查询。
运营影响
数量效益
相关案例.
Case Study
Energy Saving & Power Monitoring System
Recently a university in Taiwan was experiencing dramatic power usage increases due to its growing number of campus buildings and students. Aiming to analyze their power consumption and increase their power efficiency across 52 buildings, the university wanted to build a power management system utilizing web-based hardware and software. With these goals in mind, they contacted Advantech to help them develop their system and provide them with the means to save energy in the years to come.
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
Intelligent Building Automation System and Energy Saving Solution
One of the most difficult problems facing the world is conserving energy in buildings. However, it is not easy to have a cost-effective solution to reduce energy usage in a building. One solution for saving energy is to implement an intelligent building automation system (BAS) which can be controlled according to its schedule. In Indonesia a large university with a five floor building and 22 classrooms wanted to save the amount of energy being used.