This is a report template for Data Collection Monitoring.
it is set up here to allow for automation with a direct connection to UNHCR kobo server using an authentication token.
In most cases, Survey Data should rather be analyzed only once it has been curated and documented within UNHCR Internal Data Library: http://ridl.unhcr.org. Data Collection Quality Monitoring is actually the outlier - in such situation, you need to review on a high Frequency Level, how well the data collection is going.
The approach from this report build from High Frequency Checks.
Below is a step by step how to in order to configure the automation.
You first need to create a documentation file - which allow the Rstudio server to regenerate your report. This files is created by th e rsconnect::writeManifest
.
Note that if you are the one developing any of this package, you will first need to re-install them from github or gitlab for the manisfest file to be correctly written. See more documentation here: Git Backed Content - RStudio Connect: User Guide
# devtools::install_github("rstudio/rsconnect")
# rsconnect::writeManifest(appPrimaryDoc = "DataCollectionMonitoring.Rmd")
Got to UNHCR Rstudio server - http://rstudio.unhcr.org - you need first to have a license associated to your account - Contact Global Data Service Data Science team for that.
You need now to set up the kobotoolbox authentication token within the Rstudio server so that the server can actually pull the data from Kobotoolbox in order to regenerate the Report.
et voila...
Step 5 - Use power automate to forward automatically the email with the report to the data supervisor
Microsoft Power Automate is a convenient way to automatically re-forward the generated report to your surrvey coordinator and data collection supervisor.