Photo: UNDP Bangladesh/Fahad Kaize

ICC Provides Analytics Support to UNDP’s Crisis Bureau for Assessment and Response to COVID-19

The UNDP Crisis Bureau coordinates speedy, effective and predictable responses to emergency situations of all kinds, from natural disasters to civil conflict, now including the novel Coronavirus pandemic.  

For early warning and response, the Crisis Bureau needed data used to inform UNDP’s assessment of and response to the COVID-19 crisis in support of national partners. 

To that end, ICC’s Data and Analytics Unit worked with the Crisis Bureau to build and deliver in record time a data warehouse solution that sources information from various data sets – two from the World Health Organization (WHO) and one from Johns Hopkins University – displaying it in mapping visualization dashboards.  

The COVID-19 data mart provides the number of confirmed cases and deaths and related statistics from the novel Coronavirus globally, nationally, regionally and locally, to visually interpret global and national trends as well as projections, models and forecasts

WHO reports cases at the country levelwhile Johns Hopkins University data shows information for various modalitiessuch as the province level in China, at the city level in the U.S., Australia and Canada and at the country level across the globe.  

Power BI Dashboard used for testing, validating and monitoring the COVID-19 data ingested in the data warehouse. Photo: ICC

COVID-19 data is extracted from sources on an hourly basis, reconciling web response restrictions imposed by the different platforms where data sets are hosted.

The information is then loaded to a staging area, transformed and finally extracted in presentation-ready formatinto the data warehouse. From there, the UNDP team can easily build their own dashboards with real-time information for analysis and interpretation. 

The COVID-19 data warehouse and dashboard capabilities designed and implemented by ICC’s team will help the Crisis Bureau assesand deliver effective strategies to respond to the ongoing pandemic.