Day 4 of Dashboard Week and its back to Power BI, this time however, the data was actually very clean, and didn’t really require any Alteryx work to get into a workable state. The data was also very open-ended, we were given a choice amongst the 17 Sustainable Development Goals to create a report on, supplementing with data as necessary as per usual. The one that leapt out to me was Goal 14: Life Below Water. Now, I don’t particularly care for marine life or have strong feelings about wildlife conservation, but this was the perfect opportunity to use the much-maligned aquarium visualisation add-on, so how could I pass up on this?

The dataset itself was pretty bare-bones, only containing volume numbers for the amount fished for various countries. I really wanted some sort of story, so I honed in on comparing China, which had the largest fishing output by far in the Asian region to Japan, which had been in the news some years back due to illegal whaling. I wanted to find information on illegal fishing activity, and ended up using the IUU Fishing Risk Index to provide some extra context and metrics to my report in order to draw out some insights.

The actual report itself isn’t the most glamourous or feature-rich, but I took this opportunity to further improve upon being more stylised in regards to Power BI, opting to use images as backgrounds to really provide an extra layer of immersion. This report I also used a lot of tooltips and bookmarks to provide the viewer with definitions and a glossary of the various fields that the IUU index looks at, as well as the abbreviations within the UN SDG information.

I think had I more time I would’ve liked to pull in population information regarding the countries I was looking at, simply due to the fact that China’s numbers will always look extremely high due to its population count in comparison to a small country like Japan, and having something to be able to divide the metric tonnage of fish being caught could at least provide some sort of extra detail as to which of the two countries were actually over-fishing beyond their reasonable needs.  

Daniel Yam
Author: Daniel Yam