Action Against Hunger

Ability to track real time progress made on sever acute malnutrition across 75 countries at National / District / Sub-District level.

the organisation

Action Against Hunger is a global humanitarian organisation which originated in France and is committed to ending world hunger. The organisation helps malnourished children and provides communities with access to safe water and sustainable solutions to hunger.

the challenge

The client had disparate data from 2011 across more than 10,000 excel files with multiple tabs. Users wanted to find an easier way to navigate through many countries, drill down to district level, find out SAM coverage and support in this area. As the data were in Excel, it was not rationalised nor there was any common structure. So, part of the problem was to consolidate this data into a single DB instance, create relationships and then have a web application which helps users to query these data sets to get meaningful representations per country. Users also wanted to have option to compare data sets over a period of years; to ascertain if specific countries are making progress in certain political areas.

A visual map driven web application integrated with Tableau for visualising about 80 parameters driven by UNESCO data

Icreon was involved in a detailed discovery session to do Proof of concepts with existing data set to find out if some meaningful collaboration can be figured out. Once the proof of concept was successful and approval from UNESCO, Icreon’s solution is one-of-a-kind giving information to Government bodies, politicians, researches, non-profits on direct information to field level data.

the solution

Icreon consolidated all the current data sets into a NOSQL solution. We then wrote scripts to created indexed data which can be accessed via a RELATIONAL Database. We worked on a Web based application where a map interface was given to users to query the data sets. Based on the data set selection, the countries were marked in variant gradients showing the occurrence of SAM vs what policies have the countries adopted to solve the issue. Researches could add multiple parameters and also choose year range; which would show a ‘trend’ analysis of the SAM pattern across continents. This had drill downs to sub-district-level to see how the data has been assimilated and to see all connected policy documents.

Looking to further the discussion?

start a conversation