GO PREMIUM!

  • PREMIUM Support

    Up to 8 hours of individual work with your team members on DP-500 topics

  • 1 on 1 Sessions

    Exclusive live sessions with your team to help them master Azure Data Analytics platform

  • Up to 5 individual licenses included

    Up to 5 individual licenses for your team members included in price

Why should you take this course?

  • Exclusive 8-hour live support for your team

  • Up to 5 individual licenses for your team members

  • Increase professional value by getting the in-demand certificate

  • Boost your confidence for successfully passing the exam

  • One-stop-shop to master all the skills you need for the certificate

  • The most comprehensive course on the topic

What you'll learn

    1. Welcome and Setting the Right Expectations

      FREE PREVIEW

    2. Who Should Take the DP-500 Exam?

    3. Prerequisites - Software and Subscription

      FREE PREVIEW

    4. Course Slides

    1. How Microsoft Purview Works

    2. Search and Browse Assets in Microsoft Purview

    3. Use Assets with Power BI

    4. Catalog Data Artifacts with Microsoft Purview

    5. Classify and Label the Data in Microsoft Purview

    6. Manage Power BI Assets with Microsoft Purview

    7. Integrate Microsoft Purview with Azure Synapse Analytics

    8. Chapter Quiz - Microsoft Purview

    1. Understanding the Modern Data Platform Concept

    2. Azure Synapse Analytics Core Components

    3. Serverless SQL Pool in Azure Synapse Analytics

    4. Demo: Synapse Studio and Power BI integration

    5. Demo: Query files with Serverless SQL

      FREE PREVIEW

    6. Creating External Tables in Serverless SQL

    7. Demo: Serverless Agg Pivot and External Objects

    8. Dedicated SQL Pool in Azure Synapse Analytics

    1. Indexing and Statistics in Dedicated SQL Pool

    2. Data Distribution Options in Dedicated SQL Pool

    3. Scaling Out Dedicated SQL Pool

    4. Query Performance Tuning in Dedicated SQL Pool

    5. Demo: Query and Visualize Data in Dedicated SQL Pool

    6. Visualize Data with Spark Notebooks

    7. Demo: Query and Visualize Data in Apache Spark Pool

    8. Enhancing Queries with Machine Learning PREDICT Function

    9. Chapter Quiz - Azure Synapse Analytics

    1. Data Modeling and Star Schema Relevance

    2. Demo: Data Modeling and Star Schema Relevance

    3. Understanding Direct Query in Power BI

    4. Demo: Optimizing Direct Query Scenarios in Power BI

    5. Introduction to Calculation Groups

    6. Demo: Calculation Groups

    7. Understanding Aggregations in Power BI

    8. Demo: Improving Performance with Aggregations

      FREE PREVIEW

    9. Designing a Large Format Dataset

    10. Composite Models

    11. Understanding XMLA Endpoints

    12. Implementing Row-Level Security and Object-Level Security

    13. Demo: Implementing Row-Level Security and Object-Level Security

    14. Demo: DAX Variables, Virtual Relationships, BLANKs and Iterators

    1. Understanding Data Shaping Process

    2. Understanding Query Folding Concept

    3. Demo: Improving Performance with Query Folding

    4. Data Refresh Best Practices

    5. Demo: Identifying Bottlenecks in Data Refresh Process

    6. Implementing Scalability with Dataflows

    7. Demo: Creating Dataflows in Power BI

About this course

  • €1.499,00
  • 85 lessons
  • 5.5 hours of video content
  • Exclusive 8-hour live support
  • 5 individual licenses included

Nikola Ilic

Microsoft Data Platform MVP, Microsoft Certified Trainer

Nikola Ilic

is an independent Data Platform consultant and trainer, focusing on Microsoft Data Platform technologies, especially Power BI - but “off the record” he is a data fanatic, interested in everything related to extracting meaningful information from the raw data. Nikola is a self-proclaimed "Data Mozart". As he lives in the wonderful city of Salzburg, Austria, which is well-known as the birthplace of W.A. Mozart, he was brave enough to use the composer's last name as part of his nickname. That's why Nikola's professional motto is: "Make Music from your Data!" Coming from the business environment, Nikola holds a Bachelor’s degree in both Communicology and Computer Science. He is regularly blogging on data-mozart.com, teaches live and online classes, and speaks at global data conferences. Nikola is also a Microsoft Data Platform MVP, Microsoft Certified Trainer, certified Azure Enterprise Data Analyst, Azure Data Engineer, and Power BI Data Analyst.

What my students say?

Love it when an instructor is just as excited about a technology as I am!

Gina Meronek, Data Engineer at Altra Industrial Motion

Don't let the "data analyst" title of this certification fool you. This is definitely applicable and interesting for engineers and architects. The content covers not just what's possible, but why and where you'd apply these solutions, both for modern data processing and content distribution. Nikola has great techniques for reinforcing learning in a friendly way, and the content is organized to anticipate your "but why would I do that / why should that matter" questions too. He's truly a marvelous trainer... I love it when an instructor is just as excited about technology as I am, and Nikola brings his full enthusiasm and empathy to the course.

Look no further to level up your enterprise data analytics skills!

Elena Drakulevska, Data Analyst

I had the privilege to be among the first ones who took this course and it exceeded my expectations! The course was comprehensive, covered all the necessary theory, complemented with real-life examples and case-studies. The way Nikola uses analogies makes it so much easier to remember everything and his wit makes learning fun. If you would like to level up your data analysis skills in the enterprise world, I can honestly say look no further!

