Module Delivery Pattern — Five-Step Cheat Sheet

One-page reference for trainers

TRAINER ONLY

One-page reference for trainers. Every main-day module (0–7) and optional modules (8–9) follow the same five-step rhythm.

Related: facilitator-guide.qmd · pre-class-checklist.qmd · reflection-prompts.qmd


The five steps

Step Name Typical time Trainer action
1 Animation 2–4 min Play mod-XX-*.mp4 (or narrate story beat if MP4 pending)
2 Think & Discuss 5–12 min Use reflection-prompts.qmd for questions + trainer answers; whiteboard 3–5 bullets
3 Theory 10–20 min Teach concept from module §3; link to trainee discussion answers
4 Quiz 2–3 min Share Google Form (multiple choice, auto-scored)
5 Practice Remainder Hands-on exercises — Module 7 uses heading Practice — Open Discussion (same step, different label)

Module 7 naming: Step 5 is still practice for that module — trainee-led tool comparison replaces a coding lab. The page heading reads ## 5. Practice — Open Discussion so the five-step pattern stays consistent.

Bridge phrase (after Step 2):

“You mentioned [X]. Let’s see how the industry handles that.”


Module timing (main day)

Module Total Anim Discuss Theory Quiz Practice
Story Welcome 30 3 12 10 3 2
1 Fundamentals 35 3 8 12 3 9
2 Databricks 75 3 7 15 3 47
3 Snowflake 75 3 7 15 3 47
4 dbt 75 3 7 15 3 47
5 Production 45 3 7 15 3 17
6 AI Features 45 3 7 15 3 17
7 Wrap-up 30 3 5 5* 17†

*Module 7 theory: Objectives + Power BI notes + When to Use What only. Deep dive is self-study.

†Module 7 step 5 heading: Practice — Open Discussion (open-discussion-guide.qmd). Module 7 has no separate Quiz — the silent write + discussion replaces it.

Protect lab time: Modules 2–4 are the core — shorten discussion before cutting practice.


Environment readiness — Step 5 prep

Before releasing trainees to Practice (Step 5), the co-trainer should verify the correct portal is open and accessible for each attendee. This prevents the first 5 minutes of lab time being lost to environment issues.

All infrastructure must be provisioned before class — see pre-class-checklist.qmd and facilitator-guide.qmd §Pre-class infrastructure setup.

Module Platform portal Attendee should have Co-trainer verifies
2 Databricks Databricks Workspace Browser tab with sidebar visible; cluster started (green dot) Compute page — all attendee clusters show Running; both trainers ran Git → Pull on MHP-DE-Workshop-2026 (Step 3b)
3 Snowflake Snowsight Own trial account created; 00_account_setup.sql run; DE_MASTERCLASS database exists; DE_WORKSHOP_ROLE selected Walk around — confirm each attendee completed trial signup and setup; SAS token distributed
4 dbt Terminal (Codespaces or Docker) dbt_project/ directory; profiles.yml configured with DE_MASTERCLASS + DE_WORKSHOP_ROLE; dbt debug --target snowflake passing Walk around — check terminals for green All checks passed!
5 Production Databricks Jobs & Pipelines + Snowsight Jobs & Pipelines page accessible (formerly Workflows → Delta Live Tables; renamed to Lakeflow Declarative Pipelines); Snowflake Task SQL ready Pre-create one Lakeflow pipeline demo; TASK_HISTORY() returns data
6 AI Features Snowsight + Databricks Worksheets for Cortex SQL; Genie page accessible in Databricks (under SQL section) Test AI_COMPLETE query; Genie space loads
8 Streaming Databricks + Snowsight Cluster with Kafka libs; Aiven topic active Compute → Libraries tab shows Kafka jars; producer logs show events
9 ML Databricks AI/ML → Experiments + Snowsight AI/ML → Experiments page; ML.FORECAST worksheet ready USE AI FUNCTIONS privilege + CORTEX_USER role; ML Runtime cluster available

Transition phrase (after confirming environment):

“Everyone has [portal name] open? Great — let’s start with Step 1.”

If environment check fails for multiple attendees: Extend the Theory section by 5 minutes while the co-trainer resolves issues. Never cut Practice time for environment fixes.


Priya / Power BI thread

Priya builds the dashboard in parallel with Bob’s pipeline work — not a single end demo.

After module Dashboard beat
2 Databricks Overview charts — trips by hour/day
3 Snowflake Map — borough and zones
4 dbt Revenue, payments, quality scorecard
7 Wrap-up Full five-page walkthrough

Trainees build Gold; Priya consumes Gold in Power BI. Same schema, any engine.


Three constraints (day spine)

Introduced in Story · Revisited Module 7:

Constraint Marcus asks
Cost Affordable in year 3?
Performance Fast enough for live dispatch (Module 8)?
Compliance Audit-ready lineage by Q3?

Role boundaries (say once per day)

  • Elena approves tool pivots — Bob executes; trainees are Bob.
  • dbt runs on Snowflake — not a third warehouse.
  • Module 6 = Cortex LLM · Module 9 = Cortex ML (different APIs).

Optional modules (8 → 9)

Module Story hook Lab dataset note
8 Streaming Live dispatch Aiven Kafka proxy — say explicitly
9 ML Tip prediction Same NYC Taxi Silver

Deliver 8 before 9 when running both.


Printable timing card (cut along dashed line)

┌─────────────────────────────────────────────────────────┐
│  MODULE N — FIVE STEPS                                 │
├─────────────────────────────────────────────────────────┤
│  [ ] 1. Animation          ___ min   mod-0N-*.mp4       │
│  [ ] 2. Think & Discuss    ___ min   reflection-prompts │
│  [ ] 3. Theory             ___ min   module §3          │
│  [ ] 4. Quiz               ___ min   Google Form        │
│  [ ] 5. Practice / Discuss   ___ min   exercise OR Module 7 open discussion │
├─────────────────────────────────────────────────────────┤
│  Bridge: "You mentioned ___ — here's how we handle it." │
│  Priya beat: _________________________________________  │
└─────────────────────────────────────────────────────────┘

Document history

Date Change
2026-06-05 Restructured from four-step to five-step delivery (added Quiz step; Think & Discuss now oral only)
2026-06-04 Added pre-class checklist reference in environment readiness section
2026-05-24 Initial four-step delivery cheat sheet