Data analysis in transport management

NOSTA Group

Our client, the NOSTA Group, is an internationally operating logistics service provider that offers its customers individual full-service solutions for all aspects of transportation and goods logistics. The aim of the project was to process customer data from two transportation management systems.

Customer situation

  • Data sources in different formats and structures
  • Manual and error-prone merging
  • Tedious and time-consuming sales planning per profit center

Procedure

  • Joint requirements analysis
  • Formulation of target image
  • Integration & consolidation of different data sources
  • Mapping of finance hierarchy with internal cost allocation
  • Integration of automated workflow via AWS Glue
  • Essay reporting

Project result

  • Mapping of reporting via interactive Tableau dashboards
  • Merging of data from different transport management and CRM systems
  • Full mapping of the different hierarchies of company units