5 min read

 

As Data Schoolers, towards the end of our 16-week intensive training, we all take on an ambitious challenge — creating one dashboard, one blog and one presentation on a fresh dataset every day for a week! Today marks the final day of this challenge. In this blog, I would like to share my approach to today’s challenge and showcase my finished dashboard.

You can also find all my dashboard week blogs here:

Day 1: Global Power Plants

Day 2: Wages vs. Inflation

Day 3: Star Wars

Day 4: 2021 Australian Census

Day 5: AFL Data

 

 

The Data

Today’s dataset is the AFL data. It consists of three tables, players, stats and games.

 

 

The Plan

Step 1: Data Understanding

It always pays off to start the analytical process by understanding our data. At this stage, it is often not necessary to develop a comprehensive knowledge of the data, but just enough so that you can start exploring relevant business questions and hypotheses.

For the AFL data, I noticed that:

  1. The player data is at the player level, uniquely identified by the player id (rather than player name, since there may be different players of the same name).
  2. The stats table is at the match-player level, where the stats of each player for each match is recorded.
  3. The games data is at the match level of detail.

 

Step 2: Business Understanding

In this part, we try to understand why we are performing our analytics project. This is also where we begin to pose hypotheses or goals. For this project, I want to take a fun approach to AFL, and explore which combinations of star signs and Chinese zodiac signs make the best AFL players!

 

Step 3: Planning

The data was already very clean. The major challenge would be bringing in the star signs and zodiac signs data. Luckily the players table contains player birthday information, and we can certainly make use of that to identify each player’s star sign and zodiac sign.

 

Step 4: Data Cleaning and Pre-processing

I’ve used Alteryx to clean the dataset. More specifically, I:

  1. Enriched the dataset with additional tables that contained star sign and Chinese zodiac sign mappings.

 

 

The Dashboard

Below is a screenshot of my finished dashboard. The dashboard is made up of five main sections:

  1. The Star Signs: where the user can click on a star sign to filter the dashboard.
  2. The Chinese Zodiac: where the user can click on a zodiac sign to filter the dashboard.
  3. Player Position: which is filtered down by Star Signs and Chinese Zodiac, and which the user can use to further filter down the key metrics. It is important to compare the metrics based on relevant player positions. For example, if we click on Defender, then we should set Metric Groups to Defensive to look at the appropriate metrics. Comparing offensive stats for Defender players usually wouldn’t make sense.
  4. Key Metrics by Star Sign: The user can select from Offensive, Mid-Field and Defensive metrics.
  5. Key Metrics by Zodiac Sign: The user can select from Offensive, Mid-Field and Defensive metrics.

Of course, Tableau dashboards are meant to be interactive and should allow the user to explore their own questions and answers, so please follow this link to go to my Tableau Public and have fun with my dashboard there!

 

 

 

Martin Ding
Author: Martin Ding

Martin earned his Honours degree in Economics at the University of Melbourne in 2011. He has more than 7 years of experience in product development, both as an entrepreneur and as a project manager in robotics at an AI unicorn. Martin is expecting to receive his Master’s degree in Data Science from CU Boulder at the end of 2022. Martin is excited about data and it’s power to transform organizations. He witnessed at first hand of how instrumental data driven decision making (DDDM) was in leading to more team buy-in and insightful decisions. Martin joined the Data School to systematically enhance his knowledge of the tools, methodologies and know-how of Data Analytics and DDDM. When not working, Martin enjoys readings, cooking, traveling and golf. He also thoroughly interested in the practice of mindfulness and meditation.