dbt Model Builder

Create complete dbt models for the Fantasy Football Analytics project following Kimball dimensional modeling and the 2×2 stat model (actuals/projections × real-world/fantasy).

When to Use This Skill

Use this skill proactively when:

• Creating new dbt models (staging, core, marts)
• User asks to "create a model for {entity/process}"
• User mentions dbt modeling, dimensional modeling, or Kimball patterns
• Adding analytics-ready views or transformations
• Implementing 2×2 model quadrants (actuals/projections, real-world/fantasy scoring)

dbt Modeling Approach

The FF Analytics project follows: