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
Hockey-Statistics 