Case Study

Global Supply Chain Business

Establishing A Data lake to feed Business Reporting Dashboard

Customer Challenge

  • A global supply chain organization, generating over US$500 million in annual turnover.
  • Part of the Top 10 Logistics & Supply Chain Providers worldwide active in the B2B as well as B2C services in air, ocean and road transportation, warehousing and associated tasks
  • Operating through a complex enterprise landscape evolved over a 25-year period, multiple systems, multiple data sources int / ext
  • ‘Single source of truth’, was 12 systems with constant alignment and timing issues
  • The selection of DDC to partner with them, reflected a purpose-built process to support their needs, with a clearly defined value chain, along with a risk mitigation strategy.

    DDC Solutions

    • Data lake model defined and deployed

      Applications targeted by data scope and reporting significance,

      EDI / API connectivity priorities set

      Apps linked 1 to 1 or clustered where existing connectivity could be leveraged

      MS PBI deployed, fed directly from Data lake

      Staff selected for skill training, deployed via video self learning and certification model

      Supervision of process until completion of integration work, refinement of dashboarding, coding of standard internal and external reports

      Finalization of tiered reporting, all business levels active

      Enhancing Data Analytics

      The Impact

      • 1st time organization could leverage all business information unilaterally
      • Visibility across a whole range of business functions not previously in daily scope
      • Savings in cost to serve, customer service and key business functions delivered
      • Customer dashboarding revolutionized how customers were managed, within a smaller footprint and improved standardization