Optimize Model Performance with Power BI

Focused View

Nikola Ilic

1:06:11

71 View

1. Course Overview

1. Course Overview.mp4

01:55

2. Understanding Core Concepts of Performance Optimization

1. Understanding Core Components of Performance Optimization.mp4

03:04

2. Removing Unnecessary Data.mp4

02:54

3. Demo - Remove Unnecessary Data.mp4

02:34

4. Troubleshooting with Query Diagnostics Tool.mp4

01:16

5. Demo - Using Query Diagnostics Tool.mp4

02:15

6. Understanding Query Folding.mp4

04:49

7. Demo - Performance Comparison with Query Folding.mp4

04:53

3. Optimizing Data Model Performance by Improving Cardinality Levels

1. Understanding Cardinality.mp4

04:23

2. Demo - Identifying Column Cardinality with DAX Studio.mp4

03:02

3. Improving Cardinality Levels by Changing Data Types.mp4

02:36

4. Demo - Improving Cardinality Levels by Changing Data Types.mp4

01:47

5. Improving Cardinality Levels Through Summarization.mp4

01:58

6. Demo - Improving Cardinality Levels Through Summarization.mp4

04:15

4. Optimizing Data Model Performance with Aggregations

1. Understanding Aggregations.mp4

06:39

2. Demo - Managing Aggregations.mp4

06:08

5. Identifying Poorly Performing Report Elements

1. Identifying Poorly Performing Report Elements.mp4

02:26

2. Demo - Understanding Performance Analyzer.mp4

03:13

3. Demo - Performance Optimization Techniques.mp4

06:04

Description

Creating a Power BI report may look like an easy task, but there is a huge difference between the report that works and the report that works efficiently! This course will teach you how to optimize model performance and build efficient solutions.

What You'll Learn?

Congratulations! You've built your beautiful Power BI report and your charts look terrific. But, your data refresh takes forever. Or, your report renders slow when interacting with visuals.

In this course, Optimize Model Performance with Power BI, you’ll gain the ability to improve the efficiency of your Power BI reporting solution. First, 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 DA-100 exam.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

Nikola Ilic

Instructor's Courses

Nikola Ilic is an officially Business Intelligence Developer, 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 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 and speaking at global data conferences. Nikola is also a Microsoft Data Platform MVP, Microsoft Certified Trainer, and a certified Data Analyst.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.