{"id":5164,"date":"2026-02-25T08:42:52","date_gmt":"2026-02-25T07:42:52","guid":{"rendered":"https:\/\/www.beeminds.nl\/insights\/what-are-facts-and-dimensions"},"modified":"2026-02-25T08:42:52","modified_gmt":"2026-02-25T07:42:52","slug":"what-are-facts-and-dimensions","status":"publish","type":"knowledge_pt","link":"https:\/\/www.beeminds.nl\/en\/insights\/what-are-facts-and-dimensions","title":{"rendered":"What are facts and dimensions?"},"content":{"rendered":"<h2>What are facts?<\/h2>\n<p><strong>Facts <\/strong>are measurable data. Think of numbers that you can add, calculate or analyze. Examples:  <\/p>\n<ul>\n<li>Turnover in euros<\/li>\n<li>Number of products sold<\/li>\n<li>Number of visitors to a website<\/li>\n<\/ul>\n<p>Facts are often linked to a time, place or other context.<\/p>\n<h2>What are dimensions?<\/h2>\n<p>Dimensions give meaning to facts. They describe the context so you can understand the figures. Examples:  <\/p>\n<ul>\n<li>Time (year, month, day)<\/li>\n<li>Product (category, brand, type)<\/li>\n<li>Customer (age, region, gender)<\/li>\n<\/ul>\n<p>Dimensions allow you to look at facts from different angles.<\/p>\n<h2>How facts and dimensions together?<\/h2>\n<p>A simple example:<\/p>\n<ul>\n<li><strong>Fact<\/strong>: sales = \u20ac1,000,000<\/li>\n<li><strong>Dimensions<\/strong>: in 2025, in the Netherlands, for product group &#8220;beer&#8221;<\/li>\n<\/ul>\n<p>By combining facts and dimensions, you can answer questions such as:<br \/>\n<em>Which region achieved the most sales in 2025?<\/em><\/p>\n<h5>Why are facts and dimensions important?<\/h5>\n<ul>\n<li>They make data <strong>understandable<\/strong>.<\/li>\n<li>They provide <strong>structure <\/strong>to reports and dashboards.<\/li>\n<li>They help you gain insights faster and make better decisions.<\/li>\n<\/ul>\n<h5>Facts and dimensions in Power BI<\/h5>\n<p>In <strong>Power BI <\/strong>, facts and dimensions are the building blocks of a good data model: <\/p>\n<ul>\n<li>The <strong>fact table <\/strong>contains the numbers you want to analyze (for example, sales or numbers).<\/li>\n<li><strong>Dimension tables <\/strong>allow you to filter, group or visualize those numbers (for example, by year, by customer or by product).<\/li>\n<\/ul>\n<p>When you model facts and dimensions well in Power BI, you get:<\/p>\n<ul>\n<li><strong>Faster reporting <\/strong>because relationships are set up logically.<\/li>\n<li><strong>Reliable results <\/strong>because figures are always shown in context.<\/li>\n<li><strong>Flexibility <\/strong>to easily extend dashboards without having to rebuild everything.<\/li>\n<\/ul>\n<h2>Why well modeled facts (Kimball) are important<\/h2>\n<p>A common mistake is working with only <strong>transactional tables<\/strong>. Those often contain everything that happened: every order, every product, every customer, every line. That&#8217;s valuable data, but for reporting purposes it creates problems:  <\/p>\n<ul>\n<li>It is slow: tables with millions of rows are not efficient to analyze directly.<\/li>\n<li>It is unclear: the same calculation must be built over and over again.<\/li>\n<li>It is error-prone: small differences in logic produce anomalous results.<\/li>\n<\/ul>\n<p>Therefore, use the Kimball model (star schema) to create fact tables specifically designed for analysis.<\/p>\n<h5>Example: sales dates<\/h5>\n<p>Suppose you have a transactional table with millions of order lines:<\/p>\n<ul>\n<li>OrderID, ProductID, CustomerID, Date, Quantity, Price<\/li>\n<\/ul>\n<p>In such a table, of course, you can calculate sales, but it gets complicated when you want to answer questions like:<\/p>\n<ul>\n<li>&#8220;What is the average order value by customer type?&#8221;<\/li>\n<li>&#8220;Which product category is doing best by quarter?&#8221;<\/li>\n<\/ul>\n<p>By creating a <strong>fact table <\/strong>(for example, <em>SalesFact<\/em>) with calculated fields such as <em>TotalSales <\/em>and <em>Quantity<\/em>, and linking this to dimension tables<em>(CustomerDim<\/em>, <em>ProductDim<\/em>,<br \/>\n<em>TimeDim<\/em>), you get a much more powerful model. Power BI can then directly and reliably make the connections and perform complex analysis. <\/p>\n<p>In short, a transactional table is good for capturing transactions, but not for reporting. For reliable insights, you need well-designed <strong>fact tables and dimensions <\/strong>. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>In the world of data and business intelligence, you often encounter the terms facts and dimensions. Together, they form the basis of many data models, especially in data warehouses and reporting tools such as Power BI. <\/p>\n","protected":false},"featured_media":0,"template":"","knowledge_type":[58],"knowledge_category":[],"class_list":["post-5164","knowledge_pt","type-knowledge_pt","status-publish","hentry","knowledge_type-simplified"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/knowledge_pt\/5164","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/knowledge_pt"}],"about":[{"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/types\/knowledge_pt"}],"wp:attachment":[{"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/media?parent=5164"}],"wp:term":[{"taxonomy":"knowledge_type","embeddable":true,"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/knowledge_type?post=5164"},{"taxonomy":"knowledge_category","embeddable":true,"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/knowledge_category?post=5164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}