The topic for this week dashboard is Melbourne Cup; Surprisingly the day we are presenting this dashboard is also the day for Melbourne Cup 2022.

The data was web scrapped from this website: https://www.races.com.au/melbourne-cup/melbourne-cup-results/

I will be using the data from 2012-2021

This dashboard agenda can be divided into two parts

  • Alteryx
  • Tableau

Alteryx

Web Scrapping was done using Alteryx. This part took the most time in preparation of the dashboard. I used standard macros to extract the data. Five (5) different macros were made to create tables to be used in Tableau for data visualization.

  1. Macro 1: 2009

Figure 1: Macro for 2009 Data

2. Macro 2: 2010-2011

Figure 2: Macro for 2010-2011

Macro 3: 2012-2017

Figure 3: Macro for 2012-2017

Macro 4: 2018-2019

Figure 4: Macro for 2018-2019

Macro 5: 2020-2021

Figure 5: Macro for 2020-2021

Tableau

The idea behind the dashboard was to give user the ability to place a bet with respect to Horse and its trainer. The dashboard shows which countries horses participated the most and which position they acquired throughout the last 10 years.

Another functionality of the dashboard is for someone who wants to place bets. They can have a look on ranking of different trainers as to which position, they finish in on average considering the number of matches involved. If they want to consider just the Horse, they can look throughout the years which horse won the most and with parameter change they can switch the view to trainer and look at most wins by trainers throughout the year.

Figure 6: Final dashboard

Icons: Flaticon —-> Freepik

Maliha Athar
Author: Maliha Athar