CaseTalkBEAM Canvas

Business Event Analysis & Modeling — Agile Data Warehouse Design (7W Framework)

🔒 All data is stored locally in your browser and never sent anywhere. Want to save, load or integrate with CaseTalk? Sign up.
🕒 When When does it happen?
Date, Time, Time Zone, Period, Timeline
⚙️ How How does it happen?
Verb, Activity, Effect, Status, Transaction #
👤 Who Who is involved?
Customer, Employee, Supplier, Partner
📊 How Many How many / how much?
Quantities, Revenues, Costs, Balances, KPIs
📍 Where Where does it happen?
Location, Branch, Channel, URL
📦 What What is involved?
Product, Service, Resource, Item
❓ Why Why does it happen?
Cause, Trigger, Promotion
Show BEAM Codes Reference
Event/Fact Table Codes
DE Discrete Event • RE Recurring Event • EE Evolving Event • TF Transaction Fact • AS Accumulating Snapshot • PS Periodic Snapshot • AG Aggregate • DF Derived Fact
Dimension Table Types
CV Current Value (SCD1) • HV Historic Value (SCD2) • RP Role-Playing • RU Rollup • SD Swappable • ML Multi-Level • HM Hierarchy Map • MV Multi-Valued Bridge • PD Pivoted
Key Types
PK Primary Key • SK Surrogate Key • BK Business Key • NK Natural Key • FK Foreign Key • RK Recursive Key
Fact Types
FA Fully Additive • SA Semi-Additive • NA Non-Additive • DF Derived Fact
Column Codes
MD Mandatory • NN Not Null • DD Degenerate Dimension • GD Granular Dimension • FV Fixed Value
Data Types
C Character • N Numeric • I Integer • D Date • DT DateTime • T Text • B Blob

Name

Notes

Sub-Category

Dimension Type

Key Type

Data Type

Length.Precision

Source

Example Data