Grain

Grain

• Definition: The level of detail or granularity of the data stored in the fact table.
• Importance: Defining the grain is crucial as it determines what each record in the fact table represents (e.g., individual transactions, daily summaries).