Power BI Optimization

17900 kr

Performance optimization, also known as performance tuning, involves making changes to the current state of the data model so that it runs more efficiently. Essentially, when your data model is optimized, it performs better. You may think creating a Power BI report is an easy task, but there is a huge difference between the report that works and the report that works efficiently!

Any Power BI user knows that the quality of the reports you make depends on what’s going on behind the scenes. DAX functions are among the pillars of a great Power BI report. This means that when your DAX functions are not optimized, your reports (and your entire experience as a Power BI user) are sacrificed. This course will teach you how to optimize model performance and build efficient solutions.

Beskrivning

Background

  • This course will teach you how to optimize model performance and build efficient solutions.
  • You’ll gain the ability to improve the efficiency of your Power BI reporting solution.
  • You’ll explore how to reduce the data model size by removing unnecessary columns and rows.
  • Next, you’ll discover the importance of the column cardinality and how it can affect data model performance. You’ll also understand the benefits of using aggregation features to make things running faster.
  • Finally, you’ll learn how to identify and resolve poorly performing report elements, such as measures and visuals.
  • When you’re finished with this course, you’ll have the foundational understanding of data model optimization techniques that will enable you to build more efficient Power BI solutions, and get you ready for the new PL-300 exam.

Audience

This training is for professional data analysts and BI specialists who want to improve their knowledge of tuning, optimizing and design Power BI data models that delivers excellent

Prerequisites

Experience with Power BI.

Course Topics

  • Understand Core Concepts of Performance Optimization
  • Optimize Data Model Performance by Improving Cardinality Levels
  • Optimize DAX Functions
  • Understanding, Creating and managing Aggregations
  • Identify Poorly Performing Report Elements
  • Review the performance of measures, relationships, and visuals.
  • Use variables to improve performance and troubleshooting.
  • Improve performance by reducing cardinality levels.
  • Optimize DirectQuery models with table level storage.

 

 

Kursen levereras i samarbete med

Kontakta oss om denna kurs

Ytterligare information

Kurslängd

2 dagar

Lärarledd

Ja

Språk

Svenskt el Engelskt tal, material på engelska

Recensioner

Det finns inga recensioner än.

Endast inloggade kunder som har köpt denna produkt får lämna en recension.