Granularity

How it is used

Also called the 'grain' of a table. Data can be fine-grained (very detailed) or coarse (summarised). Analysts ask 'What's the granularity of this table?' before a join, because mixing levels leads to double counting.

Example sentences

1. The orders table is at order-level granularity, but the targets are monthly.

2. We store events at the finest granularity and aggregate them later.

Common collocations

• daily granularity
• level of granularity
• finer granularity
• grain of the table

Related terms

• aggregateTo combine many rows of data into summary values, such as totals, counts or averages, usually grouped by a category such as day, product or region.
• primary keyA column, or a set of columns, whose value uniquely identifies each row in a table. It cannot be empty and no two rows can share it.
• schemaThe structure of a database: its tables, columns, data types, keys and relationships. In some products it is also a named group of tables inside a database.
• drill downTo move from a summary view to more detailed data, for example from yearly sales to monthly sales and then to single stores, in order to find the cause of a pattern.

This word in other fields

The same English word can have a different meaning in another field:

• granularity · Data Science & Analytics

More terms: Machine Learning and Data Processing

• artificial intelligence
• machine learning
• model
• dataset
• training data
• label
• train
• supervised learning
• neural network
• deep learning
• loss function
• overfitting