Global Logistics Company

A Data Vault Solution for Real-Time Logistics Insights and Reporting.

An Overview

The Challenge

A logistics company reached out to 2nd Watch seeking help combining information across their key data sources to gain efficient and holistic reporting.

The Solution

The data vault solution implemented by 2nd Watch provided a scalable, organized, and audited platform that standardized and centralized the company’s various data sources.

The Outcome

By implementing a data vault model to integrate all of the source systems, the logistics company was able to easily access all of their delivery and financial KPIs through reporting.

01

Overview

A global logistics and transportation company sought to improve their data strategy as a means to drive efficiency and better utilize insights within their data. 2nd Watch implemented an innovative data modeling method called data vault to integrate four organizational data sources. This model ensured that the business could analyze trends across all of its data sources while providing a scalable data structure for future changes.

02

The Challenge

The logistics company wanted to develop reports that tracked KPIs and trends across a holistic view of their data. However, gaining insights across their many data sources proved difficult because their data was not stored in one centralized place. With the addition of more data sources than anticipated, they needed a plan to integrate their data. These challenges led to barriers in identifying areas of improvement within the company that were essential to remain competitive in the logistics industry.

03

The Solution

2nd Watch began by modeling the four most essential source systems with the knowledge that more systems would be integrated later. The 2nd Watch team determined that a data vault model was the best way to address these challenges for multiple reasons:

 

  • The data vault structure (hubs, links, sats, and refs) directly corresponds to reporting structures of dimensions and facts, allowing for an easy integration of multiple data sources in the data warehouse.
  • The model would speed up data transformation through parallel loading.
  • Data vault allows organizations to add data sources without redesigning the solution or significantly interrupting productional data flows.
  • It naturally accounts for auditing historical data.

04

The Outcome

By implementing a data vault model, the company quickly was able to integrate their data sources and report on trends across a holistic view of their data. The solution ensured the client achieved this goal because data vault does the following:

 

  • Automatically saves a history of attribute changes
  • Centralizes data across multiple source systems, which is essential for logistics companies that often use multiple data inputs and acquire other companies
  • Flexibly scales so data can be added when business changes occur without deleting information
  • Stores relationships in separate tables than attributes to decrease the time it takes to aggregate metrics