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.

7 comments

Join the conversation:

Comment
Photo of Orhan

Hi,

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.

Photo of Ashley Tillman

Hi Claude Hakuna thanks for sharing! I am curious your thoughts on analogous spaces the do data collection, analysis and visualization well that the sexual and reproductive health community could learn from?

Photo of Claude Hakuna

I cannot think of a full fledged platform that adequately integrates data collection, analysis and visualization at the level I think should be done. However there are some fair attempts at global level such as devinfo and measure evaluation. These are certainly not the only ones but they just came to mind.

Photo of Ashley Tillman

Interesting thanks for sharing! Out of curiosity what got you interested in this topic?

Photo of Claude Hakuna

2 things:
1. Development practitioners (in general and here more specifically SRH) generate a lot of data but they are not good at deriving and telling stories from the data (call it statistical analysis). I think most practitioners do not even realise that they are also in the bid data domain and need same tools used by Google, Facebook, Amazom, Telecoms etc to help them do data wrangling, machine learning, natural language processing, Bayesian stats, regressions, modelling etc (call it data science) capable of giving them insights into the prevailing situation and impact of the work they are doing. (situational analysis and program evaluations).
2. Although lots of data is generated, most of it is very disintegrated with each organisation seemingly too busy pursing some 'individual objectives' (competing actually) and we loose sight of the bigger picture in the process. I think we need a common and coordinated effort to generate and share data and produce better information products from it. It takes efforts at very high level (such as UNFPA) to convince CBOs and other frontline organisations to put data together for common use.

I actually dont believe we lack data, instead we lack collaboration and the ability to effectively make sense of what we already have.