Level 4 — General manager
Level 4 · General manager
Identity. Roster construction, multi-year strategy, draft and free agency.
You stop running individual analyses and start building systems that produce predictions. Schema design matters. Feature engineering matters. Train/test discipline matters.
What you’ll learn
Section titled “What you’ll learn”| SQL / Data | Python / ML |
|---|---|
| Schema design and normalization | scikit-learn pipelines |
| Indexing and query optimization | feature engineering for tabular data |
| dbt basics (models, refs, tests) | model evaluation: holdout, cross-validation, baselines |
Capstone
Section titled “Capstone”Draft pick value model. Predict career Approximate Value from college production, combine numbers, and draft position. Train on 2000-2020, test on 2021-2023, project the 2025 Lions class.
Unlock criteria
Section titled “Unlock criteria”A predictive model with:
- Documented features and the rationale behind each
- A real held-out test set (no leakage)
- A baseline comparison (e.g., draft-position-only model)
- A one-page writeup of model performance, feature importance, and the 2025 projections