Gem Logic AI

🏀 NBA Causal Intelligence

SQL Sports NBA Multi-Entity Prescriptive

Overview

NBA game, season, draft, and career data spanning 1996–2023 from a 2.2 GB SQLite database. The logic engine interrogates 61,000+ game records across six diagnostic dimensions to trace exactly why a game or career turned.

Data Structure

EntityRecordsWhat It Captures
TeamGame61,000Per-game team performance: scoring, shooting, rebounds, turnovers
TeamSeason772Aggregated season records: win rates, offensive/defensive ratings
DraftPick1,656Draft record + career outcome: busts, overperformers, steals
PlayerCareer1,941Career summary: undrafted stars, journeyman patterns

Causal Reasoning Model

17 cause types across six diagnostic dimensions:

Sample Questions

Prescriptive Recommendations

Ask what to do: get action recommendations with cost-benefit analysis. The engine recommends shooting drills for teams with scoring collapses, turnover reduction programs for sloppy play, and defensive scheme changes for teams allowing too many points.

Try It

Ask Gem Logic: What fraction of TeamGames are anomalous, and what are the main root causes?

Start Session →