Day 4 of dashboard week working with a new set of data from the oxford university national history museum. This data was very minimal and was a challenge on finding supplementary data to work with what we found. After trying many different API’s and different sets of data I managed to find the main Redlist website dedicated to animals that are endangered and extinct.

From here it was a matter of getting data that was related to the dataset that we originally got. I took three main files from the Redlist website that contained geographical and special information in order to enrich the original dataset. From here it was a matter of taking it into Alteryx and joining all the data that was available and making sure that all data was unique and there were no duplicated fields in the data. This then resulted in me taking it all into tableau and starting to visualize the data and see what story I wanted to convey. This led to me breaking them down into different classes and focusing on four main classes that were Mammals, Aves, Reptiles and Amphibians. Breaking it down into classes allowed me to dive into making charts that related to all of the classes and not trying to focus to an overall level that would leave me with too much information.


Now in full disclosure within Tableau 2022.3 there is a new funky feature that allows one to collapse tiles and containers with the use of a Boolean statement. As an example of this, the one elephant or all elephant tab changes the view depending on what is selected. This is because it updates a parameter to be either true or false depending on which one is picked. This will then change the view from an overall view to a view just compiled charts needed. This screenshot below is the same dashboard with the new function to show only an individual animal. This allows for a greater customizations in charts and dashboards these days.

The Dashboard was an interesting experience in data gathering and visualization but the key learning that I had here was the experience with the dynamic container feature. If you would like to see the full version please follow the link!

Stephen Hughes
Author: Stephen Hughes