Power BI Masterclass: Data Modeling 101
HTML-код
- Опубликовано: 16 сен 2021
- 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 😊
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!!
You made data modelling simple! hats off to you :)
Brilliant. Thanks for making such a great video.
Very very good demonstration. Very clear. Thank you!
Nice presentation Saurabh. Please uploaf more videos. It was very helpful
Excellent video, several key learnings there that i can take away and implement. Thank you so much 🙏
Amazing overview, thank you so much!
Outstanding, thank you.
Sourabh and team, super appreciate this, thanks!! Extremely clear and concise, and appreciated the illustrated examples.
So well-explained, thanks!
Dude You are the best. The Best Teacher!
The Best tutorial i've ever seen.
It was very helpful for me, and can you share data on the video (type csv is better). Thank You
Awesome, keep it up!
very well explained..thank you...
Excellent tutorial by Saurabh
Thank you
The teacher is awesome
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.
Incredibly well done
I come across too late but this is really good video
Thanks.
Please tell when I can get date what you were used as an example ,
please can we get a video of DAX PLEASE , very helpful tutorial
Awesome
ppt if provided would have been a cherry on a cup cake
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
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!
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
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.
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
Use collie approach
Star schema visual is ugly
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 🙏