Fact tables

There are three fact tables for this dataset—Internet Sales, Reseller Sales, and the Sales and Margin Plan. The ability to analyze and filter two or all three of these tables concurrently via common dimensions, such as Date, Product, and Sales Territory, is what gives this dataset its analytical value to the business. A Power BI report, which is always connected to a single dataset, could contain visualizations comparing total Adventure Works Sales (Internet Sales plus Reseller Sales) to the overall Sales and Margin Plan. This same report could also include detailed visualizations that explain higher-level outcomes, such as the growth in online customers or changes in the Reseller Sales margin rates:

Data Warehouse Bus Matrix

Each checkmark symbol represents the existence of a relationship implemented either directly between the fact and dimension tables in the Data Model or, in the case of the Sales and Margin Plan, via bridge tables. See Chapter 1, Planning Power BI Projects, for more details on the Data Warehouse Bus Matrix.

The Sales and Margin Plan is at a lower grain than the Internet Sales and Reseller Sales fact tables and thus cannot be filtered directly by columns such as Product Name. For the Sales and Margin Plan fact table, an alternative model design, including bridge tables and conditional DAX Measures, is used to support cross-filtering from the Product, Sales Territory, and Date dimension tables. See the Bridge tables section later in this chapter for more details.

Table of Contents for Fact tables

Create new playlist

Sign In

Sign Up

Table of Contents for
Fact tables