On day 2 of the dashboard week, we were given World Bank FMIS Projects data to build a dashboard. The data is well-formatted in excel for humans to consume, but it’s a nightmare to be used in tableau and Alteryx. I would love to sit down and find a technical solution to parse the data, but since we only have one day to build the dashboard, manually copying and pasting to Alteryx is currently the ideal solution.
The data set contains detailed information of work bank projects, I feel that it has limited opportunity to find interesting insights with only these projects data. Therefore, I have added the GDP data (constant 2010 US$) of each country provided by the World Bank. With GDP data, we can use it to answer several questions, such as:
- Did poorer (in terms of GDP) countries received more support from the World Bank?
- Has the World Bank project effectively facilitated the GDP growth of recipient countries?
With these questions in mind, I build the following dashboard.
Aspects of the dashboard
- BANSs allows visualising the average duration breakdown of the projects, which will change interactively as you click through the region and project status marks.
- An area chart counts the running sum of the costs by region along project approval years. Which can be used to filter other charts by region.
- A scatter plot compares GDP per capita with project costs per capita, allowing you to understand whether poorer countries received more funds intuitively.
- A bar chart also shows the cost of each region but is broken down by project status.
- Finally, another bar chart shows the GDP of the selected country, and you can select that country in the scatter chart. The mark on the bar chart indicates the year of completion of the project, which can help you visually understand whether the project contributes to the GDP growth of the selected country.
Feel free to play around with the dashboard here.
Author: Binbin Chen
Binbin came to Australia and studied mechanical engineering at Monash University. After earning a bachelor's degree, he pursued a PhD degree and worked as a part-time teaching associate at Monash University during the period. When analysing data in research projects involving human eye movements, he discovered his enthusiasm for data. He was delighted to learn about Data School Down Under as it provides a unique opportunity to start a career as a data analyst through a thoughtful training program. Outside of work, Binbin enjoys watching historical and political videos. He is also an anime fan!