Whiteboard Prompts

Story worksheet + Module 7 synthesis templates

TRAINER ONLY

Capture trainee words — not slide content. Photograph boards at Story and Module 7.

Related: reflection-prompts.qmd · facilitator-guide.qmd


Story — Design worksheet (12 min)

Format: Individual sketch (5 min) → pairs compare (3 min) → whole group (4 min)

Prompts (display on screen)

  1. Draw your data sources and ingestion frequency.
  2. Name three layers and what each contains.
  3. List five KPIs Marcus cares about.
  4. Pick a primary tool for ingest and transform — one sentence why.
  5. What tests or documentation would you require before go-live?

Whiteboard template

┌──────────────────────────────────────────────────────────────────┐
│  YELLOWLINE NYC — WHAT WOULD YOU DESIGN?            Story · DATE   │
├──────────────────────────────────────────────────────────────────┤
│  PROBLEMS MARCUS FACES          │  DATA SOURCES / FREQUENCY       │
│  ·                              │  ·                              │
│  ·                              │  ·                              │
├─────────────────────────────────┼─────────────────────────────────┤
│  LAYERS PROPOSED                │  TOOLS MENTIONED                │
│  Bronze:                        │  Ingest:                        │
│  Silver:                        │  Transform:                     │
│  Gold:                          │  Consumption (Priya / PBI):     │
├─────────────────────────────────┴─────────────────────────────────┤
│  KPIs (5)                         │  RISKS                          │
│  1.                               │  ·                            │
│  2.                               │  ·                            │
│  3.                               │                               │
├───────────────────────────────────┴───────────────────────────────┤
│  THREE CONSTRAINTS (introduce today — revisit Module 7)           │
│  Cost: ___________  Performance: ___________  Compliance: ______ │
└──────────────────────────────────────────────────────────────────┘

Save this board — photograph before erasing. Revisit in Module 7 Round 4.

MHP reveal (after 10 min — do not front-load)

Item MHP answer (trainer crib)
Layers Bronze raw · Silver cleaned · Gold 12 KPIs
Sources ADLS2 Parquet + zone CSV
Consumption Priya → Power BI on Gold
Tools evaluated Databricks, Snowflake, dbt on Snowflake

Modules 1–6 — Quick capture columns

Use one row per module; erase between modules or use a running “insights” board.

Module Situation (1 line) Trainee idea worth keeping Priya / Gold link
1 Fundamentals Silver vs Gold KPI list
2 Databricks Ingest approach Overview charts
3 Snowflake SQL maintainability Map page
4 dbt Lineage / tests Revenue + quality
5 Production What breaks at 2 a.m. SLA / freshness
6 AI Where AI helps / hype NL query

Module 7 — Synthesis table (Round 3)

Build from trainee words during open discussion.

┌─────────────────────────────────────────────────────────────────┐
│  YELLOWLINE NYC TOOL COMPARISON — TRAINEE SYNTHESIS    Module 7    │
├──────────────┬──────────────────┬──────────────────┬────────────┤
│  Dimension   │  Databricks      │  Snowflake       │  dbt       │
├──────────────┼──────────────────┼──────────────────┼────────────┤
│  Best for    │                  │                  │            │
│  Weak for    │                  │                  │            │
│  Marcus SQL  │                  │                  │            │
│  team fit    │                  │                  │            │
└──────────────┴──────────────────┴──────────────────┴────────────┘

THREE DECISIONS (draw below table):
[ PLATFORM ]  →  [ TRANSFORM ]  →  [ CONSUMPTION / Power BI ]

Round 4 — Story revisit prompts

  1. What would you change in your morning design now?
  2. What did you get right on day one?
  3. If you were Elena, what would you tell Marcus to run on Monday?

Side-by-side: Story photo vs Module 7 synthesis table.


Priya’s five KPI questions (pin early — Module 1)

  1. When are our peak revenue hours?
  2. Which pickup zones drive the most trips?
  3. Which routes are most popular?
  4. How does revenue vary by borough and distance band?
  5. Are we losing money on bad data?

Maps to 12 Gold tables — see data model.


Document history

Date Change
2026-05-24 Initial whiteboard templates Story–7