create a master table with store procedure
Budget: ₹600 – ₹1,500 INR
I need you to develop some software for me. I would like this software to be developed using SQL.
After this, you need to prepare process tables, which are formed with interrelations between multiple master entities (for the process tables, you may need to perform outlier detection and fill in the missing values again). After this, you need to calculate the key metrics from the process tables, which will give you more insight, and by presenting the data in a visualisation dashboard and adding additional sequential patterns (SPs), that show the on-ground performance.
Stored Procedures for
Cycle Data
Movement Data
Delay Data
OEE Calculations
After this, you need to prepare process tables, which are formed with interrelations between multiple master entities (for the process tables, you may need to perform outlier detection and fill in the missing values again). After this, you need to calculate the key metrics from the process tables, which will give you more insight, and by presenting the data in a visualisation dashboard and adding additional sequential patterns (SPs), that show the on-ground performance.
Stored Procedures for
Cycle Data
Movement Data
Delay Data
OEE Calculations