- 51
- 151 152
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
Advanced Azure Synapse Analytics - Implement Advanced Concepts in Synapse
Did you know that Azure Synapse Analytics was labeled as an "end-to-end" analytics solution from Microsoft before Fabric became a thing? Many companies still use Synapse as a Platform-as-a-Service offering.
In the 2nd part of the Synapse video series, you'll learn the advanced concepts and features in Azure Synapse Analytics and understand how to implement them in real life scenarios.
In the 2nd part of the Synapse video series, you'll learn the advanced concepts and features in Azure Synapse Analytics and understand how to implement them in real life scenarios.
Переглядів: 140
Відео
Introduction to Azure Synapse Analytics - A Beginner-friendly Guide to End-to-end Analytics
Переглядів 363Місяць тому
Did you know that Azure Synapse Analytics was labeled as an "end-to-end" analytics solution from Microsoft before Fabric became a thing? Many companies still use Synapse as a Platform-as-a-Service offering. In this beginner-friendly video, you'll learn all the essentials of Azure Synapse Analytics and understand the difference between Serverless and Dedicated SQL pool.
DP-700 New Fabric Data Engineer Certificate - Initial thoughts and how it compares to DP-203/DP-600
Переглядів 2,4 тис.2 місяці тому
Microsoft just announced the latest certificate related to Microsoft Fabric: Fabric Data Engineer Associate! What's in the exam, how it compares to the existing DP-203 and DP-600 certificates.
5 Clicks to WOOOOW!!! How changing data types can quickly optimize your Power BI model
Переглядів 3472 місяці тому
Optimizing #PowerBI semantic model doesn't always have to be a daunting and time-consuming task. You can often celebrate many quick and easy wins! In this video, I'll show you how you can transform and optimize your semantic model in literally 5 clicks! Blog: data-mozart.com/ Cardinality: data-mozart.com/cardinality-your-majesty/
Fundamentals of Data Modeling - Part 5: Implementing Physical Data Model!
Переглядів 3403 місяці тому
In this series, you'll learn fundamental concepts of data modeling in general! This series IS NOT related to any specific tool or product, but covers general data modeling concepts and techniques. In Part 5, you'll learn how to implement physical data models. data-mozart.com/
Fundamentals of Data Modeling - Part 4: Understanging Logical Data Model!
Переглядів 2773 місяці тому
In this series, you'll learn fundamental concepts of data modeling in general! This series IS NOT related to any specific tool or product, but covers general data modeling concepts and techniques. In Part 4, you'll learn the understand key characteristics of the Logical data modeling phase. data-mozart.com/
Fundamentals of Data Modeling - Part 3: Understanding Conceptual Data Model!
Переглядів 3363 місяці тому
In this series, you'll learn fundamental concepts of data modeling in general! This series IS NOT related to any specific tool or product, but covers general data modeling concepts and techniques. In Part 3, you'll understand the key characteristics of the Conceptual data modeling phase. data-mozart.com/
Fundamentals of Data Modeling - Part 2: Understanding OLAP Systems!
Переглядів 4784 місяці тому
In this series, you'll learn fundamental concepts of data modeling in general! This series IS NOT related to any specific tool or product, but covers general data modeling concepts and techniques. In Part 2, you'll understand the key characteristics of the OLAP (Online Analytical Processing) systems. data-mozart.com/
Fundamentals of Data Modeling - Part 1: Understanding OLTP Systems!
Переглядів 8314 місяці тому
In this series, you'll learn fundamental concepts of data modeling in general! This series IS NOT related to any specific tool or product, but covers general data modeling concepts and techniques. In Part 1, you'll learn the basics of data structures and understand key characteristics of the OLTP systems. data-mozart.com/
Mastering DP-600 Exam: DAX Window and Information Functions!
Переглядів 2314 місяці тому
"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: mastering-dp-600-exam-dax-for-the-win-part-2-window-functions-and-information-functions DP-600 Certification Learning Resources: data-mozart.com/dp-600-certification/
Mastering DP-600 Exam: DAX Variables and Iterator Functions!
Переглядів 3314 місяці тому
"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/
Power BI Real-Time Reporting made easy with Auto Page Refresh!
Переглядів 8605 місяців тому
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!
Переглядів 7636 місяців тому
Data Lakehouse Demystyfied in 27 Minutes!
Mastering DP-600 Exam: Power BI Direct Lake - Everything you need to know!
Переглядів 1,4 тис.7 місяців тому
Mastering DP-600 Exam: Power BI Direct Lake - Everything you need to know!
Mastering DP-600 Exam: 4 Minutes to Implement a Star Schema in Power BI!
Переглядів 1,1 тис.7 місяців тому
Mastering DP-600 Exam: 4 Minutes to Implement a Star Schema in Power BI!
Mastering DP-600 Exam: Create Your First Lakehouse in Microsoft Fabric!
Переглядів 5968 місяців тому
Mastering DP-600 Exam: Create Your First Lakehouse in Microsoft Fabric!
Mastering DP-600 Exam: Implementing and Validating Object-Level Security
Переглядів 6799 місяців тому
Mastering DP-600 Exam: Implementing and Validating Object-Level Security
Mastering DP-600 Exam: Implementing Field Parameters!
Переглядів 9819 місяців тому
Mastering DP-600 Exam: Implementing Field Parameters!
Mastering DP-600 Fabric Analytics Engineer Exam - Implementing Denormalization
Переглядів 1,8 тис.10 місяців тому
Mastering DP-600 Fabric Analytics Engineer Exam - Implementing Denormalization
RULE 'EM ALL! Create OneLake shortcuts to ANY data source!
Переглядів 1,3 тис.11 місяців тому
RULE 'EM ALL! Create OneLake shortcuts to ANY data source!
Mastering DP-600 Certificate: Understanding Incremental Refresh in Power BI
Переглядів 2,4 тис.11 місяців тому
Mastering DP-600 Certificate: Understanding Incremental Refresh in Power BI
DP600 New MS Fabric Analytics Engineer Certificate - Initial thoughts and how it compares to DP500!
Переглядів 7 тис.Рік тому
DP600 New MS Fabric Analytics Engineer Certificate - Initial thoughts and how it compares to DP500!
Parquet File Format - Explained to a 5 Year Old!
Переглядів 42 тис.Рік тому
Parquet File Format - Explained to a 5 Year Old!
The Ultimate Power BI Performance Tuner Toolbox!
Переглядів 641Рік тому
The Ultimate Power BI Performance Tuner Toolbox!
Power BI Hybrid tables for "Poor" People
Переглядів 548Рік тому
Power BI Hybrid tables for "Poor" People
Setting the right expectations - when to start tuning your Power BI reports?
Переглядів 216Рік тому
Setting the right expectations - when to start tuning your Power BI reports?
Microsoft Fabric - Beyond Hype and Marketing!
Переглядів 4 тис.Рік тому
Microsoft Fabric - Beyond Hype and Marketing!
Enhance User Experience in Power BI with Tooltips!
Переглядів 336Рік тому
Enhance User Experience in Power BI with Tooltips!
Mastering DP-500 Exam: 3 Steps to Troubleshoot any DAX Query!
Переглядів 1,7 тис.2 роки тому
Mastering DP-500 Exam: 3 Steps to Troubleshoot any DAX Query!
Mastering DP-500 Exam: Power BI Aggregations - The Ultimate Guide!
Переглядів 2,8 тис.2 роки тому
Mastering DP-500 Exam: Power BI Aggregations - The Ultimate Guide!
Man, please check your MIC
we want more of this !!!!!!!!!😀
Stay tuned😉
nice explanation, only first one minute was unnecessary.
Glad you liked it
Good video, however it's not dynamic filtering but dynamic change of measures
Thanks for the comment!
Behind The Hype - Is Analytics Engineer a Real Job: ua-cam.com/video/VXnwYuOCT-U/v-deo.html
Yes, this is by far the best explanation of analytics engineering I've seen so far:)
You are soo good, hope people notice these videos and get benefitted. I have just started journey into DE, finding these very useful and easy to understand. Hope to see more videos from you.
Thank you so much! I sincerely appreciate your kind words🙏
How many question has a beta exam?
Hi Claudio, Usually, it's between 50 and 55 questions, plus 2 case studies. Hope this helps.
Thanks for all of this info!
Glad it was helpful!
with new certifications coming up, my decision to pick up an exam has changed 3 times last 3, 4 months, now I can take a wise decision, thank you very much :)
Haha, I totally understand that:) Good luck with whatever exams you take:)
❤
Do you think new projects should utilise this instead of Fabric?
Good question! I'd argue that Fabric will be the first choice for new projects, especially with all the "pushing" from Microsoft's side, and especially if you are building a lake-centric architecture with clear separation between the storage and compute layer
Nikola, it was great to see you last week. Thank you for this video on the new exam.
My pleasure! It was great seeing you as well👍
I’m currently preparing to do the DP-203 exam. Is the DP-203 exam now redundant?
No, it's still here and will be for sure alive at least until the DP-700 goes out of beta, which probably won't happen before the end of this year (or maybe even later). Hope this helps
Is there any sources to get country wise numbers if that 70,000 DP-600 pasing numbers?
It's 17.000, not 70.000:)...I'm sure Microsoft has this info, but the only publicly shared info was the summarized one about 17k...
Great insights as always Nikola
Thanks mate, glad if it helps!
Super informative, thanks a lot!
Glad it was helpful!
You're the best!
Thanks!
So basically it's vertipaq but open source
A kind of! But, yes, very similar to how VertiPaq stores the data
Thanks for this video! This should be part of every Power BI training!
Thank you very much Valerie👍
Thanks Nicola for sharing, small changes can be very powerful.
Absolutely!
This is a classic situation, and it usually appears in Fabric or Power BI certification tests.
True!
Thanks Nicola, I had no idea about Fixed Decimal Numbers storing 4 digits instead of two...
Yes, who would expect that?! But, definitely good to keep in mind
Thanks for the content 🙌🏽🙌🏽
My pleasure!!
This is really awesome and simple explanation. Thanks for doing it
You're very welcome, glad you liked it!
Nice explanations. Is your playlist in the reverse order by the way?
Thank you! Oh, good catch, I'll fix this:)
Very useful; thanks for sharing.
YOu're very welcome, I'm happy to hear that
Loved the "parquet format on steroids" analogy!
Thank you!
Amazing series of videos - thank you! I think we don't have too many videos of Fundamental concepts described in such structured way and most of PBI devs pick this up further down the road.
Thanks Marko, glad you like them!
Great video! Very well explained!
Thank you Valerie! Glad you enjoyed it
Thank you! Great Video!
Thanks Joao, glad to hear that!
excellent video! so much information provided in such short duration
Great to hear!
Hi! Do we always need to publish the semantic model whenever there a (data) change? Is it possible to automatically reflect any (data) changes on the semantic model in the shortcut?
Hi, it depends if you use Import/Direct Query/Direct Lake storage mode for semantic model. For Import mode, you must refresh semantic model to have the latest data from the data source. For Direct Query, it's not necessary, because queries will be generated at the query time and will always retrieve the latest data from the data source. For Direct Lake, you can enable "refresh" (data reframing) under settings "Keep your Direct Lake data up to date". If you are interested to learn how refresh works in Direct Lake, I wrote a blog post some time ago: data-mozart.com/50-shades-of-direct-lake-everything-you-need-to-know-about-the-new-power-bi-storage-mode/ Hope this helps
@@DataMozart Thanks
@@DataMozart Hi, I'm testing this process, but the export command (in the SSAS) do not create the parquet delta files for "direct query tables" from the semantic model. It creates the parquet delta files for the "import tables", and from there we can create the shortcut. Is this also happening to you or are you able to create the delta files for "direct query tables"?
Thank you ... very easy to understand.
Glad to hear that!
thanks man 😊
No problem 👍
Super clear explanation, for non-technical profiles, which is my case, it is much appreciated... Thanks for sharing ¡¡¡
Glad it was helpful!
Excellent explainer! Plan on sharing with colleagues as well!
Awesome, thank you!
THANK YOU! THIS HAS TO BE THE 12TH VIDEO I'VE WATCHED ON PARQUET AND I FINALLY UNDERSTAND.
I'm happy to hear that! Cheers!
@@DataMozart awesome video. super easy to follow. would be amazing if you could upload more video like these with ELI5 format.
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: ua-cam.com/video/dXxv39X884Q/v-deo.html