Power BI Masterclass: Data Modeling 101

  Рет қаралды 52,682

CRG Quisitive

CRG Quisitive

2 жыл бұрын

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

Пікірлер: 39
@jaybeebee9288
@jaybeebee9288 15 күн бұрын
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!!
@talya1719
@talya1719 2 жыл бұрын
Wow, this is the most clear and detailed explanation I found. Thanks a lot 😊
@yogeshkrishna9997
@yogeshkrishna9997 2 жыл бұрын
Brilliant. Thanks for making such a great video.
@archies23
@archies23 2 жыл бұрын
Nice presentation Saurabh. Please uploaf more videos. It was very helpful
@taranazare2633
@taranazare2633 11 ай бұрын
Very very good demonstration. Very clear. Thank you!
@nitashagill9343
@nitashagill9343 Жыл бұрын
Amazing overview, thank you so much!
@FormulaMedia-gl9pi
@FormulaMedia-gl9pi 7 ай бұрын
You made data modelling simple! hats off to you :)
@user-tl1ds8wi9m
@user-tl1ds8wi9m 10 ай бұрын
Excellent video, several key learnings there that i can take away and implement. Thank you so much 🙏
@iqbalsetiawan7558
@iqbalsetiawan7558 2 жыл бұрын
Outstanding, thank you.
@kieuvu958
@kieuvu958 2 жыл бұрын
It was very helpful for me, and can you share data on the video (type csv is better). Thank You
@mathewrtaylor
@mathewrtaylor 2 жыл бұрын
Sourabh and team, super appreciate this, thanks!! Extremely clear and concise, and appreciated the illustrated examples.
@renubhusal
@renubhusal Жыл бұрын
very well explained..thank you...
@interest2006
@interest2006 10 ай бұрын
Dude You are the best. The Best Teacher!
@mathieux2101
@mathieux2101 24 күн бұрын
So well-explained, thanks!
@shrujadhav3802
@shrujadhav3802 Жыл бұрын
The Best tutorial i've ever seen.
@damarajusundararao8370
@damarajusundararao8370 2 жыл бұрын
Excellent tutorial by Saurabh
@afonsoosorio2099
@afonsoosorio2099 Жыл бұрын
Awesome, keep it up!
@davidadu-tenkorang3186
@davidadu-tenkorang3186 10 ай бұрын
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.
@uchechukwuekeh2285
@uchechukwuekeh2285 Жыл бұрын
The teacher is awesome
@yogeshkosikayya4275
@yogeshkosikayya4275 2 жыл бұрын
Thank you
@venkatnagesh7338
@venkatnagesh7338 2 жыл бұрын
Please tell when I can get date what you were used as an example ,
@lagudaadeyemi8359
@lagudaadeyemi8359 2 жыл бұрын
please can we get a video of DAX PLEASE , very helpful tutorial
@Ikilledthebanks
@Ikilledthebanks 2 жыл бұрын
Incredibly well done
@sadns2000
@sadns2000 10 ай бұрын
Thanks.
@arefd2011
@arefd2011 Жыл бұрын
Awesome
@Pralhad1972
@Pralhad1972 3 ай бұрын
I come across too late but this is really good video
@siddheshdhanawade3709
@siddheshdhanawade3709 6 ай бұрын
ppt if provided would have been a cherry on a cup cake
@deshmukram623
@deshmukram623 2 жыл бұрын
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
@suryateja306 2 жыл бұрын
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
@lisbongraffiti242
@lisbongraffiti242 9 ай бұрын
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!
@jaitiwari241
@jaitiwari241 10 ай бұрын
where is dataset to practice
@uchechukwuekeh2285
@uchechukwuekeh2285 Жыл бұрын
But I don’t get, what is the need to create inactive relationship?
@saravananram3740
@saravananram3740 Жыл бұрын
in some requirement, inactive relationship is need to use in DAX as role playing dimension!
@yonisupersaiyanyoni3693
@yonisupersaiyanyoni3693 6 ай бұрын
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
@deshmukram623 2 жыл бұрын
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
@chriskeo392
@chriskeo392 5 ай бұрын
Use collie approach Star schema visual is ugly
@dakshpancholi3185
@dakshpancholi3185 4 күн бұрын
Great content
@user-tl1ds8wi9m
@user-tl1ds8wi9m 10 ай бұрын
Excellent video, several key learnings there that i can take away and implement. Thank you so much 🙏
@user-tl1ds8wi9m
@user-tl1ds8wi9m 10 ай бұрын
Excellent video, several key learnings there that i can take away and implement. Thank you so much 🙏
Microsoft Power BI: The Do’s and Don’ts of Power BI Relationships - BRK3019
1:00:42
Which one is the best? #katebrush #shorts
00:12
Kate Brush
Рет қаралды 21 МЛН
Just try to use a cool gadget 😍
00:33
123 GO! SHORTS
Рет қаралды 61 МЛН
Star schema or single table in Power BI
35:54
SQLBI
Рет қаралды 36 М.
Data modelling 101 with Power BI | Community Webinars
1:10:17
Microsoft Power BI
Рет қаралды 143 М.
Hands-On Power BI Tutorial 📊 Beginner to Pro [Full Course] ⚡
3:02:18
Pragmatic Works
Рет қаралды 2,3 МЛН
Fact & Dimension tables in Power BI | Data Modelling
15:07
The Power BI Guy
Рет қаралды 65 М.
Data Modelling in Power BI | How to do Modelling in Power BI ?
12:45
Indian Paradise Trainer
Рет қаралды 22 М.
DAX by examples
1:11:50
SQLBI
Рет қаралды 210 М.