So, DSAU2 is nearly at the finishing line of The Data School – Phew – it sure was a roller coaster last few months. Each day a new task or a new client activity.

As it is the last leg – things have got more serious and intense – we are now building a DASHBOARD every day for this coming week. Happy days!!

We were given the challenge to create visuals from provided data to effectively answer specific questions. Data can be retrieved here: https://www.aiddata.org/data/aiddata-core-research-release-level-1-3-1.

  1. WHO DONATES? How are donations distributed across countries? Who donates to whom? Are there any patterns, for example, some group of countries tends to donate only to some specific group of other countries? Or maybe some countries tend to receive only from a specific set of countries?
  2. HOW MUCH DO THEY DONATE? How much do countries donate and receive? Who donates the most/least? Are there countries that donate and also receive? How does the amount donated/received by country change over time?
  3. WHY DO THEY DONATE? What purposes do the donations serve? Do countries tend to send (or receive) donations for specific reasons? For instance, is it possible that some countries tend to receive/send a certain type of donations whereas others receive/send different types?

Once data was uploaded into the tableau, it was then to organise and clean so that insight could be developed in visualisation.

After this, the next task was to categorise and organise the dataset so the relevant grouping could be formed.

For this scenario, I have grouped the “purpose” into meaningful groups.

Next, I combined donor countries and organisation into relevant groups.

Here are the views from my dashboard answering three questions asked:

Below is Donor Countries/organisations from 1973 to 2012

Below is Countries receiving Aid from 1973 to 2012

Below is Purpose for receiving Aid from 1973 to 2012

 

For full interactive viz click here.