Granularität (EN)

Granularity levels in the data model

flowchart TD     A[Data source] --> B{Aggregation level}     B --> C[High granularity
Transaction data]     B --> D[Medium granularity
Daily sales]     B --> E[Low granularity
Annual sales]          C --> F[Very detailed
Analyses]     D --> G[Standard reports]     E --> H[Trend analyses]          F --> I[High storage requirement]     G --> J[Moderate storage requirement]     H --> K[Low storage requirement] 

In context

• Typically used together with data aggregation, dimension tables, and fact tables
• Related to: Data modeling, OLAP, Data Warehouse
• Example use case: In retail, granularity can vary from individual transactions to monthly sales totals