Application Devt – Data Engineering

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.

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 can 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

Enhancing Rotary Blast Drills – For Global Construction Equipment’s Leader

Finite Element Analysis (FEA): Batching Plant

Finite Element Analysis (FEA): Cone Crusher Model

Finite Element Analysis (FEA): Loop Belt

Finite Element Analysis (FEA): Self-Loading Mixture Machine Cabin (ROPS & FOPS)

Equipment Cost Reduction – For a Leading Manufacturer of Construction Equipment

Welding Fixture Design for Truck Frame Sub Assembly – Steel Sector

Warehouse Management System – Construction Equipment’s

https://www.arigs.com/wp-content/uploads/2021/07/Data-Engineering.pdf