Court Geometry
Analytics Views
Playbook for the 14 analytics_ outputs that pre-join common analytical workflows
Analytics Views
Analytics views are the warehouse fast break: pre-joined analytics_* outputs that trade a little duplication for a much faster first read in notebooks, dashboards, and exploratory SQL.
Use analytics views when the question is familiar and speed matters more than
reconstructing the entire possession chain yourself. Drop to facts or agg_
tables only when you need a different grain or a field these views
intentionally leave behind.
How to use this page
- Start here for the first read when the workflow is common and the model already has a packed convenience surface.
- Check the row grain before using a view as a downstream source; convenience does not change the underlying grain.
- Drop down deliberately to Facts & Bridges or Derived Aggregations when you need more detail or a different summary boundary.
Quick navigation
Choose a view fast
Start with View chooser when you know the
workflow but not the exact analytics_ object.
Read each view surface
Jump to View scouting reports for a one-card explanation of what each analytics view includes and when to trust it.
Know when not to use them
Go to
When not to use an analytics view
when you suspect the fast-break surface is hiding too much detail.
Finish on exact contracts
Use Star Reference for exact schema-backed columns after you choose the right view family here.
All views at a glance
Core workflow views
| View | Row grain | What it already packs together | Best first use |
|---|---|---|---|
analytics_player_game_complete | one player-game row | player-game stat families plus player, team, and game context | notebook exploration, player game logs, quick dashboards |
analytics_player_season_complete | one player-season row | season totals, averages, and per-minute normalizations | leaderboard work and player season comparison |
analytics_team_season_summary | one team-season row | team summary metrics, standings, and team context | season snapshots, standings overlays, team comparison |
analytics_team_game_complete | one team-game row | team-game traditional, advanced, misc, hustle, and tracking stats with team and game context | team game logs, club performance analysis |
analytics_head_to_head | one team-opponent summary row | opponent results and scoring margin context | rivalry, matchup prep, and opponent scouting |
analytics_game_summary | one game row with both teams | game result, team context, and bridge_game_team side information | game recap, schedule analysis, result dashboards |
Specialized analysis views
| View | Row grain | What it already packs together | Best first use |
|---|---|---|---|
analytics_clutch_performance | one player-clutch-split row | clutch stat splits with player and team context | clutch-time analysis, pressure performance ranking |
analytics_player_general_splits | one player-season-split row | player general splits with season-overall baselines and delta columns | home/away, rest, month, and win/loss split analysis |
analytics_player_matchup | one player-matchup row | player-vs-player matchup stats with player and team context | defensive matchup study, assignment analysis |
analytics_shooting_efficiency | one shot-chart row with league context | shot chart detail joined with league-average zones, player and game context | shot quality analysis, zone comparison to league baseline |
analytics_player_impact | one player-season impact row | on/off splits combined with season aggregates and player/team context | player value analysis, on-court impact measurement |
analytics_draft_value | one draft-pick row with career context | draft facts joined with career aggregates and player identity | draft class evaluation, pick value analysis |
analytics_league_benchmarks | one league-season benchmark row | player and team season aggregates for league-wide percentile context | league-wide comparison, percentile ranking, baseline setting |
analytics_team_general_splits | one team-season-split row | team general splits with season-overall baselines and delta columns | schedule-context, home/away, and rest split analysis |
View chooser
| If you want... | Start here | Why it clears space |
|---|---|---|
| Single-game player analysis | analytics_player_game_complete | Multiple player-game fact families plus player, team, and game context land in one row set |
| Single-game team analysis | analytics_team_game_complete | Team-game stats across traditional, advanced, hustle, and tracking in one surface |
| Season leaderboards and rate comparisons | analytics_player_season_complete | Totals, averages, and per-minute normalizations stay together |
| Team snapshots with standings context | analytics_team_season_summary | Team rollups and standings move in the same possession |
| Game recap with both teams | analytics_game_summary | Game result with both team sides already joined |
| Rivalry or opponent scouting summaries | analytics_head_to_head | Team-vs-team results and scoring margins are already grouped for you |
| Clutch-time performance | analytics_clutch_performance | Clutch splits with player and team context pre-joined |
| Player context split deltas | analytics_player_general_splits | General split rows already carry season-overall baselines and deltas |
| Defensive matchup study | analytics_player_matchup | Player-vs-player matchup stats already shaped for comparison |
| Shot quality vs league baseline | analytics_shooting_efficiency | Shot chart detail with league-average zone context pre-joined |
| Player on-court impact | analytics_player_impact | On/off splits and season aggregates with player identity in one surface |
| Draft class evaluation | analytics_draft_value | Draft facts joined with career outcomes for pick-value analysis |
| League-wide percentile context | analytics_league_benchmarks | Season-level player and team aggregates for benchmarking |
| Team context split deltas | analytics_team_general_splits | Team split rows already carry season-overall baselines and deltas |
View scouting reports
Core workflow views
analytics_player_game_complete
The all-purpose player-game read: traditional, advanced, misc, hustle, and tracking stats joined with player, team, and game context.
Best when: you want one player-game row with most common context already attached.
analytics_player_season_complete
A season dossier for player comparison: totals, averages, and per-36/per-48 normalization in one place.
Best when: you are ranking players, building season dashboards, or comparing volume to rate stats.
analytics_team_game_complete
Team-game stats across traditional, advanced, misc, hustle, and tracking families joined with team and game context.
Best when: you want one team-game row with box-score families already packed together.
analytics_team_season_summary
Team-season summary that layers season rollups with standings and team context.
Best when: you need quick team snapshots, standings overlays, or year-over-year club comparison.
analytics_head_to_head
Opponent scouting summary that condenses team-vs-team outcomes and scoring margins.
Best when: you want rivalry, matchup, or opponent-prep reporting without rebuilding the join yourself.
analytics_game_summary
Game recap surface with game result, both teams via bridge_game_team, and team context.
Best when: you need a schedule view, result dashboard, or quick game recap with both sides.
Specialized analysis views
analytics_clutch_performance
Clutch stat splits joined with player and team context from fact_player_clutch_detail.
Best when: you are studying pressure-situation performance or ranking clutch-time contributors.
analytics_player_general_splits
Player dashboard split rows enriched with player identity plus season-overall baselines and deltas for fast context analysis.
Best when: you want quick home/away, rest, month, or win/loss split comparisons without rebuilding the overall baseline join.
analytics_player_matchup
Player-vs-player matchup data joined with player identity and team context.
Best when: you need defensive assignment analysis or head-to-head player comparison.
analytics_shooting_efficiency
Shot chart detail with league-average zone baselines, player identity, and game context.
Best when: you want shot quality analysis relative to league expectations by zone.
analytics_player_impact
On/off split data combined with season aggregates and player/team identity.
Best when: you are measuring a player's on-court impact via plus/minus and differential metrics.
analytics_draft_value
Draft pick facts joined with career aggregate outcomes and player identity.
Best when: you are evaluating draft class performance, pick value, or prospect-to-career pipelines.
analytics_league_benchmarks
Season-level player and team aggregates providing league-wide baselines and percentile context.
Best when: you need a benchmarking surface for league-wide comparison or percentile ranking.
analytics_team_general_splits
Team dashboard split rows enriched with team identity plus season-overall baselines and deltas for quick context reads.
Best when: you need team home/away, rest, or month splits compared to the club's overall season line.
Common entry questions
| If the analyst says... | Best opening move | Why |
|---|---|---|
| "Just give me the complete player game row." | analytics_player_game_complete | It eliminates most manual player/team/game joins on day one |
| "Show me the team's box score for that game." | analytics_team_game_complete | Team-game stats across all families are already packed |
| "I need a player season comparison table now." | analytics_player_season_complete | Totals, averages, and rate views are already aligned |
| "Show me the team season picture with standings context." | analytics_team_season_summary | Summary and standings logic travel together |
| "Give me a game recap with both teams." | analytics_game_summary | Game result and both-team context are already joined |
| "How have these two teams played each other?" | analytics_head_to_head | Opponent-focused summary work is already shaped for that question |
| "Who performs best in clutch time?" | analytics_clutch_performance | Clutch splits and player context are pre-joined |
| "Who was guarding whom and how did it go?" | analytics_player_matchup | Matchup stats with player identity already assembled |
| "Compare this player's shooting to league averages." | analytics_shooting_efficiency | Shot detail with zone-level league baselines already packed |
| "What is this player's on-court impact?" | analytics_player_impact | On/off splits and season aggregates in one surface |
| "How did that draft class turn out?" | analytics_draft_value | Draft picks joined with career outcomes |
| "Where does this player rank league-wide?" | analytics_league_benchmarks | League-wide aggregates for percentile context |
When not to use an analytics view
| Situation | Better choice | Why |
|---|---|---|
| You need event-by-event tape | Facts | Analytics views intentionally sit above atomic event grain |
| You need a reusable rollup, not a denormalized read | Derived Aggregations | agg_ tables keep the summary at its natural aggregated grain |
| You are validating exact schema-backed columns | Star Reference | The generated tier page is the contract surface |
Common drop-down targets
| Starting view | Drop down when... | Likely next stop |
|---|---|---|
analytics_player_game_complete | you need a specific player-game stat family field or finer event detail | fact_player_game_*, fact_play_by_play, or fact_shot_chart |
analytics_team_game_complete | you need finer team-game detail or individual player breakdown | fact_team_game, team box-score variants, or player-game facts |
analytics_player_season_complete | you need custom split logic or a missing player summary component | player profile/splits facts or agg_player_* tables |
analytics_team_season_summary | you need a different team-season rollup or deeper game-level detail | agg_team_* tables or team-game facts |
analytics_game_summary | you need event-level detail or individual player lines | fact_play_by_play, fact_player_game_traditional, or fact_rotation |
analytics_head_to_head | you need atomic game rows behind the rivalry summary | dim_game, fact_team_game, and supporting dimensions |
analytics_clutch_performance | you need raw clutch splits or different clutch-window definitions | fact_player_clutch_detail |
analytics_player_matchup | you need shot-level detail on defensive matchups | fact_player_matchups_detail or fact_player_matchups_shot_detail |
analytics_shooting_efficiency | you need raw shot coordinates or custom zone logic | fact_shot_chart, dim_shot_zone |
analytics_player_impact | you need granular on/off splits or custom differential calculations | agg_on_off_splits, agg_player_season |
analytics_draft_value | you need combine data or per-season career breakdowns | fact_draft, fact_draft_combine_detail, fact_player_career |
analytics_league_benchmarks | you need player-level or team-level detail behind the benchmarks | agg_player_season, agg_team_season |
See also: Data Dictionary Glossary for stat term definitions, Field Reference for column naming patterns.
Keep moving
Stay in the same possession
Keep the mental model warm with adjacent pages, section hubs, and search-friendly routes into the same topic cluster.
