Gathering Requirements for your Star Schema
summary
A requirements method called Sunbeam combines BEAM and some modeling to produce a conceptual star schema by workshop: discover events, run the 7Ws (who what when where why how how many), capture measures first in the centre, and add dimension spokes until exhausted. Workshops use online whiteboards like Miro or Mural, require two facilitators (one to run, one to record), and favour one model per event. Output is a straw‑man fact table with dimensions, a logical model ready for physical design or consolidation into a bus matrix; used across multiple organisations and iterated successfully in delivery.
AI-written summary · about
chapters (12)
- 0:00Start
- 0:24JOHNNY WINTER
- 6:36IS STAR SCHEMA STILL RELEVANT?
- 8:15WHAT IS A STAR SCHEMA?
- 9:15DIFFERENT PERSONAS
- 11:02SUNBEAM
- 14:08A SUN MODELLING
- 16:27TYPES OF DATA MODEL
- 20:14A HOLD A WORKSHOP
- 35:56TIPS AND ADVICE
- 45:10MAKE IT YOUR OWN!
- 48:45FEEDBACK
related talks
41mThe Unified Star Schema
16mGood Data Modeling & Effective Communication in Power BI
34mDimensional Data Modeling in the Modern Era
50mStar Schema ALL the things! But why?
14mBuild your data lakehouse with Starburst Galaxy
01h 00mBuilding an Effective Data Warehouse Architecture
43mScaling Data Stacks: How To Build a Great Data Model
40mBuilding Event Collection SDKs and Data Models