Removing Guesswork Out of Transport Planning

Removing Guesswork Out of Transport Planning

We developed a forecasting tool with over 70% accuracy to optimize major international shipments.

The Opportunity

A global consumer packaged goods company was spending $400 million annually on transport; however, they were struggling to manage their shipping routes, carriers, and volumes due to poor, ad-hoc analyses in Excel. The transportation team wanted to see if a forecast could fill the gaps in their tender acceptance rates.

Our Solution

We rapidly developed a forecasting solution in four weeks that can estimate weekly shipment volumes for months in advance for the top 150 routes and carriers. The tool also identifies patterns in the route volume, carrier volume, and even the product being shipped by looking at five years of historical data. 

The Results

Thanks to our accurate forecasting tool, the company can better manage their shipments and optimize their transportation budget. Our solution had a 70% accuracy rate for top route-carrier forecasts and a 56% accuracy in overall forecasting. They are now able to better communicate with their carriers to be proactive on shipment management, rather than reactive.

Read More Case Studies

Wrangling Data and Hundreds of Hours

Wrangling Data and Hundreds of Hours Let’s automate your data processing and free up time for advanced analytics. Opportunity A Fortune 500 consumer packaged goods company needed a series of dashboards built to visualize a multitude of quarterly reports. Unfortunately,

READ MORE →

Removing Guesswork Out of Transport Planning

Removing Guesswork Out of Transport Planning We developed a forecasting tool with over 70% accuracy to optimize major international shipments. The Opportunity A global consumer packaged goods company was spending $400 million annually on transport; however, they were struggling to

READ MORE →

Month End Close Processing

Month End Close Processing insert description here Opportunity A regional bank was frustrated with the amount of time it took to process their household reporting every month end. It cost 100K a year to send their own data to a

READ MORE →

Assessing the Press with Sentiment Analysis

Assessing the Press with Sentiment Analysis Sentiment scoring is complex. We build a simple yet powerful text analysis tool that required zero coding skills to use. The Challenge A major US healthcare provider was struggling to monitor their media coverage.

READ MORE →

Piloting a Swift Alteryx Server Deployment

Piloting a Swift Alteryx Server Deployment Servers are key to scaling and getting the most out of your analytics investments. The Opportunity A Fortune 100 manufacturing conglomerate had a growing number of Alteryx Designer users but no ability to schedule

READ MORE →

Fast, Not-So-Casual Dashboards for 2,000+ Restaurants

Fast, Not-So-Casual Insights for 2,000+ Restaurants With row-level security, we developed customized dashboards in under nine weeks that saved one company thousands of hours. Opportunity Everyday, a fast-casual restaurant chain sends out thousands of email update with daily financial metrics

READ MORE →