Expert Data Modeling with Power BI by Soheil Bakhshi

Author:Soheil Bakhshi
Language: eng
Format: epub
Publisher: Packt Publishing Pvt Ltd
Published: 2021-05-14T00:00:00+00:00

Creating fact tables

Now that we've created all the dimensions, it is time to create a fact table that contains numeric values and the primary keys of the dimensions as foreign keys. Looking at the Sales Base and Customer Base data shows us that the Sales Base table holds many transactions with numeric values. Therefore, a fact table can be derived from the Sales Base table, which we will call Sales, by following these steps:

Reference the Sales Base table and then rename the new table Sales.We want to get ProductKey from the Product table. To do so, we can merge the Sales table with the Product table.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.