Why should you take this course?

  • Design efficient and scalable Power BI solutions

  • Identify performance bottlenecks in the existing Power BI reports

  • Learn tools of trade for troubleshooting slow Power BI reports

  • Increase your professional value by mastering in-demand skills

What's in for you?

    1. Welcome to Mastering Power BI Performance Tuning Course!

      FREE PREVIEW

    2. What's in for you?

    3. Setting the Right Expectations - When To Start Tuning Your Power BI Reports?

      FREE PREVIEW

    4. Resources

    5. Mastering Power BI Performance Tuning - Slide Deck

    6. Free E-Book "End-to-end analytics with Power BI"

    1. The Importance of Data Modeling and Star Schema

    2. Demo: The Importance of Star Schema

    3. Understanding Bi-Directional Relationships

    4. Demo: Avoiding Bi-Directional Relationships

    1. Understanding VertiPaq Engine

    2. Demo: Reduce the Data Model Size by 90%

    3. How to Destroy Data Model with Auto Date/Time

    4. Demo: How to Destroy Power BI Data Model with Auto Date/Time

    5. 3 Solutions to Avoid Auto Date/Time

    6. Best Practices for Data Model Size Optimization

      FREE PREVIEW

    1. Understanding Data Shaping Process

    2. Understanding Query Folding

    3. Demo: Changing Data Type and Query Folding

    4. Demo: Native SQL Query and Query Folding

    5. Demo: Query folding - When View Native Query Lies

    6. Demo: Query Folding - Why Should You Care?

      FREE PREVIEW

    7. Demo: Identifying Bottlenecks in the Data Refresh Process

    8. Best Practices for Optimizing the Data Refresh Process

    1. Identifying Performance Improvements in Report Visuals

    2. Demo: Improving Performance by Designing the Report Page Background

    3. Best Practices for Improving the Visuals Rendering Time

    1. Understanding Aggregations in Power BI

    2. Demo: Implementing Aggregations

Facts at a glance

  • €199,00
  • 54 lessons
  • 4 hours of video content

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.

Bonus material

Include additional content to your course curriculum to provide further value to your students.

  • Free Power BI E-Book

    Get the free e-book "End-to-end analytics with Power BI"

  • Real-life Stories

    Some things can't be found in books or videos. You'll get an access to exclusive set of real-life use cases

  • Learning Resources

    You'll get a comprehensive list of go-to resources for deepening your knowledge and sharpening your Power BI performance tuning skills

What my students say?

Complex concepts explained in a clear and engaging manner!

Federico Pastor, fp20 analytics | Power BI Instructor & Consultant

In just a few sessions, the course covered all the essential aspects of optimizing Power BI reports for maximum efficiency. Nikola Ilic did a fantastic job of explaining complex concepts in a clear and engaging manner, making it easy to grasp the material. The course provided valuable insights into the Power BI Performance Tuning and how different components interact with each other. This understanding enables me to identify potential performance issues and proactively address them. Nikola's passion for his job and teaching is contagious 😀 Overall, I highly recommend this Power BI Performance Tuning course to anyone looking to optimize their Power BI reports.

Lovely & lean course!

David Johnston, Lead Power BI Consultant, PL-300 Certified

For a course that is based on maximising Power BI Performance and reducing unnecessary fat, this course is lovely & lean. This course isn't bloated with overly long videos or videos that don't need to be there. ✅ Nikola is very concise with what he says so you never feel you're getting lost in what he is explaining. ✅ Longest video is about 13 minutes, I like short sharp videos. Very logically planned out in terms of sections and how they follow on from the previous topics. ✅ Links to relevant articles/further reading/example files on video topics are placed at the bottom of each page, easy to find and accessible. ✅ Nikola links to some of his own content but also includes content, and regularly namechecks, other experts for further reading. ✅ Great sections on how to use exernal tools such as DAX Studio, Tabular Editor, Bravo etc. ✅ Lifetime access ❌ Nikola uses an analogy where he talks about potentially putting Pineapple on a pizza....this made me shudder....Pineapple should be nowhere near a pizza......That is the only thing in course I can fault 🤣 Seriously great job Nikola Ilic

Provides a clear picture of the reasoning behind best practices!

Tarun Gupta, Business Intelligence Analyst, Content Writer

I have been on a journey to improve the performance of Power BI reports and stumbled upon different blogs and videos but never got a clear idea of the best practices and why we follow them. Thanks to Nikola Ilic for this course. It provided me with a clear picture of the reasoning behind certain best practices that we need to follow.

FAQ

  • 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

  • How long do I have access for this course?

    You'll get an unlimited access for 3 years, with an option to extend it for the 25% of the price at the moment of extension

  • I work for a company and we would like to buy licenses for a group of people. What should I do?

    Feel free to get in touch directly at: [email protected]. I'm happy to support you with some nice discounts

  • Will I get the certificate to showcase my skills to the world?

    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 beginner level course before joining this one

  • I want to become a Power BI data visualization master. Is this course for me?

    Honestly, not! Although we cover some of the data visualization best practices, this course focuses more on performance optimization topics, Power BI internals, architectural decisions, etc.

  • 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've been working with some of the largest companies in the world on performance tuning their Power BI solutions. If you're still not sure, feel free to check my blog data-mozart.com, where I already shared a lot of Power BI 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

Start optimizing your Power BI solutions today

Enroll now

You may also find these courses helpful