Creating a Shared Dimension in Power BI Using Power Query Basics and Foundations of Modeling

preview_player
Показать описание
For a data warehouse professional, a shared dimension concept is always clear, and a star schema design always includes such type of entity. However, in the Power BI user’s world, there are many users who are not coming from a data warehousing background. It is necessary to understand some of the concepts in order to design a good performing Power BI model. I will be writing about some of the concepts in an easy-to-understand way in some articles, here is the first one; What is a shared dimension, and why do you need that in your Power BI model? In this blog post, I will explain how it can prevent many issues, as well as the need for both directional relationship.
Learn more by reading my article about it here:
  1. RADACAD
  2. Power BI
  3. Power BI from Rookie to Rock Star
  4. Power BI training
  5. Power BI Tutorial
  6. Learning Power BI
Рекомендации по теме
Creating a Shared 0:18:18

Creating a Shared Dimension in Power BI Using Power Query Basics and Foundations of Modeling

Join Two Fact 0:02:35

Join Two Fact Tables using a common dimension table Power BI

Power BI - 0:01:29

Power BI - Power Query - Create Dimension or Lookup Table

Fact & Dimension 0:15:07

Fact & Dimension tables in Power BI | Data Modelling

What is STAR 0:06:59

What is STAR schema | Star vs Snowflake Schema | Fact vs Dimension Table

Create A Dimension 0:11:05

Create A Dimension Table In A Text File - Problem Of The Week #2 (Power Query Solution)

Create A Dimension 0:07:01

Create A Dimension Table From A Text File - Intro To Problem Of The Week #2 (Power Query)

How to create 0:04:51

How to create a dimension table from a fact table in Power BI | Dimension and fact table in Power BI

how to draw 0:05:17

how to draw a cup of tea| step-by-step for beginners | 🥰🥰🥰

SSAS - Dimensions 0:30:41

SSAS - Dimensions and Hierarchy - Dimension Product

Oracle Workforce Planning 0:11:36

Oracle Workforce Planning Attribute Dimension, UDAs and Shared member | Oracle Custom Workforce App

How Merged Dimension 0:12:39

How Merged Dimension Works | SAP BusinessObjects

All in One 0:06:14

All in One Script to Create Date Dimension in Power BI using Power Query

CREATE FACT & 0:06:43

CREATE FACT & DIMENSION TABLES FROM A SINGLE DE-NORMALIZED TABLE

How to Create 0:11:06

How to Create Date Table or Date Dimension | Calendar Table in Power BI Tutorial (13/50)

Creating a First 0:14:13

Creating a First user landing page dimension in GA4

How to create 0:01:13

How to create a Grouped Bar chart using a dimension in Tableau

How to make 0:06:03

How to make dimension style & use each an every file

How to create 0:04:04

How to create 3D Liquid Effect | Adobe Illustrator & Dimension Tutorial

SAC Introduction, Creation 0:29:29

SAC Introduction, Creation of Dimension and Update data using csv File

How to Create 0:12:38

How to Create Dimension in NX PMI (Product and Manufacturing Information) | Siemens NX 2206

Power BI 0:13:52

Power BI How to Create Dimension Table in Power BI what is Surrogate Key

Adobe Dimension Tutorial 0:13:47

Adobe Dimension Tutorial | 3D Mockups for Beginners

Create DimDate dimension 0:23:55

Create DimDate dimension

Комментарии
Автор

Thank you. Do you have any link available to download the sample files? It would be great to follow along while watching the video.

gvitullib
Автор

In some tables there's no data for a given product. How to not show this product in the slicer? Something like Excel's 'hide values with no data'

mrbartuss
Автор

Hi Raza,
I have power query table called "tbl_1".
I need to have another table called "tbl_2" sourcing data at "tbl_1" step no. 4.
There are other steps also after step#4. I don't want to duplicate table because it was decrease its efficiency. How can it be achieved without duplicating table?

AnshulMarele-gbaa