FIG. 01 — DEPTH CHART

RUN YOUR REPS. CLIMB THE DEPTH CHART.

Training the next generation of NFL analysts.

Every rep is a read — tape, data, decisions, on real Lions football. 33 lessons · 42 challenges · 5 capstones · ~270K rows.

Take the field

Drive from Analyst to Owner — seven tiers, seven jobs. Click a coach down the field, or snap through the whole drive: each stop shows what you learn and what you ship. Full depth chart →

1ST & 10 · BALL ON OWN 10 TIER 01 — ANALYST

PRACTICE SQUAD

FRONT OFFICE

TIER 01 · Headset + clipboard

Analyst

Pull stats on request. SELECT, WHERE, ORDER BY, aggregates.

YOU'LL WRITE · SQL

SELECT player_display_name, rushing_yards
FROM weekly_stats
WHERE recent_team = 'DET' AND week = 1
ORDER BY rushing_yards DESC;

UNLOCK Start here — clear the run-game drill in The Film Room.

TIER 02 · Stopwatch

Quality Control

Chart the film. JOINs, GROUP BY, comparative reads — tag the plays and time the reps coaches act on.

YOU'LL WRITE · SQL

SELECT s.week, s.result, w.player_display_name, w.receiving_yards
FROM schedules s
JOIN weekly_stats w USING (season, week)
WHERE s.season = 2024 AND w.recent_team = 'DET';

UNLOCK Bank the Analyst drills + the season-recap capstone.

TIER 03 · Whistle

Position Coach

Develop a group. HAVING, ranks, per-player rate stats.

YOU'LL WRITE · SQL

SELECT player_display_name,
       SUM(receiving_yards) / NULLIF(SUM(targets), 0) AS yds_per_target
FROM weekly_stats
WHERE position = 'WR' AND recent_team = 'DET'
GROUP BY player_display_name
HAVING SUM(targets) >= 30
ORDER BY yds_per_target DESC;

UNLOCK Ship a position-group scouting card.

TIER 04 · Call-sheet

Coordinator

Situational calls. Window functions, CTEs, EPA by down.

YOU'LL WRITE · SQL

SELECT week, qtr, epa,
       AVG(epa) OVER (
         ORDER BY game_seconds_remaining DESC
         ROWS BETWEEN 4 PRECEDING AND CURRENT ROW
       ) AS rolling_epa
FROM pbp
WHERE posteam = 'DET' AND down = 4;

UNLOCK Build a 4th-down decision analyzer.

TIER 05 · Visor + headset

Head Coach

Own the game plan. Plotly, scipy, week-over-week trends.

YOU'LL WRITE · PYTHON

import plotly.express as px
fig = px.line(weekly, x="week", y="epa_per_play",
              color="unit", markers=True,
              title="Lions EPA/play — week over week")
fig.show()

UNLOCK Pass the situational-analytics capstone.

TIER 06 · Roster tablet

General Manager

Build the roster. Schema design, scikit-learn, dbt.

YOU'LL WRITE · PYTHON

from sklearn.ensemble import RandomForestRegressor
model = RandomForestRegressor(n_estimators=300)
model.fit(X_train, y_train)        # draft-capital → career value
print(model.score(X_test, y_test))

UNLOCK Ship a draft-pick value model.

TIER 07 · Silver blazer + ring

Owner

Run the franchise. FastAPI + Next.js, end to end, deployed.

YOU'LL WRITE · PYTHON

@app.get("/api/lions/top-receivers")
async def top_receivers(season: int = 2025, limit: int = Query(10, le=50)):
    rows = await db.fetch(TOP_RECEIVERS_SQL, season, limit)
    return {"season": season, "receivers": rows}

UNLOCK Ship the live app. The whole curriculum’s destination.

The front office

The Franchise Why a football-org structure earns its keep.

Two-Minute Setup Postgres + uv + nflverse — a working environment in ~10 minutes.

The Playbook Lessons, drills, capstones — the unlock loop.

Game Day The whole curriculum's destination — Lions analytics, end to end.