On the fourth day of dashboard week, the task is to create a dashboard based on zoology collections from Oxford University Museum of Natural History which had been web-scrapped from the following link http://www.oum.ox.ac.uk/database/zoology/extinct.htm

Data Understanding

The provided data may need some work in terms of the ‘Common Name’ field as this field has some records which contain more than one names. In addition, the dataset may not have enough data fields that can be visualised for people with limited animal biological knowledge.

To solve the data quality issues, the field ‘Common Name’ was separated into several rows, and multiple Orders of animals were grouped into different food and habitat types.

Dashboard Objective

The dashboard was created to characterise different animals based on their conservation status. The animals were characterised in terms of their terrain and diet types. While there are multiple classes provided in the dataset, the created dashboard only focuses on mammal class (indicated by the ‘Class’ field value ‘Mammalia’).

Dashboard Creation

To work with the provided dataset, some researches and exploratory data analysis (EDA) were needed. One of the researches was conducted to understand how animal taxonomy works, and this research enabled us to create field hierarchy as shown in figure 1.

Figure 1. Field hierarchy that represents animal taxonomy hierarchy

After creating the hierarchy in figure 1, EDA was conducted to see similarity between different animals when they are grouped into Class, Order and Family. From the EDA, it seems that most animals share similarities when they are grouped into Orders. Hence, classification to multiple terrain and diet types were made based on Orders. Figure 2 shows how grouping was conducted from multiple Orders to specific terrain types

Figure 2. Grouping of different Orders into 3 terrain types

After field hierarchy and grouping had been established, multiple charts to build the dashboard were created. In addition, colouring based on animal conservation status was also conducted. Figure 3 shows the used colour scale for conservation status.

Figure 3. Animal conservation status colour scale (source: https://www.iucnredlist.org/about/faqs)

Lastly, the final dashboard was assembled and can be seen in figure 4.

Figure 4. Dashboard for Zoology database

To further interact with the dashboard, please visit the following link:


Kristiadi Uisan
Author: Kristiadi Uisan