![Data Mozart](/img/default-banner.jpg)
- 39
- 114 919
Data Mozart
เข้าร่วมเมื่อ 4 ต.ค. 2020
I make music from data!
Power BI and Microsoft Fabric addict, passionate about everything related to data!
Microsoft Data Platform MVP and MCT
data-mozart.com
learn.data-mozart.com/
DataMozart
Power BI and Microsoft Fabric addict, passionate about everything related to data!
Microsoft Data Platform MVP and MCT
data-mozart.com
learn.data-mozart.com/
DataMozart
Mastering DP-600 Exam: DAX Variables and Iterator Functions!
"DAX is simple, but not easy!" In this video, we cover two important concepts necessary for successfully completing the DP-600 exam!
Accompanying blog post: data-mozart.com/mastering-dp-600-exam-dax-for-the-win-part-1-variables-and-iterators/
DP-600 Certification Learning Resources: data-mozart.com/dp-600-certification/
Accompanying blog post: data-mozart.com/mastering-dp-600-exam-dax-for-the-win-part-1-variables-and-iterators/
DP-600 Certification Learning Resources: data-mozart.com/dp-600-certification/
มุมมอง: 103
วีดีโอ
Power BI Real-Time Reporting made easy with Auto Page Refresh!
มุมมอง 51914 วันที่ผ่านมา
Make your users happy and ensure that they automatically see the latest data in their Power BI reports! Blog: data-mozart.com/ Master DP-600 certificate: data-mozart.com/dp-600-certification/
Data Lakehouse Demystyfied in 27 Minutes!
มุมมอง 453หลายเดือนก่อน
Learn all the essentials about the emerging data lakehousing concept in less than half an hour! We cover various needs for lakehouse architecture, as well as secrets behind the open storage formats and medallion architecture! Stay up to date with the latest data trends: data-mozart.com/
Mastering DP-600 Exam: Power BI Direct Lake - Everything you need to know!
มุมมอง 1K2 หลายเดือนก่อน
Have you heard about the "latest and greatest" feature in Microsoft Fabric? Not sure if Direct Lake IS the way to go when using Power BI in Fabric? This video will teach you everything you need to know in 10 minutes! DP-600 Certification page: data-mozart.com/dp-600-certification/ Data Mozart learning platform: learn.data-mozart.com/
Mastering DP-600 Exam: 4 Minutes to Implement a Star Schema in Power BI!
มุมมอง 7342 หลายเดือนก่อน
You've heard that Star schema IS the preferred way for modeling data in your #PowerBI semantic models. But, how do you create one? It's easier than you can imagine! In this video, I'll walk you through the entire process of creating a star schema in Power BI, and in just 4 minutes you'll have a proper data model in place! Visit Data Mozart site: data-mozart.com/ DP-600 certification page: data-...
Mastering DP-600 Exam: Create Your First Lakehouse in Microsoft Fabric!
มุมมอง 5203 หลายเดือนก่อน
Watch this step-by-step tutorial to create your first lakehouse in Microsoft Fabric! Although it's a fairly straightforward process, I'll show you some of the things you should be aware of. Get ready for the DP-600 exam: data-mozart.com/dp-600-certification/ Check all of my courses: learn.data-mozart.com/
Mastering DP-600 Exam: Implementing and Validating Object-Level Security
มุมมอง 5614 หลายเดือนก่อน
Object-level security is one of the key security features in #PowerBI and Tabular model! In this video, I show you how easy is to implement and validate OLS, by using Tabular Editor external tool. You'll also learn the difference between Object-level and Row-level security. This video is part of the Mastering DP-600 Fabric Analytics Engineer learning path! data-mozart.com/dp-600-certification/
Mastering DP-600 Exam: Implementing Field Parameters!
มุมมอง 8475 หลายเดือนก่อน
Field Parameters is one of the coolest features that were recently introduced in Power BI! In this video, I'll explain what Field Parameters are and how you can implement them in your Power BI reports. This topic is part of the DP-600 (Fabric Analytics Engineer) certificate. DP-600 certification page: data-mozart.com/dp-600-certification/
Mastering DP-600 Fabric Analytics Engineer Exam - Implementing Denormalization
มุมมอง 1.6K5 หลายเดือนก่อน
Let's continue our DP-600 learning journey! In this video, I explain what is denormalization in data modeling, and how to apply denormalization by using Power Query in Power BI. Check the dedicated DP-600 certification page: data-mozart.com/dp-600-certification/ Enroll for free in the Data Mozart learning platform: learn.data-mozart.com/
RULE 'EM ALL! Create OneLake shortcuts to ANY data source!
มุมมอง 9726 หลายเดือนก่อน
OneLake shortcuts! They are super cool, right? But, shortcuts are supported only for other #MicrosoftFabric items, such as lakehouses, plus ADLS Gen2, Amazon S3, and Dataverse...We can't create shortcuts to on-prem data sources, such as SQL Server, right? RIGHT?! Well, yes and no! In this video, I explain how to create "shadow shortcuts" to any data source that is part of the #powerbi semantic ...
Mastering DP-600 Certificate: Understanding Incremental Refresh in Power BI
มุมมอง 2K7 หลายเดือนก่อน
How many times have you bragged about the following: oh, no, I need to refresh my fact table, but it takes soooo long…Maybe it was happening because you haven’t used one of the key performance features when it comes to the data refresh process. In this video, you'll learn everything you need to know about the incremental refresh feature in Power BI! Check all DP-600 relevant articles: data-moza...
DP600 New MS Fabric Analytics Engineer Certificate - Initial thoughts and how it compares to DP500!
มุมมอง 6K7 หลายเดือนก่อน
Microsoft just announced the latest certificate related to Microsoft Fabric: Fabric Analytics Engineer Associate! What's in the exam, how it compares to the existing DP-500 certificate, and what are the resources to prepare for the new exam. Study guide for DP-500: learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-500 Study guide for DP-600: learn.microsoft.com/en-u...
Parquet File Format - Explained to a 5 Year Old!
มุมมอง 23K7 หลายเดือนก่อน
Parquet file format has become a de-facto standard for storing data nowadays. This video will teach you EVERYTHING you should know about Parquet and Delta formats, in an easy-to-understand way. data-mozart.com/parquet-file-format-everything-you-need-to-know/
The Ultimate Power BI Performance Tuner Toolbox!
มุมมอง 6187 หลายเดือนก่อน
Find out what EVERY Power BI professional needs to have in their performance tuning toolbox! I'll show you 4 amazing FREE external tools and how to leverage them to optimize your Power BI solutions. Learn more about Power BI: learn.data-mozart.com/ DAX Studio: daxstudio.org/ Tabular Editor 2: github.com/TabularEditor/TabularEditor Bravo for Power BI: bravo.bi/ VertiPaq Analyzer: www.sqlbi.com/t...
Power BI Hybrid tables for "Poor" People
มุมมอง 472ปีที่แล้ว
Power BI Hybrid tables for "Poor" People
Setting the right expectations - when to start tuning your Power BI reports?
มุมมอง 206ปีที่แล้ว
Setting the right expectations - when to start tuning your Power BI reports?
Microsoft Fabric - Beyond Hype and Marketing!
มุมมอง 3.8Kปีที่แล้ว
Microsoft Fabric - Beyond Hype and Marketing!
Enhance User Experience in Power BI with Tooltips!
มุมมอง 285ปีที่แล้ว
Enhance User Experience in Power BI with Tooltips!
Mastering DP-500 Exam: 3 Steps to Troubleshoot any DAX Query!
มุมมอง 1.6Kปีที่แล้ว
Mastering DP-500 Exam: 3 Steps to Troubleshoot any DAX Query!
Mastering DP-500 Exam: Power BI Aggregations - The Ultimate Guide!
มุมมอง 2.8Kปีที่แล้ว
Mastering DP-500 Exam: Power BI Aggregations - The Ultimate Guide!
Mastering DP-500 Exam: Design and Build a Large Format Dataset in Power BI!
มุมมอง 2.4K2 ปีที่แล้ว
Mastering DP-500 Exam: Design and Build a Large Format Dataset in Power BI!
Mastering DP-500 Exam: Azure Synapse Analytic Pools Demistifyed!
มุมมอง 2.2K2 ปีที่แล้ว
Mastering DP-500 Exam: Azure Synapse Analytic Pools Demistifyed!
Mastering DP-500 Exam: When to use DirectQuery in Power BI!
มุมมอง 2.6K2 ปีที่แล้ว
Mastering DP-500 Exam: When to use DirectQuery in Power BI!
Mastering DP-500 Exam: External Tools in Power BI!
มุมมอง 6K2 ปีที่แล้ว
Mastering DP-500 Exam: External Tools in Power BI!
How to avoid bi-directional relationship for slicers cross-filtering in Power BI!
มุมมอง 2.2K2 ปีที่แล้ว
How to avoid bi-directional relationship for slicers cross-filtering in Power BI!
SQLBits Workshop: Cracking Power BI Performance Tuning!
มุมมอง 1952 ปีที่แล้ว
SQLBits Workshop: Cracking Power BI Performance Tuning!
Implicit VS Explicit Measures in Power BI!
มุมมอง 5322 ปีที่แล้ว
Implicit VS Explicit Measures in Power BI!
How (not) to break Power BI Query folding by changing data types!
มุมมอง 2K2 ปีที่แล้ว
How (not) to break Power BI Query folding by changing data types!
Understand Query folding in Power BI in 13 minutes!
มุมมอง 1.6K2 ปีที่แล้ว
Understand Query folding in Power BI in 13 minutes!
While connecting sharepoint excel to power bi getting error as the data in the preview has been truncated due to size limits. Pls assist i need to link the file to bi
Wry concise and clear tutorial. Keep up the great work. Subscribed
Awesome, thank you!
Best and clear explanation of parquet format
Glad you think so! Thanks!
not shown in power bi
You must use DirectQuery or composite model with at least one DirectQuery source to be able to leverage Auto Page Refresh feature. Hope this helps
Is pro license enough if we select auto page refresh?
Love it. Great explanation to contrast between parquet and rdbms; lake house and warehouse. Thanks for making the video. Love the string music intro.
Glad you enjoyed it! Thanks for the feedback
Awesome explanation! Thanks for it man !
Cheers! Happy you found it useful
Just an outstanding explanation
Thank you, I'm happy to hear that!
That is an awesome explanation; thanks, Nikola.
Glad you enjoyed it!
Nice meeting you in Houston PBI user meetup on May 22. I enjoy the video… great blend of concept and practical demo in a brief video. One of the best videos on direct lake. Thanks for sharing
Awesome, thank you! Same here, it was great meeting you in Houston
awesome video with a great detailing. Thanks a lot for explaining.
You are welcome! Glad you find it useful
Trust me even 10 year old won't understand this.
nice video
Thank you!
Hi Nikola This is awesome. I have a query through in the implementation part. Since, the fields do not exist in the model (As per the error description in PBI Desktop with OLS applied) for a specific role, the visuals break. This means, the report author has to create another version of the report without using the fields included in OLS (To provide a seamless experience avoiding visual breakage error). Is my understanding correct ? Or there is a way to achieve this with a single copy of report supporting different roles ? (As in case of RLS) Please share some light. Many Thanks. Pratik
I found here an implementation solution for this problem: th-cam.com/video/dXxv39X884Q/w-d-xo.html
Thank you so much!!!! Its such a good explanation!
Glad it was helpful!
Incredible summary, thank you!!
Glad you liked it!
Great explanation! Thank you
Glad it was helpful!
DP500 will be discontinued, right?
Yes, it will be retired by the end of April 2024
Wow very detail explanation
Glad you liked it
Thank you for this clear explanation!!!
Glad it was helpful!
Can you also please create a video on avro and orc file format?
It's on my to-do list
@@DataMozart yeah , waiting for this.
You didn't really explain it to a 5 year old. I am older than that, have experience with databases including low level storage, have a proven IQ level over the average but I am still at a lost after your video. So what does a parquet file look like physically? How do you create a parquet file? Answers to such questions are missing.
Really sorry that you didn't find the video useful:(
proven IQ level over average =)))))
This is fire! Thank you so much!
Glad you like it!
I just passed the DP-600 exam.
Woohoo, congrats!
great detailed explanation in short time, well done!
Hvala Nemanja!
Good short video. Thanks.
Cheers Donald, glad you liked it!
great video!
Glad you enjoyed it
Hi please suggest can i import 3-5 million records into power bi desktop from sql server... Is this possible for pro users. Thanks in advance
Hi, it depends how many columns you have, their cardinality, etc. But, in most cases, yes, 3-5 million rows can be easily imported in Power BI.
Great explanations! Thank you!
You're very welcome!
It was exactly the video that I was looking for, thank you!
Thanks, I'm happy to hear that!
This was cool .Thanks for sharing !
Glad you enjoyed it
Great stuff as always :)
Thanks my friend!
excellent info, thanks for sharing
Glad it was helpful!
awesome video, the best video explaining parquet file!
Glad it was helpful!
Can we create shortcut to Oracle database from fabric?
No, at this moment it's still not available.
Thanks for quick response
Dark ages of PBI 👊 Great video Nikola, thanks for sharing! I do believe Field Parameters help end users a lot in their analysis and understanding of the data while keeping the report pages cleaner. Cheers
Cheers Fernando, couldn't agree more with you about Field parameters👍
"it takes a long time to make a story short" With so many hour-long techtube vids I appreciate how clear and concise you explained this topic!
Thank you, I'm glad to hear that!
Very helpful! I need to start making better use of incremental refresh, I've been neglecting it!!
Glad it was helpful! Yes, IR is very important optimization feature!
Thank you, Nikola. That is a very nice explanation, as usual.
My pleasure! Glad that you liked it👍
хахах ме изнасмеа со ова poor
😀😀😀
Hi Nicola, thank you for referring to my question 🙂 Greate start into live-streaming!
Thank YOU for the great question!
well explained
Thank you, I'm glad if it helps!
Can you share the link for DP600 exam as I was not present
Sure, there you go: learn.microsoft.com/en-us/credentials/certifications/exams/dp-600/
good summary! well done 😉
Thanks! 😃
Excellent video... Big thanks!!!
You are welcome! I'm glad you liked it👍
great video! One question: how can we use powerBI desktop to work with Direct Lake? Currently it is not allowed, but are there any workarounds to it? Lets say I have an existing report based on ADLS Gen2. If I do the shortcut to One Lake and use SQL endpoint to replicate it and publish it with Import mode, can it be switched to use direct lake instead? Or do I have to re-create measures, data model, visuals etc in powerBI service from scratch in order to use Direct lake connection? Thanks
Hi. As far as I know, Direct Lake is not working (yet) with Power BI Desktop. Hm, I'm not sure that the workaround you mentioned could work, because I believe you can't switch from import to Direct Lake. Cheers!
Great Video, Thankyou!
You're welcome! Happy to hear that you like it!
Very apt!
Thanks!
Very thought-inducive, was listening in the background and had to check if subscribed already. Thank you
Cheers, thanks!
Very nice ,nikola !!!
Thanks mate👍
Good content for PowerBI incremental refresh
Thanks!