It’s Day 4 of Dashboard Week, the second last day. If you don’t already know what Dashboard Week is, check out my Day 1, Day 2 and Day 3 blogs.
Similar to yesterday, we presented our dashboards in the morning and got some really good feedback. There was a consistent theme from the feedback that as a cohort, our storytelling through the dashboards was lacking. I decided to take this advice and worked on my story telling through a simple dashboard I created today.
Data
The data we received today was on the Legatum Prosperity Index. The index is compiled every year from 2007 to 2021 and measures the prosperity of 167 countries. Prosperity is described by the creators of the Legatum Prosperity Index as follows: “Prosperity is underpinned by an inclusive society, driven by an open economy, and built by empowered people”.
There are 300 different indicators used to calculate the prosperity index. With all of this data, adding supplementary data wasn’t necessary to tell a good story.
Alteryx
The data was already in a very clean format. The only problem was that it was wide. To fix this, the transpose tool was used to prepare the data in a format suitable for Tableau. Next, the year and metric (Score/Rank) was split using a Text to Columns tool. Then the columns were renamed, and data type was changed using the Select tool. Finally, the metric was changed to title case using the Data Cleansing tool and exported.
Alteryx Workflow
Dashboard
For this dashboard, I wanted to show how Australia’s Index compares to the index of other countries in the Asia-Pacific region. Additionally, Australia can be changed to other countries in the Asia-Pacific Region.
The dashboard is intended for people who want to see why Australia is a good place to live or encourage people who wish to live, work, study or visit Australia.
The dashboard starts with the current overall rank for Australia. Pressing the play button shows the change in rank over time.
Next, there is a comparison between Australia, the average and the other countries in the region. The 12 pillars are compared between Australia and other countries.
Clicking on a pillar expands it into elements making up that pillar. I’d like to shout out Ming for teaching me how to do a partial dill down from her informative blog post.
In this section, the user is free to explore each of the 67 elements to make a comparison.
Finally, there is a section that shows 4 important insights I found in the data including Education, Violent Crime, Emissions and Mental Health.
Tableau Dashboard
The result of day 4 of Dashboard Week can be found on Tableau Public here.
Reflections
Time boxing was more important today as we went over time during todays presentations. Additionally, I had another meeting that took up more of my time. Luckily, there was no need to spend too much time preparing the data in Alteryx. I learnt a few new tools today including using the Page feature in Tableau as well as refreshing my knowledge on table calculations, creating hierarchies and set actions.
Edit: Check out my blog post for Dashboard Week, Day 5!
