MessageRelay Digital Academy

Data · Intermediate

Warehouse Modeling & dbt

Model star schemas, tests, and documentation in dbt with mentor-reviewed pull requests.

Translate business questions into dimensional models using dbt on BigQuery-compatible sandboxes. You practice staging vs mart layers, write singular tests, and generate docs sites for stakeholders. Korean business calendar quirks (holiday spikes) appear in sample datasets.

₩1,280,000 · 8 weeks · Blended

Request information Refund & Cancellation
Schema diagram sketched on glass board with marker annotations

Included in this cohort

  • dbt Cloud student workspace
  • Dimensional modeling worksheets
  • CI pipeline template for model tests
  • Docs site generation lab
  • Slowly-changing dimension workshop
  • Portfolio PR review with rubric
  • Stakeholder readout rehearsal

Outcomes you can show

  1. Publish a dbt project with 12+ tested models
  2. Defend grain choices in a mock review
  3. Automate freshness checks for two marts
Portrait of So-young Choi

Mentor

So-young Choi

Analytics engineer; led warehouse migrations for a retail cohort in KR.

Common questions

Labs target BigQuery syntax; adapters for Snowflake are discussed in office hours.

Learner notes

"The dbt docs site from week 6 is now linked on my resume. Mentor caught a fan-out join I missed twice."