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

Mastering Power BI (affiliate):
amzn.to/43rQgm3
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:
www.pivotalstats.com/post/com...
Previous Video Link about Data Import
• Understanding Power BI...
Visit my blog for more content :
www.pivotalstats.com
Affiliate Links --
Best Web Hosting Service :
bluehost.sjv.io/k0OkNv
Cool tech that I use for these videos :
1. Blue Yeti Microphone - amzn.to/3CeMv7C
2. LG Ultrawide Curved Monitor - amzn.to/3EaHY8v
#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

[@trinipepper23]

First time I understood this so clearly. Well done

[@pivotalstats]

Glad it helped. Thanks for watching 🙂

[@Sanj20101]

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

[@pivotalstats]

Awesome, really happy that it helped!

[@swapnavivek9647]

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

[@pivotalstats]

Best of luck!

[@monubhaiya9022]

Thank you so much Sir ... Great teaching

[@pivotalstats]

Thanks for watching!

[@HarshvardhanPandey-xl7yi]

Great Work Man !!

[@pivotalstats]

Thanks 🙂

[@abhishekkunte2482]

Good and easy content that any beginner can understand.

[@pivotalstats]

Glad it was helpful!

[@RafiqulIslam-dv9cu]

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.

[@pivotalstats]

👍

[@RafiqulIslam-dv9cu]

Both directions not would please explain by another video

[@abderrahimelfazy8368]

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

[@pivotalstats]

Thank you so much 😀

[@sayanbera28]

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?

[@pivotalstats]

Hi, Its a very valid question. To give a short answer, no date & pizzacode are not connected to each other. And even if you try to get that data it will display all pizza category for each date, which is obviously wrong. Initially in the video, Dim_Date and PizzaCode are connected to Sales (1-Way Connection). So which means you can use Date & Pizzacode to filter data in Sales but not the other way round. Now at 13:05 , I make the connection between Dim_Date & Sales a 2-Way connection. Which means now you can use Sales table to filter data from Dim_Date & vice versa. Hope this helps!

[@vishalmane3139]

what if their r no common columns between two table?

[@pivotalstats]

Without a common column (i.e. Key), we cannot join or create relationship between two tables. You can create a custom key column in both tables using any logic. Just make sure that when you create that column, the values are unique in atleast one table, otherwise you would have to create a many-many relationship which is not ideal.

[@Goddibaba]

Nice A.I. Avatar bro

[@pivotalstats]

Thanks 🙂

[@beautieshelp5973]

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

[@pivotalstats]

Sure I will

[@sreejithramakrishnan123]

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.

[@pivotalstats]

Data transformation in itself is a big topic and splitting data is completely dependent on the type of data you are working with. Typically in organizations, huge data is maintained and transformed in an "On Premise Relational Database System or Cloud". This involves ETL process & creating an entire data Warehouse using dimensional data modelling (fact & dimension structure). Then instance of this data is loaded into Dataflows (PBI services) to create relationship & other calculations, and finally its used in Power BI reports.

[@sreejithramakrishnan123]

thanks for the reply@@pivotalstats

[@bhapapathvisutvatanasak9329]

6:14 Kindly clarify "multiple values of the same entry"

[@bhapapathvisutvatanasak9329]

what is schema?

[@pivotalstats]

For example, you have a table with 2 columns. Col1 = Name , col2 = salary. In name column you have 2 entries for the name John. They might be duplicate entries or u have 2 John's in the team. Whatever may be the reason, you now have "multiple values of the same entry"

[@pivotalstats]

The most simplest explanation of schema is that, its a layout or structure of how tables are stored in your database and their relationships with each other.

[@shubhamgupta9323]

why you connected fact_pizzaunsold with dim_date why not with FACT_pizzasales

[@pivotalstats]

As a best practice, we should never connect two fact tables directly. The main reason for that is Fact tables usually have repeated entries, so a direct connection will create a many-many relationship, and this can cause weird results.

[@shubhamgupta9323]

@@pivotalstats thanks

[@RafiqulIslam-dv9cu]

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

[@pivotalstats]

Hi, Yes there was a mistake in that video, so I have reuploaded that video. Thanks for watching!

[@sureshsonti8097]

can you do snowflake schema

[@pivotalstats]

Sure, I will try to include that in a future power bi video.