Transforming a dated transportation reporting solution into the latest technology with advanced analytics

Transforming a dated transportation reporting solution into the latest technology with advanced analytics

Migrated a dated data warehouse structure and reporting system into an advanced, integrated, single-source transportation reporting system with advanced analytics for a global food manufacturing company.



About the Client:

Our client is a leading global food and beverage manufacturing company.



The objective was to migrate the transportation reporting system from a dated legacy data warehouse to the latest SAP Business Warehouse (BW), build an integrated data warehouse solution for ad-hoc analysis, create pre-defined reports, add advanced analytics and accommodate changes planned for OLTP systems


The Solution:

  • Designed and built the latest data warehouse with SAP BW, used SAP Business Explorer for reporting and published the reports in SAP Enterprise Portal
  • Designed and developed master data and hierarchy data extracts from Master Data Management
  • Designed and developed interfaces to send the consolidated data to downstream systems
  • Designed over 40 DataStage jobs to extract data from transportation systems into shipment planning, orders, tenders, executions, invoicing, accruals and payments business processes
  • Efficiently handled the large volume of data for highly analytical reports


Outcome and Benefits:

  • Created a single reporting system for all the transportation reporting
  • Identified inefficient routes and optimized the routing guide
  • Identified the cost by transportation linehaul, fuel & accessorial cost by SKU, and included the ability to roll up to k level and business unit using the Finance Product Structure
  • Improved the tender acceptance rate by carriers
  • Improved the unload and upload times for shipment orders
  • Optimized the cost per case/pallet/caw/gross/net lb. for transportation
  • Narrowed the gap between planned vs actual shipment costs


Add Your Comment

Your email address will not be published. | Required fields are marked *

To find out more about how we can be your trusted analytics and planning partner, contact us today.

Contact Us

Contact Us