Case Study: Action Against Hunger
Ability to track real time progress made on severe acute malnutrition across 75 countries at National / District / Sub-District level.
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 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.
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.