ARi created an application which read the list of Sales orders from the input sheet, fetched & populated all the related data from ERP system to create a scheduling dashboard which displays multiple weeks schedule.
Application Devt – Data Engineering
Creating an application which should read the list of Sales orders from the input sheet, fetch & populate all the related data from ERP system & create the Scheduling dashboard which will display 6 weeks schedule.
- No visibility & insights into the manufacturing process.
- Unable to identify the reason for the gaps.
Developed a Macro which will fetch the data from ERP system and create the dashboard.
ARi’s Value Proposition
- 60 % time saving in populating the data for the sales orders for the entire month
- Customer can see the Plan vs actual in the dashboard
- Customer can track the status of production of any sales order