search

the-data-base / nhl-data

Repo for version control the dbt transformations on nhl-breakouts data
5 stars 0 forks source link

Build Zone stats data from f_plays & d_location #58

Open dmf95 opened 2 years ago

dmf95 commented 2 years ago

Cannot be completed until: https://github.com/bicks-bapa-roob/dbt-nhl-breakouts/issues/57 is completed Delay until version 1.1.0 of the XG Model, biggest feature here will be rush_shot

Image

AC

Metric Definition
TOI/GP Time on ice per game played
TOI% Percentage of available team minutes played: TOI / total team TOI
OZS Offensive zone starts
NZS Neutral zone starts
DZS Defensive zone starts
OTF On-the-fly zone starts
OZS% Percentage of zone starts in the offensive zone: OZS / (OZS + NZS + DZS + OTF)
NZS% Percentage of zone starts in the neutral zone: NZS / (OZS + NZS + DZS + OTF)
DZS% Percentage of zone starts in the defensive zone: DZS / (OZS + NZS + DZS + OTF)
OTF% Percentage of zone starts that were on-the-fly: OTF / (OZS + NZS + DZS + OTF)
OZF On-ice faceoffs in the offensive zone
NZF On-ice faceoffs in the neutral zone
DZF On-ice faceoffs in the defensive zone
OZF% Percentage of on-ice faceoffs in the offensive zone: OZF / (OZF + NZF + DZF)
NZF% Percentage of on-ice faceoffs in the neutral zone: NZF / (OZF + NZF + DZF)
DZF% Percentage of on-ice faceoffs in the defensive zone: DZF / (OZF + NZF + DZF)
Ice_F On-ice icings for (“for” is a player’s team iced the puck while they were on the ice)
Ice_A On-ice icings against (“against” is a player’s opposing team iced the puck while they were on the ice)
Ice% On-Ice Icings Against Percentage: Ice_A / (Ice_A + Ice_F)