Complete Guide to Create Data Models & Table Relationships | Power BI

Mastering Power BI (affiliate):

This will be comprehensive video about creating data models & table relationships. We will discussing below topics in detail with examples to firm up your understanding in each concept
1. Data Normalization
2. Creating Data Model
3. Type of Model Schema with example
4. Cardinality concepts i.e. 1-Many & Many-Many
5. Table Relationships
6. Cross Filter Direction (Usage & Importance)

Data Used:

Previous Video Link about Data Import

Visit my blog for more content :

Affiliate Links --
Best Web Hosting Service :

Cool tech that I use for these videos :

#microsoft
#powerpivot
#dataanalytics
#dataanalysis
#powerbi

power bi,power bi data modeling,power bi desktop,power bi tutorial,power bi tutorial for beginners,data modeling in power bi,power bi training,power bi for beginners,data model,microsoft power bi,data modeling,learn power bi,power bi dashboard,power bi demo,power bi data model,power bi desktop tutorial,data modeling in power bi desktop,power bi best practices,power bi data modeling best practices,power bi data model tutorial,power bi star schema

[Sanj]

I liked your videos. Cleared many doubts I had till now on DataModelling and schemas. Thank you so much.

[shankarmidatala]

Thanks for the clarification, this video clarifies my question that you answered in the video "Power BI End to End Churn Analysis Portfolio Project". Please keep up the Great learning content.

[swapnavivek]

Amazing tutorials! I am watching this playlist, making notes and studying to prepare for PL300 Exam.

[trinipepper]

First time I understood this so clearly. Well done

[abderrahimelfazy]

Good job Bro, your content is very helpful 👍 keep going

[RafiqulIslam-dvcu]

Thank you for creating this video. Same things can do by using power pivot. I am waiting More video with practice Excel file. Again thank you sir.

[abhishekkunte]

Good and easy content that any beginner can understand.

[monubhaiya]

Thank you so much Sir ... Great teaching

[BlessedBeni]

Hi Sir, instead of using the Date column from either Fact tables, cant we pull the Date column from the DIM_DATES? Wont that yield the right results, and avoid the cross-join? Please clarify.

[sayanbera]

please clear my just 1 doubt --> date, pizzaCode, sales - 3 tables are connected to each other?
so if i want "Pizza-Category column" based on "Date column (from dim_date table)", is it possible?
in short, 'date' and 'pizzacode tables' are connected to each to other also?

[sreejithramakrishnan]

But if we have a really big dataset how we can split like this???, regarding the fact and dimension tables part. example you give is a smaller dataset and we can split easily but if more data how we do this? i know this is just for understanding and its understood but i have a doubt like this.

[bhapapathvisutvatanasak]

6:14

Kindly clarify "multiple values of the same entry"

[vishalmane]

what if their r no common columns between two table?

[RafiqulIslam-dvcu]

You recently uploaded a video I watched. but why don't I find it now. R u erase or delete it that video is very helpful and informative . I am waiting for that please upload again

[beautieshelp]

Sir plz create a new video again Bcz as I am beginner can't understand completely

[shubhamgupta]

why you connected fact_pizzaunsold with dim_date why not with FACT_pizzasales