Data Mozart
Data Mozart
  • 51
  • 151 152
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.
Переглядів: 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!

КОМЕНТАРІ

  • @youtubepremium8740
    @youtubepremium8740 4 дні тому

    Man, please check your MIC

  • @abdulmaleekmubaraq
    @abdulmaleekmubaraq 7 днів тому

    we want more of this !!!!!!!!!😀

  • @rahulvashishth8551
    @rahulvashishth8551 12 днів тому

    nice explanation, only first one minute was unnecessary.

  • @MicheldeWit
    @MicheldeWit 17 днів тому

    Good video, however it's not dynamic filtering but dynamic change of measures

    • @DataMozart
      @DataMozart 7 днів тому

      Thanks for the comment!

  • @rommelbojorgee.8902
    @rommelbojorgee.8902 21 день тому

    Behind The Hype - Is Analytics Engineer a Real Job: ua-cam.com/video/VXnwYuOCT-U/v-deo.html

    • @DataMozart
      @DataMozart 20 днів тому

      Yes, this is by far the best explanation of analytics engineering I've seen so far:)

  • @yournabi
    @yournabi 29 днів тому

    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.

    • @DataMozart
      @DataMozart 28 днів тому

      Thank you so much! I sincerely appreciate your kind words🙏

  • @clvc699
    @clvc699 Місяць тому

    How many question has a beta exam?

    • @DataMozart
      @DataMozart Місяць тому

      Hi Claudio, Usually, it's between 50 and 55 questions, plus 2 case studies. Hope this helps.

  • @lreginamend
    @lreginamend Місяць тому

    Thanks for all of this info!

  • @arunsundar3739
    @arunsundar3739 Місяць тому

    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 :)

    • @DataMozart
      @DataMozart Місяць тому

      Haha, I totally understand that:) Good luck with whatever exams you take:)

  • @johnj108
    @johnj108 Місяць тому

  • @notoriousft
    @notoriousft Місяць тому

    Do you think new projects should utilise this instead of Fabric?

    • @DataMozart
      @DataMozart Місяць тому

      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

  • @deanj5961
    @deanj5961 2 місяці тому

    Nikola, it was great to see you last week. Thank you for this video on the new exam.

    • @DataMozart
      @DataMozart 2 місяці тому

      My pleasure! It was great seeing you as well👍

  • @Gius3pp3K
    @Gius3pp3K 2 місяці тому

    I’m currently preparing to do the DP-203 exam. Is the DP-203 exam now redundant?

    • @DataMozart
      @DataMozart 2 місяці тому

      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

  • @azizquazi
    @azizquazi 2 місяці тому

    Is there any sources to get country wise numbers if that 70,000 DP-600 pasing numbers?

    • @DataMozart
      @DataMozart 2 місяці тому

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

  • @JpLouw
    @JpLouw 2 місяці тому

    Great insights as always Nikola

    • @DataMozart
      @DataMozart 2 місяці тому

      Thanks mate, glad if it helps!

  • @bernasiakk
    @bernasiakk 2 місяці тому

    Super informative, thanks a lot!

    • @DataMozart
      @DataMozart 2 місяці тому

      Glad it was helpful!

  • @AyushSrivastava-gh7tb
    @AyushSrivastava-gh7tb 2 місяці тому

    You're the best!

  • @FedericoLov
    @FedericoLov 2 місяці тому

    So basically it's vertipaq but open source

    • @DataMozart
      @DataMozart 2 місяці тому

      A kind of! But, yes, very similar to how VertiPaq stores the data

  • @PorcuBI
    @PorcuBI 2 місяці тому

    Thanks for this video! This should be part of every Power BI training!

    • @DataMozart
      @DataMozart 2 місяці тому

      Thank you very much Valerie👍

  • @baskis69
    @baskis69 2 місяці тому

    Thanks Nicola for sharing, small changes can be very powerful.

  • @moisesgonga1302
    @moisesgonga1302 2 місяці тому

    This is a classic situation, and it usually appears in Fabric or Power BI certification tests.

  • @pawewrona9749
    @pawewrona9749 2 місяці тому

    Thanks Nicola, I had no idea about Fixed Decimal Numbers storing 4 digits instead of two...

    • @DataMozart
      @DataMozart 2 місяці тому

      Yes, who would expect that?! But, definitely good to keep in mind

  • @moisesgonga1302
    @moisesgonga1302 2 місяці тому

    Thanks for the content 🙌🏽🙌🏽

  • @Truthhurt419
    @Truthhurt419 2 місяці тому

    This is really awesome and simple explanation. Thanks for doing it

    • @DataMozart
      @DataMozart 2 місяці тому

      You're very welcome, glad you liked it!

  • @socialconnect7787
    @socialconnect7787 2 місяці тому

    Nice explanations. Is your playlist in the reverse order by the way?

    • @DataMozart
      @DataMozart 2 місяці тому

      Thank you! Oh, good catch, I'll fix this:)

  • @VictorHugo-bd3bf
    @VictorHugo-bd3bf 3 місяці тому

    Very useful; thanks for sharing.

    • @DataMozart
      @DataMozart 2 місяці тому

      YOu're very welcome, I'm happy to hear that

  • @njacob4338
    @njacob4338 3 місяці тому

    Loved the "parquet format on steroids" analogy!

  • @MarkoR_PBI
    @MarkoR_PBI 3 місяці тому

    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.

    • @DataMozart
      @DataMozart 3 місяці тому

      Thanks Marko, glad you like them!

  • @PorcuBI
    @PorcuBI 3 місяці тому

    Great video! Very well explained!

    • @DataMozart
      @DataMozart 3 місяці тому

      Thank you Valerie! Glad you enjoyed it

  • @joaovictorf.r.s.1570
    @joaovictorf.r.s.1570 3 місяці тому

    Thank you! Great Video!

    • @DataMozart
      @DataMozart 3 місяці тому

      Thanks Joao, glad to hear that!

  • @dheemanthgrao2204
    @dheemanthgrao2204 3 місяці тому

    excellent video! so much information provided in such short duration

  • @rmncruz
    @rmncruz 3 місяці тому

    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?

    • @DataMozart
      @DataMozart 3 місяці тому

      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

    • @rmncruz
      @rmncruz 3 місяці тому

      @@DataMozart Thanks

    • @rmncruz
      @rmncruz Місяць тому

      @@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"?

  • @keviny9392
    @keviny9392 3 місяці тому

    Thank you ... very easy to understand.

  • @ovidiuandrei6013
    @ovidiuandrei6013 4 місяці тому

    thanks man 😊

  • @baskis69
    @baskis69 4 місяці тому

    Super clear explanation, for non-technical profiles, which is my case, it is much appreciated... Thanks for sharing ¡¡¡

    • @DataMozart
      @DataMozart 4 місяці тому

      Glad it was helpful!

  • @dbalkin777
    @dbalkin777 4 місяці тому

    Excellent explainer! Plan on sharing with colleagues as well!

    • @DataMozart
      @DataMozart 4 місяці тому

      Awesome, thank you!

  • @williamknox8438
    @williamknox8438 4 місяці тому

    THANK YOU! THIS HAS TO BE THE 12TH VIDEO I'VE WATCHED ON PARQUET AND I FINALLY UNDERSTAND.

    • @DataMozart
      @DataMozart 4 місяці тому

      I'm happy to hear that! Cheers!

    • @f00tballfever
      @f00tballfever 3 місяці тому

      @@DataMozart awesome video. super easy to follow. would be amazing if you could upload more video like these with ELI5 format.

  • @Mega_world02
    @Mega_world02 5 місяців тому

    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

  • @murugesanrajasekaran5032
    @murugesanrajasekaran5032 5 місяців тому

    Wry concise and clear tutorial. Keep up the great work. Subscribed

    • @DataMozart
      @DataMozart 5 місяців тому

      Awesome, thank you!

  • @KannanKalidasan
    @KannanKalidasan 5 місяців тому

    Best and clear explanation of parquet format

    • @DataMozart
      @DataMozart 5 місяців тому

      Glad you think so! Thanks!

  • @Ayman154
    @Ayman154 5 місяців тому

    not shown in power bi

    • @DataMozart
      @DataMozart 5 місяців тому

      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

    • @deepu047
      @deepu047 5 місяців тому

      Is pro license enough if we select auto page refresh?

  • @clnguye
    @clnguye 5 місяців тому

    Love it. Great explanation to contrast between parquet and rdbms; lake house and warehouse. Thanks for making the video. Love the string music intro.

    • @DataMozart
      @DataMozart 5 місяців тому

      Glad you enjoyed it! Thanks for the feedback

  • @felipecujar5688
    @felipecujar5688 5 місяців тому

    Awesome explanation! Thanks for it man !

    • @DataMozart
      @DataMozart 5 місяців тому

      Cheers! Happy you found it useful

  • @rupaghosh6251
    @rupaghosh6251 5 місяців тому

    Just an outstanding explanation

    • @DataMozart
      @DataMozart 5 місяців тому

      Thank you, I'm happy to hear that!

  • @VictorHugo-bd3bf
    @VictorHugo-bd3bf 6 місяців тому

    That is an awesome explanation; thanks, Nikola.

    • @DataMozart
      @DataMozart 6 місяців тому

      Glad you enjoyed it!

  • @clnguye
    @clnguye 6 місяців тому

    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

    • @DataMozart
      @DataMozart 6 місяців тому

      Awesome, thank you! Same here, it was great meeting you in Houston

  • @satyajit015
    @satyajit015 6 місяців тому

    awesome video with a great detailing. Thanks a lot for explaining.

    • @DataMozart
      @DataMozart 6 місяців тому

      You are welcome! Glad you find it useful

  • @gautambhandare8164
    @gautambhandare8164 6 місяців тому

    Trust me even 10 year old won't understand this.

  • @FranciscoGarofalo-mb3ud
    @FranciscoGarofalo-mb3ud 6 місяців тому

    nice video

  • @pratikfutane8131
    @pratikfutane8131 7 місяців тому

    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

    • @rickyschechter
      @rickyschechter 5 місяців тому

      I found here an implementation solution for this problem: ua-cam.com/video/dXxv39X884Q/v-deo.html