Transportation & Logistics
Trigent’s solution eliminated all information silos and enhanced communication throughout the company with a single source of the truth. The solution provides a centralized view of our business data, enabling us to make better decisions and increase our sales.
About the Client
The client is a 20+-year-old asset-based third-party logistics provider (3PL) of both brokerage and freight management and asset-based services of dry van, refrigerated, and dedicated/private fleets. They manage over 85,000 shipments for more than 600 customers from various industries using multimodal transportation. With multiple office locations in the US, the client serves customers in the United States, Canada, and Mexico.
The client had procured several off-the-shelf systems to help run their business. Their source systems collected large volumes of transactional data, and extractive meaningful and relevant data from them was a challenge.
Due to data silos, users received different and unverified data, creating inaccurate insights which led to reduced revenue. Executives and mid-level managers spend hours struggling with spreadsheet tools to understand their department’s performance.
Reports were done manually, were not integrated and not interactive. Such manual processes introduced costly errors, subsequently leading to potentially wrong premises for the company’s planning cycles.
To alleviate these business pains, the client needed a scalable, comprehensive, and robust solution that would help them derive consolidated analysis as well as intelligence by accessing data scattered across different data source. They also wanted to improve overall business performance, and increase sales.
Trigent studied the eight existing applications and their data sources:
Trigent’s Data Architects and BI Engineers understood the KPIs, key metrics, formats, and veracity of various data sets, reports, dashboard and planned a roadmap for implementing a solution Trigent built a Business Intelligence(BI) system with the following components:
The Source System — Existing applications from where the data needs to be extracted to a Data Mart Layer. Data from the cloud were extracted using API or using flat files. Implemented the Extract, Transform and Load process (ETL) that will help in loading the Flat Files to the data mart server. For all the on-premises applications, data extraction was done from the databases.
Data Mart Layer — A scalable, flexible layer which is used as ‘Single Source of Truth/ Data’ to accommodate all modifications. All data from the productions systems are collected, cleansed and validated.
BI Server — A repository for all reports and dashboards. Users can access these reports via browser or mobile applications. Role-based data security was also set up.
Presentation Layer — Used for creating workbooks, view dashboards and data sources and then publish this content to the server.
Trigent populated the central Data Mart, with all data sources from the eight applications. Also developed ETL scripts to fetch the required data for reporting, and did periodical extraction of updated data from the source systems.
The New BI System
The testing efforts enabled the client to