Supply Chain – Data Lake & Microsoft PBI
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
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
