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

Подписаться 11 тыс.

Просмотров 5 тыс.

50% 1

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

Опубликовано:

3 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 37

@swapnavivek9647 3 месяца назад

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

@pivotalstats 3 месяца назад

Best of luck!

@HarshvardhanPandey-xl7yi 4 месяца назад

Great Work Man !!

@pivotalstats 4 месяца назад

Thanks 🙂

@monubhaiya9022 11 месяцев назад

Thank you so much Sir ... Great teaching

@pivotalstats 11 месяцев назад

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!

@abhishekkunte2482 9 месяцев назад

Good and easy content that any beginner can understand.

@pivotalstats 9 месяцев назад

Glad it was helpful!

@abderrahimelfazy8368 8 месяцев назад

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

@pivotalstats 8 месяцев назад

Thank you so much 😀

@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

@Goddibaba Год назад

Nice A.I. Avatar bro

@pivotalstats Год назад

Thanks 🙂

@sayanbera28 5 дней назад

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 3 дня назад

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 3 месяца назад

what if their r no common columns between two table?

@pivotalstats 3 месяца назад

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.

@sreejithramakrishnan123 5 месяцев назад

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 5 месяцев назад

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 5 месяцев назад

thanks for the reply@@pivotalstats

@beautieshelp5973 5 дней назад

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

@pivotalstats 4 дня назад

Sure I will

@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!

@bhapapathvisutvatanasak9329 6 месяцев назад

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

@bhapapathvisutvatanasak9329 6 месяцев назад

what is schema?

@pivotalstats 6 месяцев назад

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 6 месяцев назад

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 3 месяца назад

why you connected fact_pizzaunsold with dim_date why not with FACT_pizzasales

@pivotalstats 3 месяца назад

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 2 месяца назад

@@pivotalstats thanks