Introduction
For the third edition of Dashboard Week, we were tasked to build a dashboard related to horse racing. The dataset has details of the race, title of the race and position of the horse during the race from 1990 to 2020. The data can be found here. After exploring the data throughout the day, I felt a little frustrated as I could not find much insights. Hence, I decided to look for supplementary data to create a story.
In Australia, Horse Racing exposes horses to significant risk of injury and sometimes, catastrophic injury and death through trauma (e.g. broken neck) or emergency euthanasia. The objective of my dashboard is to provide awareness of the dark secrets in horse racing. Hence, I brought in another dataset from here that contains the names of horses that died due to racing, their age and prevalent cause of death over from 2017 to 2021.
Alteryx Workflow
I merged all files and cleaned the dates in Alteryx. I exported the file in csv.
Insights: Tableau Dashboard
Before I proceed to building the visualisation, I created a relationship between the exported file and the names of the horses.
This is how the final dashboard looks like.
Summary
The Melbourne Cup always attracts plenty of money for the bookies, but in recent years it has been rocked by protests from animal welfare campaigners following the deaths of horses that died during the race. Some of the horses that died were as young as 2 years old and had little experience on the tracks. Majority of the deaths were attributed to the Melbourne Cup. In conclusion, it is about time that we look into improving the state of welfare of these horses and reduce the occurrence of injuries and deaths.
Thanks for reading my blog. Stay tuned for more blogs to come during the Dashboard Week!