I have been asked the above question but i know only its meaning that its the finest level of data. for example, if you have name in fact table, then its detail such email, phone number,etc can be found in dimensions table. I have sample dataset and its area level analysis which i have worked on, Please explain granularity of data based upon this data.
Dataset:
| itemid | item | RID | Rname | Area | Time_Availability>70% |
|---|---|---|---|---|---|
| 6222589 | peanut banana | 1000 | Cafe adda | gachibowli | True |
| 6355784 | chocolate fudge | 2000 | Santosh hotel | Attapur | False |
Area level of analysis of restaurant on boarding to a platform
| Area | Total Ingested restaurants | Available | items_Available >=5 |
|---|---|---|---|
| Gachibowli | 5 | 4 | 2 |
| Attapur | 5 | 4 | 2 |
Thank you
The granularity of a fact table is the minimum set of attributes that will uniquely identify a measure.
For example (and I'm not saying this is a real world example), if you had a sales fact table and there could only be one sale per customer per day then "per customer per day" would be the granularity of that fact table. You might have other dimensions such as the store that the sale occurred in or the country where the transaction took place - but these would not affect the granularity if you could still only have one sale per customer per day, regardless of which store or country that transaction took place in