Data Engineering – Scheduling Dashboard Process Automation

Project Scope

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.


Business Challenges


  • No visibility & insights into the manufacturing process

  • Unable to identify the reason for the gaps


ARi’s Solutions

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 is able to see the plan vs actual in the dashboard

  • Customer can track the status of production of any sales order


Download
Case Study

Download Case Study

Case Studies

Related

Prototype Built & Integrated Powerpack for Military Vehicle

2016

Cop Testing on Engines for Construction Equipment

2017

Tear Down Analysis of Construction Equipment

2019

Design and Development of Radiator Plugging Bench

2021

Scissors Lift – Software Development & Validation

2021

Unit Testing – Platform

2021

Genset Packaging

2021

Automation UDS Service Tool

2021

https://www.arigs.com/wp-content/uploads/2025/11/Data-Engineering-Scheduling-Dashboard-Process-Automation.pdf