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

  Рет қаралды 2,756

Data Mozart

Data Mozart

Күн бұрын

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

Пікірлер: 18
@joaorataoo
@joaorataoo Жыл бұрын
Thanks Nikola, very clear and very good explanation. Keep going!!!
@DataMozart
@DataMozart Жыл бұрын
Cheers Joao, you're welcome!
@shahzadkheros
@shahzadkheros Жыл бұрын
Great Tip
@DataMozart
@DataMozart Жыл бұрын
Glad it was helpful!
@sarveshdeshpande1772
@sarveshdeshpande1772 Жыл бұрын
Very nicely explained ... Thanks Nikola for this great video !!
@DataMozart
@DataMozart Жыл бұрын
Glad it helped!
@robertbarkovicz800
@robertbarkovicz800 Жыл бұрын
Great explanations, I subscribed!
@DataMozart
@DataMozart Жыл бұрын
Awesome, thank you!
@KAshIf0o7
@KAshIf0o7 Жыл бұрын
Thanks Nikola learned few tricks from this.
@DataMozart
@DataMozart Жыл бұрын
You're welcome Kashif, happy to hear that!
@shuwylicious
@shuwylicious Жыл бұрын
Thank you for sharing 🙂
@DataMozart
@DataMozart Жыл бұрын
My pleasure 😊
@justinogarcia3705
@justinogarcia3705 Жыл бұрын
Thanks for the video
@DataMozart
@DataMozart Жыл бұрын
You're welcome!
@NK-xw4uu
@NK-xw4uu 9 ай бұрын
Can I ask why you didn't connect the date dimension to the aggregate tables?
@DataMozart
@DataMozart 9 ай бұрын
At 12:52, there is a big annotation not to forget to create relationships between Date dimension and aggregated tables:)
@anandkumar-np2od
@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
@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.
Mastering DP-500 Exam: 3 Steps to Troubleshoot any DAX Query!
11:56
Они убрались очень быстро!
00:40
Аришнев
Рет қаралды 2,5 МЛН
UFC 302 : Махачев VS Порье
02:54
Setanta Sports UFC
Рет қаралды 1,4 МЛН
ELE QUEBROU A TAÇA DE FUTEBOL
00:45
Matheus Kriwat
Рет қаралды 36 МЛН
Data Lakehouse Demystyfied in 27 Minutes!
27:23
Data Mozart
Рет қаралды 348
How much does a DATA ENGINEER make?
0:38
Broke Brothers
Рет қаралды 569 М.
RULE 'EM ALL! Create OneLake shortcuts to ANY data source!
17:56
How to Successfully Pass the DP-500 Certification?
10:56
Azure Synapse Analytics
Рет қаралды 3,9 М.
Power BI Hybrid tables for "Poor" People
11:21
Data Mozart
Рет қаралды 460
Switching to Android after WWDC 2024.. Quitting Apple Ecosystem!
10:19
keren sih #iphone #apple
0:16
Muhammad Arsyad
Рет қаралды 1,1 МЛН
Самый топовый ПК без RGB подсветки
1:00
CompShop Shorts
Рет қаралды 162 М.
Задача APPLE сделать iPHONE НЕРЕМОНТОПРИГОДНЫМ
0:57
iPhone 15 Unboxing Paper diy
0:57
Cute Fay
Рет қаралды 3 МЛН
How To Unlock Your iphone With Your Voice
0:34
요루퐁 yorupong
Рет қаралды 20 МЛН