Documentation from the Interagency DR TDY completed in Jan 22-31, 2020 by @vanamala-narasimhan
CDC Tasks: Spent 3.5 days with CDC team to gather requirements and produce a PowerBI dashboard that automates the process of uploading and transforming weekly data ("Snapshots") and updates visuals accordingly. Data Dictionary and tool located on PEPFAR.net.
Next Steps for CDC: Continue virtual support for troubleshooting issues with PowerBI dashboard and automation of data load.
USAID Tasks: Spent 4 days with USAID team to gather requirements and produce an Excel dashboard that automates the High-Frequency-Reporting weekly data (main cascade indicators only, Age/Sex only) and produces trend visuals. Tool located on PEPFAR.net.
Next Steps for USAID: Work with USAID staff and HQ iSME to produce a quarterly dashboard incorporating kp and migrant status disaggregates, based off the Excel HFR dashboard.
Documentation from the Interagency DR TDY completed in Jan 22-31, 2020 by @vanamala-narasimhan
CDC Tasks: Spent 3.5 days with CDC team to gather requirements and produce a PowerBI dashboard that automates the process of uploading and transforming weekly data ("Snapshots") and updates visuals accordingly. Data Dictionary and tool located on PEPFAR.net.
Next Steps for CDC: Continue virtual support for troubleshooting issues with PowerBI dashboard and automation of data load.
USAID Tasks: Spent 4 days with USAID team to gather requirements and produce an Excel dashboard that automates the High-Frequency-Reporting weekly data (main cascade indicators only, Age/Sex only) and produces trend visuals. Tool located on PEPFAR.net.
Next Steps for USAID: Work with USAID staff and HQ iSME to produce a quarterly dashboard incorporating kp and migrant status disaggregates, based off the Excel HFR dashboard.