Question

Explain the significance of granularity in the context of data warehousing

Answer 1

Granularity means the level of detail of your data within the data structure. In a typical Data Warehouse one might find very detailed data (such as seconds, single product, one specific attribute) and aggregated data (such as total number of, monthly orders, all products)