A fact table is a table full of those fields. Examples of Fact is Sales Amount, Order Quantity, Profit, Cost, etc. What is a Dimension table and why say No to a single big table What is a Fact Table?Ī fact table is a table full of Facts! If you have read the definition of Fact from the previous article, you know that fact is a numeric field which usually needs to be aggregated, and will be set as the value part of visualizations. What is the Direction of the Relationship?ĭata preparation First and Foremost Important task What is the Cardinality of the Relationship? However, I highly recommend you to read below articles beforehand There is no prerequisite for this article. To learn more about Power BI, read Power BI book from Rookie to Rock Star. Examples of this article are built using Power BI, however, all of these concepts can be used regardless of the technology. In this article, you will learn about the fact table, and how it positioned in a data model, you will also learn how fact table and dimension table are related to each other to build a proper data model. In the previous article, I explained what a dimension table is, and why we cannot have everything in one big table. Fact tables are the core of analysis in a data model.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |