M1 | L2 - Show Me the Data

In this lesson, we'll introduce you to a key source where you can download and analyze NHL prospect data.


Getting the NHL Prospect Data

If you're like us, you're always on the hunt for good sports data sources. Unfortunately, free ones come and go and paid ones require a commitment. And hockey is no different from other sports.

Further, getting comprehensive data at the minor league level is no easy task. A good start, though, is Elite Prospects (EP).

🏒
Online since 1999, Elite Prospects is a statistical hockey resource. They offer their customers an informative hockey player database on the web across a wide variety of leagues.

EP has a ton of hockey data and information with coverage that extends well beyond the NHL. Getting access to the data API is not easy, but with a bit of 'copy and paste' you can quickly get some summary data into a spreadsheet and get busy analyzing.

⚖️
With any data source, always be aware of their licensing rules. Some sites, such as Hockey Reference, simply require referencing them when you publish your content. Other sites are less forgiving.

The EP Draft Report

Each year, Elite Prospects distills their scouting reports into a single NHL Draft guide that includes quantitative and qualitative ratings of the top prospects. For the hockey nerd, it's an amazing source of information for the incoming prospects.

Elite Prospects 2025 Draft Prospectus.

However, if you wanted to distill their data and reporting into a single, ranked list and then do your own analysis, you need to get the data into a spreadsheet so you can do the analysis. The EP Draft Center is a good first step to get updated statistics on NHL prospects for such an analysis.

Manual Copy and Paste from EP to Excel
You can save yourself the hassle of the copy, paste and transformation and download the sample dataset for this module from here.

About the Data

The unit of observation in the dataset (rows) are players, and we've captured the top 100 players from the EP site (inclusive of forwards, defensemen and goalies). The variables (columns) are a mix of player metadata (such as Nationality, Name, etc.) and statistics (raw and calculated). Unfortunately, minor league player stats are not as comprehensive as the NHL's statistics, but you can do quite a bit with just a handful of raw statistics.

👨‍💻
Note that this was a one-off manual copy and paste of data from the EP site into a formatted spreadsheet. We do not like doing this nor would we recommend it as a best practice; it's time-consuming, cumbersome and error-prone. Ideally, you'd have access to a site's APIs or in the least could Web scrape the data using a bit of code. For more information on different ways to source data for your project, see this article.

Once you have your data downloaded, you are now ready to move on to the next phase: conducting your analysis.


What Now?

With a clean dataset now in hand, you are ready to do an analysis. Keep in mind that this dataset is a 'snapshot', so it's a point-in-time view of the prospect data. If you want to have an updated or daily view on the prospects, then you'd need to build a predictable data pipeline; however, since we're doing a one-off story, it's okay that this is a snapshot.

Okay, on to the next step.

👉 Up Next? Lesson 3: Stats and Methodology

You've successfully subscribed to Data Punk Media
Great! Next, complete checkout for full access to Data Punk Media
Welcome back! You've successfully signed in.
Unable to sign you in. Please try again.
Success! Your account is fully activated, you now have access to all content.
Error! Stripe checkout failed.
Success! Your billing info is updated.
Error! Billing info update failed.