4. Subscription warehouse grain

Choose the warehouse grain for billing, usage, subscriptions, and plan-change reporting.

Constraints

Balance analytics flexibility with a model you can explain quickly under interview pressure

Brainstorming scratchpad

Practice studio

Ctrl/Cmd + C copyCtrl/Cmd + V pasteCtrl/Cmd + Z undoDelete remove

Start with the data model, then layer system context

Use entities and relationships for the real ERD. Add notes, containers, or curated cloud shapes only when they sharpen the story you are architecting.

68%

AI review panel

Validate the ERD objects to inspect keys, names, and cardinality coverage.