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.
The client is a 20+ year old asset-based third-party logistics provider (3PL) of both brokerage & 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 & 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:
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.