10 Steps to Optimize Your Data Model in Power BI

Рет қаралды 29,447

Күн бұрын

Join my Power BI Design training here: my.datatraining.io/pages/powe...
Download files here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ 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 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on KZfaq: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* 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

Пікірлер: 50

@zacharyfriedman8709 14 күн бұрын

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.

@dominiksch4928 13 күн бұрын

same here - especially it is from Marco Russo who allready published some solid DAX literature.

@shauntck 12 күн бұрын

Yes external tools video would be huge

@smartrose7997 10 күн бұрын

Requesting same …

@suhasvlogs7490 10 күн бұрын

I am also requesting to be video on external tools

@neerpanwar 14 күн бұрын

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

@user-jp5fg7cb1e 13 күн бұрын

I wanted to give a 'haha' react for this

@naylord5 14 күн бұрын

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.

@wilconagtzaam587 14 күн бұрын

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

@cdamordakai Күн бұрын

I’ve learned sooo much with this video man!! Thanks!!!

@w13ken 13 күн бұрын

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.

@nizararena 13 күн бұрын

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 !!

@StrategySafari 12 күн бұрын

Awesome, simply explained and on point. Big thanks 👍🏻

@javiersolarirazabal7089 14 күн бұрын

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.

@user-gh8xp1pq1c 14 күн бұрын

very concise, nice

@adityapadmawar8754 13 күн бұрын

Very informative video. Thank you for creating this one.

@renatopedrozo1561 13 күн бұрын

Solid and very well-explained video, congrats!

@roverre61 13 күн бұрын

Always fashinated on a way you explain and share very helpful informations. Thanks alot... BRAVO..!!!

@zy0305 12 күн бұрын

Wow, what a great video. It helps a lot. Looking forward to see similar video like this

@TOV-zc9bp 12 күн бұрын

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. 👨‍🎓👩‍🎓

@gauthamambethkar4483 13 күн бұрын

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

@LeighRadmore 14 күн бұрын

Do you have any experience with the Aggregated Tables feature and is it a good way to improve semantic model performance? What are your thoughts on an having enterprise level 'Golden Model' - one with multiple dimension and fact tables for cross fact reporting - vs composite modelling?

@stevefox7469 13 күн бұрын

Great content.

@listenapc 14 күн бұрын

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.

@HowtoPowerBI 14 күн бұрын

here you go 😊 kzfaq.info/get/bejne/rZp-e66Qz8_ehas.html

@listenapc 14 күн бұрын

@@HowtoPowerBI it is amazing the amount of things you can accomplish with Power BI (albeit inefficiently) without having a grasp of the basics, much appreciated.

@shahzadkheros 13 күн бұрын

impressive

@RohiGupta 11 күн бұрын

2 more suggestions from my side: Preference for Custom column in Power Query instead of Calculated columns in the model. Also, disable Power Query query load for unwanted tables.

@David-id6jw 13 күн бұрын

Power BI Helper seems to have last updated in 2021. I assume that means it won't work with reports saved in PBIP format? Will the other tools you mentioned do so? PBIP has been amazing for version control.

@sanchowitfurrows1561 6 күн бұрын

One more reason to prefer calculated (DAX) columns vs custom (Power Query) column for strings concatenation: DAX allows to use emoji 😎😎 while Power Query seems to be limited

@jnordheim85 14 күн бұрын

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?

@joriskempen5650 12 күн бұрын

also curious on this!

@logocreative1694 13 күн бұрын

Hi I have doubts about the drop down without single select slicer is this possible to when we select any category in the slicer then the slicer pop up does not disappear automatically when we have to click any other place then the slicer pop up disappear. Any solution i want when we click on the category in slicer then the slicer pop up automatically disappears.

@Ven0m0306 9 күн бұрын

What are the best power bi books you would recommend. All around and also dax. Thank you guys in advance

@HowtoPowerBI 9 күн бұрын

the top recommendations on amzn r all good

@RobertoStaltari 13 күн бұрын

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.

@Gandunomics007 14 күн бұрын

MSMGQM (Model, Script, Manage, Query, Generate, Monitor) Power BI External Tool HOW to install this external tool! can you please provide the link for this tool ?

@CallumLawn 14 күн бұрын

Not convinced on Snowflake being worse! Some metrics to back up your argument would be nice. Compression benefits can outweigh the impact of additional joins.

@flynt1983 14 күн бұрын

There are no compression benefits with snowflake. Only the distinct values matter in column store. No of rows doesn’t matter much. But joins do matters, and a lot.

@suketududhat 14 күн бұрын

I have always struggled with step number 1 to remove unused columns and tables because we use golden datasets with many live connection reports created by our team and outside users for their own analysis. Any tips for this?

@flynt1983 14 күн бұрын

Start small, then add columns on demand. As of now, there is no tool to analyze what columns are used in LC by self service reports.

@gangababupatchipala3613 Күн бұрын

Use Measure Killer tool, using this you can analyse live connection reports and identify unused measures and columns. This tool will help us to delete these unused objects in dataset automatically. We don’t need to do it manually

@aceshorts2632 12 күн бұрын

My workplace will not allow an external tool😊

@Niyasudheeak 7 күн бұрын

‼️ urgent ‼️ Hi Bas, I would like to know, what are the add on certification should i take in order to learn power bi eco system, Certification such as DP 900, AZ 900.. there is a certification drive going on in company at free of cost… Let me know

@HowtoPowerBI 7 күн бұрын

Dp 600 pl 300

@javiersolarirazabal7089 14 күн бұрын

not big fan of calculated column though

@warwickleahyssw4163 6 күн бұрын

As always. Great video with some awesome tips. I have learnt so much from your videos.