In a reporting data model, there are two types of tables. What is the Direction of the Relationship?ĭata preparation First and Foremost Important task Two Types of Tables What is the Cardinality of the Relationship? However, I highly recommend you to read below articles beforehand There is no prerequisite for this article. If you like to learn more about Power BI, read Power BI book from Rookie to Rock Star. If you heard about Dimension and have no idea what it is, or if you haven’t heard about it and you want to build a data model for reporting, this article is what you need to read. Although examples of this article are all using Power BI and Power Query, the basics of modeling are valid regardless of the tool that you use.
In this article, I will explain what a Dimension table is, and examples of it, and how it can be created. Now is a good time to explain the two types of tables we deal with every day in a reporting data model Fact and Dimension table. Business users who generate these reports fire queries on these dimension tables as they contain descriptive information.įor an in-depth understanding of how Dimension Table works, here’s a video tutorial recorded by our Data warehousing and business intelligence Expert to explain the topic in a crisp manner with elaborate examples.I have previously written about relationships and the cardinality of the relationship. This kind of an information becomes very crucial because in case of any clarification, the company can refer to this dimension table. When a company wants to create a report, they can read the data from the dimension table since the table consists of necessary information.įor example, an e-commerce company can create a dimension table with various columns depending on different subjects they would like to gain information from like the name of the person, address, date of order, shipment etc. If there are any changes to be made, it is evident that only a particular table will get affected. This dimension table can be utilized across for reports and it’s about re-usability. When you create a dimension, you logically create a structure for your projects. For example, a large credit card company could have a customer dimension with millions of rows. Dividing a data warehouse project into dimensions, provides structured information for reporting purpose. Occasionally dimensions can grow fairly large, however. Attributes would be a customer’s first and last name, age, gender etc.ĭimension tables are typically small, ranging from a few to several thousand rows.
Product dimension could contain a name and description of products you sell, their unit price, color, weight and other attributes as applicable.
Dimension tables are used to describe dimensions they contain dimension keys, values and attributes.įor example, the time dimension would contain every hour, day, week, month, quarter and year that has occurred since you started your business operations. Data warehouses are built using dimensional data models which consist of fact and dimension tables.
#Dimension table professional#
Become a Certified Professional Dimension tableĪ Dimension Table is a table in a star schema of a data warehouse.
0 kommentar(er)
