rdcAVS
Project Summary
rdcAVS is an R Shiny app that automates the setup of Google Sheets-based data collection and provides real-time monitoring for vaccination campaigns in the Democratic Republic of the Congo. View the source on GitHub or try a demo here.
Problem & Solution
Campaign data collection relied on complex Google Sheets (often hundreds of columns) and manual setup, making real-time quality checks difficult. rdcAVS streamlines sheet creation, permissions, and aggregation, enabling faster deployment and live data quality monitoring so teams can act during a campaign rather than after.Key Features
- Google Sheets integration: Automated creation and configuration of campaign folders and sheets; handles permissions and summaries across geographic levels.
- Geographic database: Standardized geo data to ensure consistent sheet structure and accurate aggregation.
- Permission management: Bulk user and role management to simplify access for hundreds of data managers and supervisors.
- Real-time surveillance & data quality: Dashboards, alerts, and visuals to track progress and surface data issues during campaigns.
- Deployable: Designed for easy web deployment and compatibility with existing field workflows (including offline-friendly Google Sheets use).
I am the primary developer responsible for design and implementation, working with stakeholders in DRC to ensure the app matched operational needs.
Technologies & Skills
- Languages & frameworks: R, Shiny
- Data: dplyr, tidyr, stringr, lubridate
- Google integration: googlesheets4, googledrive
- Visualization & UI: ggplot2, bslib
- Experience: app design, deployment, stakeholder-driven requirements, and large-scale permission workflows