•  A leading garment manufacturing company is facing problem in supply chain visibility.
•  The ability to monitor  details in real time, especially in a summarized format is not available
•  Delays in the approval process that involve multiple departments.
•  Issues with materials not arriving time causing problems in production details.
•  Data is stored in different Enterprise Resource Planning (ERP) systems, making it challenging to have a unified, single view of the information.

Introduction

A leading garment manufacturing company is facing problem in supply chain visibility.

Challenges

Data Sources

•  Data   - Microsoft DynamicsNAV 2016
•  SharePoint
•  Excel

Data Warehouse

•  SQL Server
•  SSIS
•  Power BI

Solution

•  Datawarehouse is implemented to combine the data from different data sources.
•  Power BI based visualizations is provided which increased the supply chain visibility.
•  RLS based security based on organizational hierarchy is provided

Key Benefits

•   Operational real time visibility in Supply chain