{"id":3951,"date":"2020-06-16T13:24:05","date_gmt":"2020-06-16T13:24:05","guid":{"rendered":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/?p=3951"},"modified":"2025-11-18T08:39:59","modified_gmt":"2025-11-18T08:39:59","slug":"modernizing-esg-data-for-resilience-and-compliance-2","status":"publish","type":"post","link":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/modernizing-esg-data-for-resilience-and-compliance-2\/","title":{"rendered":"Modernizing ESG Data for Resilience and Compliance"},"content":{"rendered":"

[vc_row][vc_column][vc_column_text]<\/p>\n

Manual data and analytics leave unanswered questions<\/h2>\n

With a manual data collection and analysis process, this client strained to answer questions about its supply chain logistics. From simple questions, such as, \u201cHow long does it take a shipment to get from point A to point B?\u201d to more complex network analysis, the right data was not available fast enough, nor was it accurate or up to date.<\/p>\n

The company ships and stores tens of thousands of incoming raw materials and finished products around the world. That means moving materials from warehouses to manufacturing facilities and tracking them through the manufacturing process. Finished products are shipped to the company\u2019s warehouses worldwide and then to final destinations by planes, trucks, trains, and ocean vessels. It\u2019s a complex juggling act to keep track of thousands of products, shipments, and vendors.<\/p>\n

Company executives wanted to get real-time answers that would allow them to optimize the cost and logistics of moving these materials within their global network and among shipping vendors. This meant that they needed a high-performance data management solution to integrate data from internal SAP systems and external shipping vendors and make it available to analysts for exploration and reporting.<\/p>\n

Consolidated data powers logistics reporting and analytics<\/h2>\n

The company worked with Wavicle to develop a solution to replace its current Excel-based reporting and analytics. We had already built a cloud data architecture and infrastructure for the client\u2019s procurement organization. We leveraged this Amazon Web Services (AWS) environment to develop a logistics data lake on S3 and a data warehouse using Amazon RedShift. We used Talend for data integration.<\/p>\n

This solution allows the company to integrate data from multiple internal SAP systems, shipping vendors, and third-party logistics companies (3PLs), as well as Infor Nexus, which tracks and reports on the location of vessels. End users now have the data they need to do reporting and analytics using Microsoft\u2019s Power BI. Additionally, they will load data from the data warehouse to Llamasoft for supply chain modeling, optimization, and simulation.<\/p>\n

Optimizing logistics around the globe<\/h2>\n

This solution gives the client\u2019s logistics organization fast access to accurate, updated information to evaluate vendor cost, service, and speed; identify logistical inefficiencies; negotiate with vendors; and optimize their global network. The combination of a data lake and data warehouse allows the client to perform enterprise reporting on an aggregated data set and explore a complete set of raw data for more complex, open-ended inquiries. They are now able to quickly answer questions such as:<\/p>\n