OpenIDEO is an open innovation platform. Join our global community to solve big challenges for social good. Sign Up / Login or Learn more

National and Regional Data Warehouse with advanced analytics and Dashboards

Successful programming often relies on good data presented in an engaging way to create useful information products that drive decisions

Photo of Claude Hakuna
7 1

Written by

Data and Information are the key drivers of any intervention and in SRH especially as it relates to young people, we often have a huge information gap that requires a multifaceted approach.

My assumptions are that we either have no to little information or fragmented pockets of data.

It would be necessary to develop a data warehousing model and policy to be implemented by member countries.

The focus would be on standardising data collection methodologies, data management and indicators. 

The collected data is put into a common database that allows governments, organisations, research institutions, and other interested stakeholders to views data at various geographic scales to inform policy and targeting.

The user interface would be driven by an application that provides dashboards with basic information but has advanced statistical and spatial analysis capabilities allowing users to extract information products that suit their unique needs.

The motivation is that for us to make good interventions, we need data that is relevant and is presented to us in a more meaningful way. To achieve this two things are necessary : 

1) Standardised data collection approaches

2) Common platform for analysing the data with simple dashboards but with advanced spatial statistics capabilities with inbuilt geoinformatics functionality.


Join the conversation:

Photo of Orhan


Do you think that collection and storage of anonymized Call Detail Records (CDR) Data on national level would help? Once you have that data and combined with other data sources creates foundation for big data which can be open (open data policy on national level) to 3rd party analytics organizations to develop and use various platforms for analyzing the data instead of having one national/regional common platform. As we are aware a unique data-set can be used for different purpose. Example: In case of an emergency, mobility of citizens can help medical teams to plan their human resources to respond more efficiently by knowing what is expecting them. The same information can help international humanitarian community to deploy teams at the right places in neighboring countries with the right amount of resources such as food, tents, etc. (my comment is general not only focused on the challenge)

Photo of Claude Hakuna

Makes a lot of sense. I think in the world of humanitarian informatics any extra data that helps us to understand human activity is essential. I am also currently experimenting with automated mapping of buildings for purposes of estimating population densities. When you combine such things it becomes a trove of information for emergency response be it in risk analysis, damage assessment, response planning or evaluation.
Thanks for sharing

Photo of Orhan

An automated mapping of buildings for purposes of estimating population densities is interesting approach. Three pilot countries have started projects in CDR anonymization and storage. There is a known organisation on data analytics which has approached one of the countries to collaborate and provide the country with an analytics platform related to health and epidemics. CDR analytics can also provide valuable information to target the right age group in order to improve access to, and quality of, sexual and reproductive health education and services for young people's levels. As one shoe does not fit all, but some. Also, different age groups absorb differently the available information.

View all comments