Day 2 topic, ‘World Bank FMIS Projects Database‘:

So this dataset is used to keep track of all the projects funded by the World Bank. This dataset is in an excel file. The layout is nicely formatted for human consumption with a few tables within a sheet, which makes it impossible to parse into Alteryx. Please check the example below

Data wrangling

As I mentioned above, it is impossible for Alteryx to read this file. So, a lot of pre-processing steps are required. My strategy is to copy all the important tables from the original dataset then paste each table into each sheet of a new excel file. Then read every sheet the new file to Alteryx. As you see, the workflow is very straightforward, because most of the complexity has been taken care of during the pre-processing steps. Please check my workflow below:

The Viz

This viz is to showcase the performance rating of all the projects funded by the World Bank. Many new measures are introduced while some are conversions from the current ratings give to each project by the World Bank into a number format for calculation. Those calculations are clearly explained when you hover your mouse on the top right mark, I won’t go into any more details as those calculations are straightforward to understand.

Now about the viz style. I am a big, big fan of Andy Kriebel, he is a UK Data School Coach as well as a Tableau Zen Master. My current style is heavily inspired by Andy’s simple and visually appealing approach. So today I will apply one of his styles to my dashboard. His dashboard link you can find here.

The Good:

  1. BANs for each region act as filters for countries
  2. Helpful tooltips which show the score for each category
  3. A clean nice look, with a uniform colour palette.
  4. The bar chart provides drill-down action,

The Best:

  1. One of the nicest and cleanest dashboards I have built so far, in my opinion.
  2. The tooltip on the top right corner provides all the calculations explanations used in this dashboard.
  3. A lot of meaningful measures for which I took the inspiration from how the author layout his analysis.

Time finished: 8:30 PM

Please take a look at a brief demo below, or you can check this viz out at this link: