Video

😍

share details video if possible ❤❤🔥

This is Gold for PBI learners ! :) Thank You Man !

please share details video

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

My workplace will not allow an external tool😊

Gast, dit is echt precies wat ik nodig had. Hartelijk bedankt man! Ik heb me gelijk even geabonneerd, stuur maar door die video's!!

I did not have date column I will do forecasting that possible?

i have done the calculations the same way, however my gross margin isn't showing. Is it because the gross margin is not a description in my actual financial data?

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

best video in the topic

Great content.

Very informative video. Thank you for creating this one.

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.

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

can someone explain about the four quotation marks functioned?

Thanks

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.

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

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

How does visual 1 work when you don't use data Intelligence? I just display my year and month columns on the x-axis, but by creating the measures with my Date column from my Calendar table I only get Bars and no lines. Love your stuff btw, very nice videos!

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.

impressive

Solid and very well-explained video, congrats!

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.

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?

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

not big fan of calculated column though

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.

Saw the short for this video, it’s soooo fkn clean man! It’s late night now, but I’ll go sleep for now.

Man that’s so clean!

Thank you so much

Insert image or Column data type image URL?

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.

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 ?

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

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.

Another useful and interesting lesson... I love how you explain everything with detailed examples. Thank you very much!!!

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?

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.