Complete Guide to Create Data Models & Table Relationships

No video

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

Рет қаралды 6,379

Pivotalstats

Күн бұрын

Пікірлер: 43

@shankarmidatala2049 Ай бұрын

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.

@pivotalstats Ай бұрын

Glad I could help!

@Sanj20101 3 ай бұрын

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

@pivotalstats 3 ай бұрын

Awesome, really happy that it helped!

@swapnavivek9647 5 ай бұрын

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

@pivotalstats 5 ай бұрын

Best of luck!

@charithavani2783 29 күн бұрын

Excellent sir, Hats off to you

@pivotalstats 29 күн бұрын

Thanks :)

@trinipepper23 Ай бұрын

First time I understood this so clearly. Well done

@pivotalstats Ай бұрын

Glad it helped. Thanks for watching 🙂

@abhishekkunte2482 11 ай бұрын

Good and easy content that any beginner can understand.

@pivotalstats 11 ай бұрын

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 10 ай бұрын

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

@pivotalstats 10 ай бұрын

Thank you so much 😀

@monubhaiya9022 Жыл бұрын

Thank you so much Sir ... Great teaching

@pivotalstats Жыл бұрын

Thanks for watching!

@HarshvardhanPandey-xl7yi 6 ай бұрын

Great Work Man !!

@pivotalstats 6 ай бұрын

Thanks 🙂

@sayanbera28 2 ай бұрын

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!

@Goddibaba Жыл бұрын

Nice A.I. Avatar bro

@pivotalstats Жыл бұрын

Thanks 🙂

@vishalmane3139 4 ай бұрын

what if their r no common columns between two table?

@pivotalstats 4 ай бұрын

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.

@beautieshelp5973 2 ай бұрын

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

@pivotalstats Ай бұрын

Sure I will

@sreejithramakrishnan123 7 ай бұрын

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 7 ай бұрын

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 7 ай бұрын

thanks for the reply@@pivotalstats

@shubhamgupta9323 4 ай бұрын

why you connected fact_pizzaunsold with dim_date why not with FACT_pizzasales

@pivotalstats 4 ай бұрын

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 3 ай бұрын

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

@bhapapathvisutvatanasak9329 8 ай бұрын

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

@bhapapathvisutvatanasak9329 8 ай бұрын

what is schema?

@pivotalstats 8 ай бұрын

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 8 ай бұрын

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.