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

Welding Fixture Design for Truck Body

2025

Welding Fixture Design for OHT’S

2025

Truck Body Welding Line Layout Development

2025

Reverse Engineering – Warm Forge Die Set

2025

Design of Lifting Tackles with Turnover Scope

2025

Design of Lifting Tackles for Simple Components

2025

Design of Lifting Tackles for Large Products

2025

Design of Lifting Tackles for Complex Components

2025

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