Syed Abid Hassan’s Post

View profile for Syed Abid Hassan, graphic

Jr BI Programmer @Centegy Technologies |Member @Youth Parliament Pakistan |Brand Ambassador @FDSS NUCES Karachi |Alumni @Aspire Institute | Member @Pakistan-U.S Alumni Network

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

M Awais Masood IBCC, CSAA, MBA

Islamic Finance Professional | Islamic Fintech | Smart Contracts | Business Intelligence

9mo

I 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.

Venkatesh D

Product Specialist & Business Analyst at Quantman

9mo

Thanks for this post. It will be more interesting to read if you post with an example.

See more comments

To view or add a comment, sign in

Explore topics