To determine granularity you must start with two key questions:
"What does a single row in this dataset represent?"
"Which dimension or combination of dimensions uniquely identifies each record?"
Examples:
- POS Sales → Store + SKU + Day
- Inventory → Store + SKU
- Orders → OrderID + LineID