Power BI Masterclass: Data Modeling 101

In this 60-minute Masterclass, our Power BI experts will show you everything you need to know about data modeling in Power BI.
This session is for everyone - beginners and established Power BI users will take something away from this in-depth session.
You will learn:
● Understanding basic dimensional modeling concepts
● Understanding cardinalities and cross-filter directions
● Mastering active vs. inactive relationships
● Knowing when to use Power Query vs. the Data Model

[@talya1719]

Wow, this is the most clear and detailed explanation I found. Thanks a lot 😊

[@toyin4x]

thank you very much for this, very helpful

[@jaybeebee9288]

I have to say, even as an OCI myself I stay away from training videos by South Asian speakers, but your command of diction and enunciation is impressive!! Well done bhaiyya!!

[@laureneze]

Thank you

[@FormulaMedia-gl9pi]

You made data modelling simple! hats off to you :)

[@shrujadhav3802]

The Best tutorial i've ever seen.

[@interest2006]

Dude You are the best. The Best Teacher!

[@archies23]

Nice presentation Saurabh. Please uploaf more videos. It was very helpful

[@user-tl1ds8wi9m]

Excellent video, several key learnings there that i can take away and implement. Thank you so much 🙏

[@mathieux2101]

So well-explained, thanks!

[@taranazare2633]

Very very good demonstration. Very clear. Thank you!

[@kieuvu958]

It was very helpful for me, and can you share data on the video (type csv is better). Thank You

[@mathewrtaylor]

Sourabh and team, super appreciate this, thanks!! Extremely clear and concise, and appreciated the illustrated examples.

[@yogeshkrishna9997]

Brilliant. Thanks for making such a great video.

[@nitashagill9343]

Amazing overview, thank you so much!

[@iqbalsetiawan7558]

Outstanding, thank you.

[@uchechukwuekeh2285]

The teacher is awesome

[@davidadu-tenkorang3186]

Good work done. Please, I have two questions. 1. At 35:46 , when I did manual calculation of the first table to the left, the total number was correct but the other two weren't yet after fixing the relationship issue you said that it is correct. Notwithstanding your instance, I have noticed it in my calculation where by a manual calculation of the figures doesn't add up. Please any clarification to that. 2. Also, at 48:29 when you used the table, there was a blank space at the top with a figure. Please, I need clarifications to that.

[@damarajusundararao8370]

Excellent tutorial by Saurabh

[@renubhusal]

very well explained..thank you...

[@Pralhad1972]

I come across too late but this is really good video

[@venkatnagesh7338]

Please tell when I can get date what you were used as an example ,

[@sadns2000]

Thanks.

[@siddheshdhanawade3709]

ppt if provided would have been a cherry on a cup cake

[@afonsoosorio2099]

Awesome, keep it up!

[@Ikilledthebanks]

Incredibly well done

[@lagudaadeyemi8359]

please can we get a video of DAX PLEASE , very helpful tutorial

[@arefd2011]

Awesome

[@jaitiwari241]

where is dataset to practice

[@lisbongraffiti242]

Hi everyone! Maybe somebody here could help me with this issue: I have a FactTable with CustomerID and ProductID as ForeignKeys. The CustomerID has also some columns with information about territory such as (City, Region, Country). I tried to combine those columns with the Fact Table, create the new Territory Table related to this columns and then delete the columns from the fact table and the Products Table with Power Query, butn if I delete any of this columns, all their fields become null. As the columns should not repeat in a Star Schema, is there any way that I can separate those columns into a different dimension table and add this new Territory Dimension with his specific Territory Key inserted into the original Fact Table? Thank you very much!

[@uchechukwuekeh2285]

But I don’t get, what is the need to create inactive relationship?

[@saravananram3740]

in some requirement, inactive relationship is need to use in DAX as role playing dimension!

[@deshmukram623]

4:55 Why do we need 2 tables for actual sales and target sales , sir ? we can have all these columns Year , Product Name , Actual Sales, Target Sales , in a single table itself , wasn't it ?

[@suryateja306]

Because target sales can be at month level or quarter level and daily sales is at day level. These two should be placed separately. Or else double counting occurs

[@chriskeo392]

Use collie approach Star schema visual is ugly

[@yonisupersaiyanyoni3693]

When you talk about many to many relationships and say its risky, You need to give examples because it's ain't clear what you mean. You need to give clear scenarios so we can understand why not to do this connection.

[@deshmukram623]

44:18 a column shuld have atomic value its violating the normalizatin rule , be it normalization or denormalization a single column should not hv more than one value, you should have concatenated both year and product name, or simply selected 2 columns in each table to create an active relationship its that simple ,,,that's the basic stuff u shd be aware of it

[@dakshpancholi3185]

Great content

[@user-tl1ds8wi9m]

Excellent video, several key learnings there that i can take away and implement. Thank you so much 🙏

[@yogeshkosikayya4275]

Thank you

[@user-tl1ds8wi9m]

Excellent video, several key learnings there that i can take away and implement. Thank you so much 🙏