Steps for Op Dashboard

Creating a Pipeline to fetch all data possible from Kobo Toolbox to DG Database using Hevo, Each type of form will be stored in different tables and it will be dynamic in nature, columns of each form and number of forms will change with time so we need to update the pipeline whenever there is new form deployed.

Few Metrics are not recorded in Kobo tool like Status of Payment, Numbers of VRP in training, Numbers of VRP trained, Review meetings with Jeevika(Block/District/State) and similar numbers for these type values we need to follow a manual procedure at least for the time being until we come up with a better solution till then we will be recording all these numbers in a shared spreadsheet in google drive and from there BI will use this sheet for Dashboard.