Mastering DP-500 Exam: Power BI Aggregations - The Ultimate Guide!

Are you considering taking the DP-500 Microsoft exam to become a certified Enterprise Data Analyst? In this video, you'll learn about one of the most important features in Power BI - aggregations! You'll understand why we need aggregations, how they work and how to configure them properly, so your Power BI reports run much faster.
Buy a full DP-500 on-demand course: learn.data-mozart.com/courses...
Book DP-500 Training: data-mozart.com/shop/
Blog: data-mozart.com
Twitter: / datamozart
Andy Cutler's YT channel: / datahaibi

[@shahzadkheros]

Great Tip

[@DataMozart]

Glad it was helpful!

[@joaorataoo]

Thanks Nikola, very clear and very good explanation.
Keep going!!!

[@DataMozart]

Cheers Joao, you're welcome!

[@robertbarkovicz800]

Great explanations, I subscribed!

[@DataMozart]

Awesome, thank you!

[@sarveshdeshpande1772]

Very nicely explained ... Thanks Nikola for this great video !!

[@DataMozart]

Glad it helped!

[@shuwylicious]

Thank you for sharing 🙂

[@DataMozart]

My pleasure 😊

[@NK-xw4uu]

Can I ask why you didn't connect the date dimension to the aggregate tables?

[@DataMozart]

At 12:52, there is a big annotation not to forget to create relationships between Date dimension and aggregated tables:)

[@justinogarcia3705]

Thanks for the video

[@DataMozart]

You're welcome!

[@KAshIf0o7]

Thanks Nikola learned few tricks from this.

[@DataMozart]

You're welcome Kashif, happy to hear that!

[@anandkumar-np2od]

Hi Nikola, I have a question regarding Manage Aggregations. Since, you have already did the aggregations while creating the Agg tables, may I know why again you are doing aggregations using Manage Aggregations? Can you please clarify?

[@DataMozart]

Hi,
I've created agg tables on the data source, but if you don't make Power BI "aware" of aggregations (by using Manage aggregations), when you use fields from the original Direct Query table, your aggregated tables won't be used in the queries, even though that the query can be satisfied from agg tables. Hope this helps.