issues
search
the-data-base
/
nhl-data
Repo for version control the dbt transformations on nhl-breakouts data
5
stars
0
forks
source link
issues
Newest
Newest
Most commented
Recently updated
Oldest
Least commented
Least recently updated
Create an f_team_season table in BigQuery.
#54
nkumar97
opened
2 years ago
0
Features/shifts goals
#53
gavh3
closed
2 years ago
1
Scale out expected goals models for other season, add as a feature in f_player_season
#52
dmf95
opened
2 years ago
0
Feature engineer game state (e.g. 5v5, 4v5) and game state type (e.g. even-strength, powerplay)
#51
dmf95
opened
2 years ago
1
Feature engineer CORSI (CF & CA) by modeling shift data in dbt
#50
dmf95
opened
2 years ago
0
Feature engineering - parse out coordinates to identify the shot angle, distance, and shot area
#49
dmf95
opened
2 years ago
1
Feature engineer Fenwick shots
#48
dmf95
closed
2 years ago
0
Be able to get all of the players on the ice for each shift/play to build metrics like CORSI
#47
gavh3
opened
2 years ago
1
Add partition and cluster keys to live plays and shifts
#46
gavh3
opened
2 years ago
1
Correcting a "whoopsie" - 2 columns with mixed names
#45
dmf95
closed
2 years ago
0
Automatically grant accesses to analytics schemas
#44
gavh3
opened
2 years ago
0
Hotfix/update liveplays
#43
gavh3
closed
2 years ago
0
Remove order by clause to improve query performance
#42
gavh3
closed
2 years ago
0
Bring in new fields from `live_plays` into f_plays
#41
gavh3
closed
2 years ago
0
Primary and secondary assists in f_player_season
#39
dmf95
closed
2 years ago
0
Add docs artifacts to generate GH pages
#38
gavh3
closed
2 years ago
0
Features/assists
#37
dmf95
closed
2 years ago
0
Break-up live_plays into player and team specific features (different granularities)
#36
dmf95
opened
2 years ago
0
Parse primary and secondary assists
#35
dmf95
closed
2 years ago
2
Make github repo for documentation of shiz (private)
#33
dmf95
closed
2 years ago
3
Hotfix/sqlfluff config
#32
gavh3
closed
2 years ago
0
Features/build analytics core
#31
dmf95
closed
2 years ago
1
Remove characters that were causing encoding issues
#30
gavh3
closed
2 years ago
0
Add GitHub action for manual prod runs of dbt project
#29
dmf95
opened
2 years ago
0
Hot fix, sqlfluff for windows
#28
dmf95
closed
2 years ago
2
User & dataset access in GBQ
#27
gavh3
closed
2 years ago
1
Documentation/update readme
#26
gavh3
closed
2 years ago
0
Fix how duplicates are handled with more years of added data
#25
gavh3
closed
2 years ago
0
Features/analytics core
#24
dmf95
closed
2 years ago
2
Add deduplication logic to the intermediate models for players and teams
#23
dmf95
closed
2 years ago
0
dbt tests fail uniqueness due to overlapping teams and players over multiple seasons
#22
gavh3
closed
2 years ago
1
Add scratches xref table to intermediate models
#21
gavh3
closed
2 years ago
0
Game-Player level data for player scratches, intermediate model
#20
gavh3
closed
2 years ago
0
Hotfix/rename fields
#17
gavh3
closed
2 years ago
0
Feature/pull request template
#16
gavh3
closed
2 years ago
0
Add SQLFluff to dbt project to validate SQL formatting before merge
#14
gavh3
closed
2 years ago
0
Add SQLFluff lint to GH actions
#13
gavh3
closed
2 years ago
0
Ingest 2015 season data onwards into BigQuery
#40
dmf95
closed
2 years ago
0
Ingest 2015 season onwards into bigquery
#11
dmf95
closed
2 years ago
0
Build out analytics-intermediate models
#10
dmf95
closed
2 years ago
0
Build out analytics-core models
#9
dmf95
opened
2 years ago
1
Building out analytics/intermediate
#8
dmf95
closed
2 years ago
0
Feature/corresponding model yaml
#7
gavh3
closed
2 years ago
1
Features/analytics documentation
#6
dmf95
closed
2 years ago
0
Enrich the documentation for game_id with extra data
#5
gavh3
closed
2 years ago
0
Add linescore model for accurate scores at the game level
#4
gavh3
closed
2 years ago
0
Features/documentation
#3
dmf95
closed
2 years ago
0
Features/dbt staging
#2
dmf95
closed
2 years ago
2
Dev init
#1
gavh3
closed
2 years ago
0
Previous