Level 1 — Analyst
Level 1 · Analyst
Identity. You pull stats on request. You answer factual questions about what happened.
You are the entry-level voice in the room. Someone asks “who led the Lions in rushing in Week 7?” and you have a query and a clean answer in under a minute.
What you’ll learn
Section titled “What you’ll learn”| SQL | Python |
|---|---|
SELECT, WHERE, ORDER BY | pandas basics, read_csv |
LIMIT, DISTINCT | filtering with .loc and boolean masks |
Basic aggregates (SUM, AVG, COUNT, MAX) | simple matplotlib plots |
Capstone
Section titled “Capstone”Lions 2024 season recap notebook. Weekly leaders, defensive standouts, week-over-week changes. One notebook, runnable end to end, with prose between cells explaining what each query tells you.
Unlock criteria
Section titled “Unlock criteria”To advance to Level 2:
- Clear 8 of 10 stat-lookup challenges below.
- Ship the season recap notebook with at least one chart per category (offense, defense, special teams).
Lesson plan
Section titled “Lesson plan”Lessons run in order. Each one is 5-10 minutes.