10 Steps to Optimize Your Data Model in Power BI

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
00:13 Step 1
00:48 Step 2
01:54 Step 3
02:56 Step 4
04:34 Step 5
05:32 Step 6
07:12 Step 7
08:30 Step 8
09:20 Step 9
11:22 Step 10
13:06 End

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support! 💪 🙏

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

[zacharyfriedman]

Honestly, I didn't even know about external tools like Bravo. Downloaded immediately. What a time saver. A whole video on your favorite external tools and how you utilize them in action would be great.

[neerpanwar]

Aggregation is good, but there is always someone who would want to drill down to more details! :D

[naylord]

This video is pure gold! Thank you so much for sharing master.
Definitely when someone ask me for optimizations, this is the only resource I'll need to recommend.

[gauthamambethkar]

Hi Bas,
Excellent video again from you. I have a doubt, at 6:45 when you say, “use a filter measure instead” what do you mean? I didn’t understand this part alone.

Thank you for the awesome video again

[nizar_arena]

Hey Bas,
Thanks again for the video, very informative.
I just wanted to point out :
Step 3: it would be much preferred to push all of the calculations, group by functions to the DataMart in case the user's have one.
Step 10: the incremental refresh kind of will help with the import mode since you only import your data once then in the workspace it will create partitions of that data that will be stored and not changed and depending on how you want the data to be refreshed and when you know for example that your data after 2 weeks will not change you can set it up and your data will be stored in the workspace.

Thanks again for the video !!

PS: when will you do a video about the power bi extension you use and how you use them, it will be great !!

[ViníciusSantana-zc]

That's the best Power Bi Youtube Channel. Congrats.

[cristianofonseca]

Mate, your videos are great! They are a real deep dive into PBI for more advanced folks.

[jaapviguurs]

What do you think about using bidirectional filtering when using a unified star schema in power BI? Would love a video about the combination of the USS and practises in Power BI

[RobertoStaltari]

99% of those who build reports with Power BI use the "Click, drag and drop until it works" approach, so all these very valuable hints are just ignored. Still Bas is so good to be able to condense in a few minutes plenty of essential hints.

[wilconagtzaam]

Great video, next time people ask me for best practices on Data Modelling I can just share this video 👍

[sunsetseeker]

Thank you. I really enjoy your tutorials. They are so informative. Can't wait for your next video

[jnordheim]

Is the measure in the filter pane at 6:45 in case 6 being meant to be used as a better alternative compared to the bidirectional relationship?

[wken]

Thanks Bas, excellent tips. I love Tip 3 about switching off the hidden date/time tables being created in the background - this is a new one to me. Keeping in mind cardinality & where data types could be switched to numeric are also great reminders. I will be following the advice given here.

[TOV-zcbp]

10 Steps to Optimize Your Data Model are a pragmatic way,
before transferring your Data Model from Test to Production environment.

A couple of the 10 steps are also explained in the course material for Microsoft Power BI Data Analyst (PL-300) certification. 👨‍🎓👩‍🎓

[javiersolarirazabal]

Excelent work, very well condensed in 10 min. Many users do not pay attention to maintenance and optimization and I think that that is a mistake.

[listenapc]

Hi Bas, first I'd like to thank you for your content as it has helped me inmensely on my Power BI journey. I was wondering if you had any resources/strategies on how to go from the flat table to a simple star schema as you describe on step 4. Thanks again.

[walterstevens]

This was great thanks. I still battle to understand some basic things, like when you you create relationships (is it necessary for a type star model?) versus when you you do joins/merges? For example if you do a merge in PQ then that's a join (?), but if you create relationships using the model view and use a field from another table in a visual is that a join too?

[Alvarolingua]

About the last part... Which is better to use as source, excel or access? I'm having issues to auto update access from power bi online

[calebjones]

Cheers for the video! Do you have any more tips for those who can't use external tools like bravo due to security reasons? Recently started at a large company and need to optimise some reports that are very large due to scope creep, is it just a case of looking at all the visuals and checking to see what columns aren't used etc?

[Grstuff]

Love your off topic a bit, I have a question regarding the forecasting model. In previous version PB displayed the Forecast, Upper bound and Lower bound totals when "show as table". Those totals are not displaying with the latest version. Is this a bug?