Power BI Masterclass: Data Modeling 101
ฝัง
- เผยแพร่เมื่อ 27 ก.ย. 2024
- 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
Wow, this is the most clear and detailed explanation I found. Thanks a lot 😊
You made data modelling simple! hats off to you :)
It was very helpful for me, and can you share data on the video (type csv is better). Thank You
The Best tutorial i've ever seen.
Excellent video, several key learnings there that i can take away and implement. Thank you so much 🙏
Brilliant. Thanks for making such a great video.
So well-explained, thanks!
Outstanding, thank you.
Excellent tutorial by Saurabh
thank you very much for this, very helpful
The teacher is awesome
Please tell when I can get date what you were used as an example ,
I come across too late but this is really good video
Thank you
please can we get a video of DAX PLEASE , very helpful tutorial
Awesome, keep it up!
Nice presentation Saurabh. Please uploaf more videos. It was very helpful
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!
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 ?
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
Awesome
where is dataset to practice
But I don’t get, what is the need to create inactive relationship?
in some requirement, inactive relationship is need to use in DAX as role playing dimension!
Great content
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
Incredibly well done
Use collie approach
Star schema visual is ugly
Thank you
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.
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!!
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.
Excellent video, several key learnings there that i can take away and implement. Thank you so much 🙏
Excellent video, several key learnings there that i can take away and implement. Thank you so much 🙏
ppt if provided would have been a cherry on a cup cake
Very very good demonstration. Very clear. Thank you!
Amazing overview, thank you so much!
very well explained..thank you...
Dude You are the best. The Best Teacher!
Thanks.
Sourabh and team, super appreciate this, thanks!! Extremely clear and concise, and appreciated the illustrated examples.