Love it, very useful!

Thierno Barry, Azure Data Engineer, certified Power BI Data Analyst

Great course. I love it and find it very useful.

One step closer to passing DP-500 exam!

Alexandru Badiu, Business Intelligence Manager, Power BI Specialist, Course creator

I highly recommend Nikola's course and following his blog articles for all mid/advanced Bi professionals out there working day in and day out with Microsoft Power BI! The course covers many advanced topics, it is full of tips & tricks, advices and demos that will certainly help you gain knowledge and have a higher impact in your daily work. By following his course you will be one step closer and more prepared for passing the new DP 500 Microsoft exam. If you already have PL-300 Microsoft Power BI Data Analyst and you really want to step it up a notch, consider DP 500 exam!

Mastering DP-500 course proved an excellent preparation strategy for me

Tom Huguelet, Solutions Architect at P3 Adaptive, BI Expert

Nikola’s videos strike a good balance of enthusiasm, humor, and knowledge. For me, I needed to assess gaps in my knowledge – in some areas I had robust experience while in the newer topics I was very much a beginner. The quiz questions showed me what I knew and what I didn’t and the links to relevant topics associated with each question were invaluable. Data Mozart’s Mastering DP-500 course proved an excellent preparation strategy for me.

Excellent resource for anyone looking to master DP-500 exam!

Milos Ilic, Data Platform Department Manager at Valcon

I recently took the Mastering DP-500 Exam course by Nikola Ilic, and I found it to be an excellent resource for anyone looking to master the DP-500 exam or improve their data analysis skills. The course covers a wide range of topics, from understanding Microsoft Purview and Azure Synapse Analytics to designing and building tabular models with Power BI. The material presented was both relevant and well-presented, and I found the instruction provided by Nikola Ilic to be clear and effective. The course was also well-structured and organized, which made for a cohesive and structured learning experience. Overall, I would highly recommend the Mastering DP-500 Exam course to anyone looking to improve their data analysis skills or prepare for the DP-500 exam.

Wait! There is more...

Bonus material

  • 100 Mock Exam Questions

    Get ready for the real exam by practicing with questions that are close to real exam questions!

  • Demo Files for Practice

    All files used in the course are available for download!

  • Learning Resources

    You'll get a comprehensive list of go-to resources for deepening your knowledge and sharpening your enterprise data analyst skills

Course Reviews

5 star rating

Excellent

FEDELIX ACKA-CHIE

Excellent Material for DP 500 so far in the market

Excellent Material for DP 500 so far in the market

Read Less
5 star rating

Fantastic course

Miloš Ilić

I recently took the Mastering DP-500 Exam course by Nikola Ilić, and I found it to be an excellent resource for anyone looking to master the DP-500 exam or i...

Read More

I recently took the Mastering DP-500 Exam course by Nikola Ilić, and I found it to be an excellent resource for anyone looking to master the DP-500 exam or improve their data analysis skills. The course covers a wide range of topics, from understanding Microsoft Purview and Azure Synapse Analytics to designing and building tabular models with Power BI. The material presented was both relevant and well-presented, and I found the instruction provided by Nikola Ilić to be clear and effective. The course was also well-structured and organized, which made for a cohesive and structured learning experience. Overall, I would highly recommend the Mastering DP-500 Exam course to anyone looking to improve their data analysis skills or prepare for the DP-500 exam.

Read Less

FAQ

  • Why should I buy PREMIUM version of the course?

    First of all, you'll get up to 5 individual licenses for your team members. Next, you will also get exclusive, 8-hour live support for your team (valid for 90 days after the purchase), where I work together with them on topics related to the DP-500 exam. In case you need any additional information, feel free to get in touch directly at: [email protected]

  • How much time should I spend on this course?

    It's up to you! You can watch all the content in one day, although I suggest you better split it across at least one week to better digest various concepts and solutions

  • Will I have lifetime access to the course?

    Yes! Absolutely! It's yours, so feel free to revisit the content if and when necessary

  • What if Microsoft releases the update to the course curriculum?

    I plan to keep the course up to date. Once you bought the course, you'll automatically get FREE access to all the future updates

  • Will I get the certificate to showcase it to my peers?

    Yes! Once you finish the course, a nice-looking certificate is waiting for you and you can add it to your LinkedIn profile or share it through other social media

  • I'm new to Power BI. Is this course for me?

    Well, honestly, I don't want to trick you into this course then. This course covers advanced Power BI topics, so you should be better off starting with PL-300 (Power BI Data Analyst) certification, before taking this course

  • I'm new to Azure Synapse Analytics. Is this course for me?

    Yes! We are starting from the basics and gradually leveling up our Synapse skills. Of course, I assume you're familiar with cloud computing concepts and fundamental data concepts. It's even better if you had some exposure to other Microsoft data products in the past, such as SQL Server, for example

  • Why should I learn from YOU?

    Fair question! I've been working with Microsoft Data Platform for many (really many) years and have a lot of real-life experience in this area. I've been also recognized as a Microsoft Data Platform MVP and Microsoft Certified Trainer. Finally, I myself obtained the DP-500 certificate while it was still in beta, and recently renewed it. I'm also a certified Azure Data Engineer (DP-203) and Power BI Data Analyst (PL-300). If you're still not sure, feel free to check my blog data-mozart.com, where I already shared a lot of DP-500 content.

  • What if I'm not satisfied with the course?

    Fair point! If you feel that course is not meeting your expectations, you have up to 7 (seven) days to ask for a refund. You'll get a 100% refund without asking any questions