Skip to main content

Module 5: Intermediate Models Slides

Slide walkthrough for Module 5 of Production Analytics Engineering with dbt: Metrics, Semantic Layers & Lineage: Build reusable transformation steps...

This slide page is the visual review companion for the full course module. Use it to recap the architecture, examples, exercises, production warnings, and takeaways after reading the lesson.

Slide Outline

  1. Intermediate Models - Build reusable transformation steps without exposing half-finished business tables.
  2. Learning Objectives - 3 outcomes for this module
  3. Why This Module Matters - Intermediate models hold reusable transformation logic that is too complex for staging but not final enough for business
  4. The Mental Model - Lesson section from the full module
  5. Tiny Example - Lesson section from the full module
  6. Interactive Check - Lesson section from the full module
  7. Inline Practice Lab - Lesson section from the full module
  8. Self-Check Quiz - Lesson section from the full module
  9. Real-World Use Cases - Reliable executive dashboards that do not disagree across teams, AI analytics agents that query governed metrics instead of guessing SQL
  10. Common Mistakes to Avoid - 3 mistakes covered
  11. Production Notes - 1 practical notes
  12. Inline Exercises - 1 inline exercise
  13. Key Takeaways - 3 points to remember

Learning Objectives

  • Know when to create an intermediate model
  • Separate reusable logic from final reporting shape
  • Reduce duplication across marts

Why This Module Matters

Intermediate models hold reusable transformation logic that is too complex for staging but not final enough for business users.

Production Notes

  • Intermediate models are useful, but too many create a maze. Each one should remove real duplication or clarify complex logic.

Common Mistakes

  • Creating intermediate models for every tiny SELECT
  • Letting BI tools query intermediate models directly
  • Hiding important business definitions without documentation

Key Takeaways

  • Intermediate models reduce repeated business logic
  • They should usually not be consumed directly by BI users
  • Good naming makes hidden transformation steps easier to debug

Inline Exercises

  1. Extract Shared Logic

    Move repeated refund and order status logic into one intermediate model.

    30-45 minutes - Beginner to Intermediate

    • Find duplicated CASE expressions
    • Create int_order_status_enriched
    • Point downstream marts to the intermediate model
    • Explain what duplication disappeared

    Inline lab: complete the exercise directly in the course page.

Read the full module | Back to course curriculum