Video Tutorial: Creating a Shot Visualization Tool

The primary goal with this video tutorial is to show that shot tracking and shot plotting doesn’t have to be that complicated.

The visualization is created in Excel, because it’s what I know, but also because Excel is less intimidating to most people. The end goal is to get more people interested in hockey statistics!

Video 1: Tracking Shots

In the first video I talk about An Nguyen’s shot plotter, and I recommend everybody to give it a look – It’s an amazing tool: https://shot-plotter.netlify.app/

Video 2: Data Preparation

If you want to follow along in Excel, you can download the starting file here: https://hockeystatisticscom.files.wordpress.com/2022/08/shot-viz-tutorial-2.xlsx

Video 3: Graphic Design

If you want to follow along in Excel, you can download the starting file here: https://hockeystatisticscom.files.wordpress.com/2022/08/shot-viz-tutorial-3.xlsx

Video 4: Creating Shot Plots

If you want to follow along in Excel, you can download the starting file here: https://hockeystatisticscom.files.wordpress.com/2022/08/shot-viz-tutorial-4.xlsx

Video 5: Finalizing the Viz

If you want to follow along in Excel, you can download the starting file here: https://hockeystatisticscom.files.wordpress.com/2022/08/shot-viz-tutorial-5.xlsx

You can download the final shot visualization tool here: https://hockeystatisticscom.files.wordpress.com/2022/08/shot-visualization-tool-final.xlsx

In case you’re interested in tracking your own data, but need some help setting it up, then feel free to reach out. I will gladly help out. You can contact me on Twitter or via email: hockeystatistics.com@gmail.com

Finally… if you like my work, please consider buying a copy of my book for 5$: https://hockeyskytte.gumroad.com/l/Hockey-Statistics

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: