- 50
- 725
Data Punk
Registrace 22. 10. 2017
We love hockey, analytics and data science. So, this channel focuses on educational topics around hockey analytics and AI. We publish weekly long-form newsletters on www.datapunkhockey.com and publish companion quick-hit, how-to videos here on CZcams.
If you have feedback, ideas for topics or generally have questions, reach out anytime via our Contact Page: www.datapunkhockey.com/contact-us/.
If you have feedback, ideas for topics or generally have questions, reach out anytime via our Contact Page: www.datapunkhockey.com/contact-us/.
Building the Perfect Win Prediction Model for Hockey
In this week's quick-hit video, we introduce you to the concept of AutoML (or Automated Machine Learning), where you can automate your model-building process and let the software do the work of creating and ranking the best models. In this video, we'll walk through how to create "the perfect" win prediction model by using H2O.ai, an AutoML platform. Be sure to check out the accompanying newsletter at datapunkhockey.com/build-a-perfect-predictive-model. And sign up at datapunkhockey.com for weekly content, courseware and more on all things Hockey Analytics.
zhlédnutí: 8
Video
Predict Wins in Hockey with SVM
zhlédnutí 4Před 14 dny
In the fifth in our AI and Hockey Analytics series, this week we introduce you to the Support Vector Machine (SVM) algorithm and walk through how to predict wins in hockey using this machine learning technique. You can also check out the accompanying newsletter at datapunkhockey.com/predict-wins-using-svm-models. Also, sign up for weekly content on all things hockey analytics at datapunkhockey....
Predict Which NHL Teams Win using Logistic Regression Models
zhlédnutí 3Před 21 dnem
In this quick-hit video, we'll introduce you to the Logistic Regression model, which you can use to predict which NHL team will win a game. It's a relatively simple model to implement, and we demonstrate building a model using five input statistics to build a model that is 70% accurate. You can get the data and R code in our weekly newsletter accompaniment at www.datapunkhockey.com/predict-wins...
Find the Top NHL Snipers using a K-means Cluster Analysis
zhlédnutí 6Před 28 dny
In this quick-hit video, we'll demonstrate how you can discover the top ten NHL snipers using a K-means cluster. K-means clustering is a simple clustering technique that discovers groups (or k clusters) using an unsupervised machine learning technique. It's versatile, and you can use the code and dataset we provide to experiment with different clustering scenarios. To get the dataset and R code...
Final NHL 2024 Draft Prospect Analysis: Analyzing the Top 50 Prospects
zhlédnutí 35Před měsícem
This is the final part in a six-week series that explores the draft prospects for the NHL 2024 draft. In this week's quick-hit video, we'll rank the top fifty prospects across offense, defense and goaltending. We'll then map a sample of NHL teams to prospects. We'll continue to reference the Elite Prospects Draft 2024 Guide, which you can use with your reports to get additional commentary, rati...
Analyzing the Top 50 NHL Draft Prospects
zhlédnutí 14Před měsícem
This is the fifth part of our six-week series in preparing for the NHL 2024 Draft. In this quick-hit video, we'll provide you with a dataset for the top 50 prospects for the 2024 NHL draft and walk you through how to create an Exploratory Data Analysis and Power BI dashboard. You can then use these as companion tools to the Elite Prospects NHL 2024 Draft Guide The accompanying newsletter for th...
NHL 2024 Draft Prospect Analysis: Best Offense, Defense & Goaltending
zhlédnutí 6Před měsícem
This quick-hit video walks through how to analyze the NHL Draft 24 Prospects by doing data discovery in Microsoft Excel and building a Draft Prospect Dashboard in Power BI. You can also check out the accompanying newsletter at: www.datapunkhockey.com/analyzing-incoming-nhl-draft-prospects. Subscribe today for free to access and receive regular hockey analytics content!
Preparing for the NHL 2024 Draft: Analyzing Strong and Weak Teams
zhlédnutí 8Před 2 měsíci
This is our third week in a six-week series of videos and newsletter to prepare you for the NHL 2024 draft. In this week's quick-hit video, we'll walk you through three different analyses to show the relative performance of NHL teams. The first is using Pivot tables to explore trends across seasons and trends at the team level. The second analysis is using a web-based tool called Data Wrapper t...
Preparing for the NHL 2024 Draft: Team Stats Data Discovery using Microsoft Excel
zhlédnutí 13Před 2 měsíci
This is the second quick-hit video in our six week series on preparing for the NHL 2024 Draft. In this week's video and newsletter accompaniment, we cover how to do data discovery using Microsoft Excel. We specifically cover sorting, filtering, conditional formatting, and PivotTables. You can also check out the newsletter for more details here: www.datapunkhockey.com/data-discovery-for-nhl-draf...
Create a Draft Analysis for the Upcoming NHL 2024 Draft
zhlédnutí 18Před 2 měsíci
The NHL 2024 Draft will be held on June 28-29, but will you be ready? In this video, we introduce our six-week Data Analyst series that will prepare you to create a Team and Prospect Analysis. Through weekly newsletters and video quick-hit accompaniments, we'll provide team and prospect datasets, teach you how to assess the strengths and weaknesses of teams and evaluate the incoming 2024 class ...
How to Create a No Code Playoff Dashboard using Power BI
zhlédnutí 7Před 3 měsíci
The 2023-2024 NHL Playoffs are officially underway. If you want to create your very own playoff dashboard to track the progress of your favorite team, then this quick-hit video is for you. The newsletter accompaniment to this quick-hit video is here: www.datapunkhockey.com/how-to-create-a-no-code-playoff-dashboard/. Subscribe here and at datapunkhockey for all the latest content on hockey analy...
Introduction to Hockey Analytics: Advanced Topics
zhlédnutí 18Před 3 měsíci
This course provides a series of lectures for those who are interested in learning about the world of hockey analytics. This 2-hour course is ideal for the hobbyist or enthusiast who wants to learn more about the analytical side to hockey. This is the ninth lecture, which covers advanced topics such as correlation analysis and regression modeling. For more hockey analytics content and tutorials...
Introduction to Hockey Analytics: Refreshing the Data in the Dashboard
zhlédnutí 8Před 3 měsíci
This course provides a series of lectures for those who are interested in learning about the world of hockey analytics. This 2-hour course is ideal for the hobbyist or enthusiast who wants to learn more about the analytical side to hockey. This is the eighth lecture, which covers different ways to refresh the hockey data in the Power BI dashboard. For more hockey analytics content and tutorials...
Introduction to Hockey Analytics: Dashboard Design and Creation
zhlédnutí 11Před 3 měsíci
This course provides a series of lectures for those who are interested in learning about the world of hockey analytics. This 2-hour course is ideal for the hobbyist or enthusiast who wants to learn more about the analytical side to hockey. This is the seventh lecture, which covers how to design, create and deploy your hockey analytics dashboard. For more hockey analytics content and tutorials, ...
Introduction to Hockey Analytics: Sourcing Hockey Data
zhlédnutí 39Před 3 měsíci
This course provides a series of lectures for those who are interested in learning about the world of hockey analytics. This 2-hour course is ideal for the hobbyist or enthusiast who wants to learn more about the analytical side to hockey. This is the sixth lecture, which covers how you can source hockey data for your hockey analytics project. For more hockey analytics content and tutorials, ch...
Introduction to Hockey Analytics: Core Hockey Statistics
zhlédnutí 15Před 3 měsíci
Introduction to Hockey Analytics: Core Hockey Statistics
Introduction to Hockey Analytics: Overview of the Conceptual Architecture
zhlédnutí 5Před 3 měsíci
Introduction to Hockey Analytics: Overview of the Conceptual Architecture
Introduction to Hockey Analytics: Introduction to Microsoft Power BI
zhlédnutí 11Před 3 měsíci
Introduction to Hockey Analytics: Introduction to Microsoft Power BI
Introduction to Hockey Analytics: Required Software
zhlédnutí 14Před 3 měsíci
Introduction to Hockey Analytics: Required Software
Introduction to Hockey Analytics: Course Lectures & Overview
zhlédnutí 24Před 3 měsíci
Introduction to Hockey Analytics: Course Lectures & Overview
Create a Playoff Preview Dashboard using Power BI in Three Easy Steps!
zhlédnutí 7Před 3 měsíci
Create a Playoff Preview Dashboard using Power BI in Three Easy Steps!
Build a No Code Playoff Preview Dashboard using Power BI
zhlédnutí 10Před 3 měsíci
Build a No Code Playoff Preview Dashboard using Power BI
How to Create a Fantasy Hockey DFS Projections Report in 3 Steps!
zhlédnutí 11Před 4 měsíci
How to Create a Fantasy Hockey DFS Projections Report in 3 Steps!
Overview Of Data Storytelling for Hockey Analytics (Three Steps for Amazing Stories)
zhlédnutí 19Před 5 měsíci
Overview Of Data Storytelling for Hockey Analytics (Three Steps for Amazing Stories)
How to Create a Goaltender Dashboard in Power BI (No-Code and Free Data)
zhlédnutí 9Před 5 měsíci
How to Create a Goaltender Dashboard in Power BI (No-Code and Free Data)
How to Create an Enforcer Dashboard in Microsoft Power BI
zhlédnutí 25Před 6 měsíci
How to Create an Enforcer Dashboard in Microsoft Power BI
How to Create Social Media Content using the Enforcer Index Statistic
zhlédnutí 8Před 6 měsíci
How to Create Social Media Content using the Enforcer Index Statistic
Bring the Power of Predictive Models to Power BI
zhlédnutí 22Před 6 měsíci
Bring the Power of Predictive Models to Power BI
Build a Complete Shot Analysis Dashboard in Power BI!
zhlédnutí 14Před 6 měsíci
Build a Complete Shot Analysis Dashboard in Power BI!
Anybody Can Predict Goals using Linear Regression
zhlédnutí 18Před 6 měsíci
Anybody Can Predict Goals using Linear Regression
This is really cool!
Is this downloadable
Yes. Check out this page: www.datapunkhockey.com/the-barn-beta/ for the page and this link for the report: hockeystatsdatapipe.blob.core.windows.net/nl28shotanalysis/shot_analysis_dashboard_v3.pbix.
Promo*SM 💖
link of data?
We use a paid data provider (mysportsfeeds.com), but go to www.nhl.com/stats/teams and query the data for multiple seasons and download/combine the CSV files (non-commercial use I believe) to get a similar dataset. You can use Python code as follows to combine the CSV files: import pandas as pd import os folder_path = '/folder_path_to_csvs' dataframes_list = [] csv_files = [file for file in os.listdir(folder_path) if file.endswith('.csv')] for csv_file in csv_files: file_path = os.path.join(folder_path, csv_file) df = pd.read_csv(file_path, index_col=None) dataframes_list.append(df) combined_dataframe = pd.concat(dataframes_list, axis=0, ignore_index=True) combined_csv_path = os.path.join(folder_path, 'combined.csv') combined_dataframe.to_csv(combined_csv_path, index=False) FYI: Full write-up of the post that accompanies the video is here: www.datapunkhockey.com/power-bi-team-summary/.