Redwood Logistics was started in 2001 and as the years passed, the company quickly grew through several acquisitions. As the tools and systems from these acquisitions were integrated, Redwood ended up with multiple source systems used for planning loads and optimizing routes for its clients. However, due to differences in the underlying data from these source systems, Redwood could not get a complete picture of their business- each system was fragmented and provided visibility of the business in different ways. Redwood Logistics needed a better way to use its data in order to more efficiently fill truck loads, optimize routes, and ultimately improve profit margins for the business.
To start, Analytics8 performed an assessment of the company's data environment and provided a roadmap for building out a lasting infrastructure to enable leadership to view their business as a single entity. We then built an Enterprise Data Warehouse which incorporated data from their various data sources including homegrown logistics systems and third party systems. In addition, in order to easily extract the data and integrate it into the data warehouse we built, we developed a XML parsing tool to parse XML files and store the data in a permanent data store, ensuring that no data was ever lost from any of these files. We then built a dimensional model to enable Redwood’s internal staff to quickly and easily build reports- allowing employees to view their data in near real-time with over 99% accuracy- a vast improvement in the previous reporting, which typically took much longer to provide with a large amount of manual effort.
Redwood’s executive leadership and logistics staff now have the ability to more efficiently manage the company’s internal and third-party freight network. With access and insight into better information, Redwood Logistics has been able to optimize the use of its trucks and develop more efficient routes which has resulted in increased profit margins.