Dashboard week 2 day was right up my alley; Sports Day. Being an avid sports fan, and having created multiple sports dashboards, I decided to challenge myself and choose a sport that I had little background knowledge on, so I chose ice hockey. In this blog I am going to take you through the steps I took to get my data from git hub into a dashboard about The Great One, Wayne Gretzky.

Step 1: Find my dataset and any additional data

The first thing I had to do was use the link provided to us by our coaches to find a sports dataset. I downloaded an NHL dataset that contained season-by-season data on the top 25 scorers in NHL history. I decided this would be the dataset I was going to use for the day. But in saying this, the dataset didn’t have any information on whether the player won the championship in that particular season. This meant I had to go and find it and join the information onto my dataset. You can see an image of my Alteryx workflow that I used to join the data together below. 

Step 2: Explore the data

I did some data exploration and decided I wanted to focus on one player; Wayne Gretzky to see what made him so great. I looked at the number of goals he scored, his assist numbers, and the total points he scored. I also explored how he compares to the other top 10 scorers throughout the history of the NHL. 

Step 3: Assemble the dashboard

The last thing to do was assemble the dashboard. This took some time and patience, as the containers can be quite fiddly, especially when dealing with multiple charts, texts, and images. I am quite chuffed with the final outcome. You can view the dashboard at the link below.


The Data School
Author: The Data School