As a Data Analyst, have you wondered that what is the difference between 𝗙𝗮𝗰𝘁 𝗧𝗮𝗯𝗹𝗲 and 𝗗𝗶𝗺𝗲𝗻𝘀𝗶𝗼𝗻 𝗧𝗮𝗯𝗹𝗲. If Yes, then don't worry! I am here to tell you: So, 𝗙𝗮𝗰𝘁 𝗧𝗮𝗯𝗹𝗲: It contain facts of a business process plus foreign keys which establish well-defined links to dimension tables. It contain detail level facts that have been aggregated. 𝗗𝗶𝗺𝗲𝗻𝘀𝗶𝗼𝗻 𝗧𝗮𝗯𝗹𝗲: It is a variable that categorizes facts. It is also called categorical variable in stats and machine learning. It is used to answer business questions but it's main use is grouping, filtering, grouping and labeling operations. That was it about the difference and I hope you guys liked it! #dataanalytics #fact #dimension #table #learningjourney
Thanks for this post. It will be more interesting to read if you post with an example.
Islamic Finance Professional | Islamic Fintech | Smart Contracts | Business Intelligence
9moI would like to add that the fact table records business transaction facts and activities, like sales transactions. On the other hand dimension table contains details of one item like products, employees, suppliers. One more thing, the dimension table must have unique value.