Data modeling best practices - Part 1 - in Power BI and Analysis Services

Patrick looks at a few data modeling best practices in Power BI and Analysis Services. These are things we see customers doing on a regular basis and you should be aware of it.

********
LET'S CONNECT!
********

***Gear***

#PowerBI #DataModeling #StarSchema

[bcippitelli]

Thanks for that Patrick. I have been using star schema and some good data modeling practices and I have to say: "This is the way". Not only performance is better: design, end user understanding maintenance is much much easier as well. The good practices with Power BI make us Super Power Workers! Thanks again!

[jeremyanderson]

Dude, your videos are incredibly helpful. I've learned a ton from you over the past few weeks!

[dangelo]

I have recently started expanding my knowledge with PBI and your channel has amazing information, examples and tips. I appreciate your work very much! Thank you for your efforts!

[Real]

This is 100% basics right here. Its all review for me but Im watching to support this great channel and to simply keep this fresh in my brain. STAR schema is a must in most cases.

[someshkhatawe]

Adam's dataset video actually worked for my reports. Thank you both 😀😀😀😀

[KuKuTV]

u r one of the best teacher I have been through (few among above 1500 teachers world wide)

[patshanz]

Great video. Smart. Great pace. You very quickly setup the various problem statements, explained the options, and demo'd. You're a great instructor. Thank you!

[marthasanchez-avila]

Love it! I’ve leveraged this process for all sorts of reports, everything from property and date tables to organize my various sources of data. Thanks for the deeper dive .

[kelv]

My experience with the star Schema is mixed especially with independent product tables where it limits your ability analyse to a certain extent. Cross tables was one of them

[riteshclement]

This is so helpful. Can't wait for the other parts to come out.

[hectoralvarorojas]

Great topic you have chosen to talk about it here.
AWESOME video Patrick!


Now I will be waiting for the Part 2.


 Congratulations!

[felipebizarre]

NO WAY YOU CAN HAVE TWO DATA TABLE DISPOSITIONSSS, my mind just exploded ugh Patrick you're and angel sent from MS Heaven

[Randyminder]

There is another drawback to wide tables I think you could have mentioned. When a context transition occurs, the entire table being iterated is brought into memory, uncompressed. For wide tables with lots of rows, this will ravage memory even more.

[laszlokatai-pal]

"I wrote a video" - that's some badass PowerBi skills, mate :D

[bcippitelli]

Thanks for that Patrick. I have been using star schema and some good data modeling practices and I have to say: "This is the way". Not only performance is better, design is easier, understanding is easier and the maintenance is much much easier. The good practices with Power BI make us Power

[nelsonma]

Patrick, as always, you know what I think, AWESOME video. Cheers!

[innocentiuslacrim]

Greetings from Finland. I find your videos really beneficial in getting better in the fundamentals when working with Power BI. Earlier I was working on a project with Cognos where the databases were already ready and I could only work in the UI and then give people with access to backend tasks on what to do there. That was pretty terrible as we were always facing performance issues to the point where individual KPIs were just failing randomly (timeouts). Efficient data modelling is really (REALLY) important when we want people to actually use the tools we create.

[marcocardicchi]

You guys are by far the best at generating good quality inside the Cube! 👍🤟 Keep these video coming!! Thanks

[sugartraders]

Awesome, Patrick, you make this stuff fun - thank you!

[marcosoliveira]

Your report is fast as long your data model is concise.
Great explanation.