Optimizing a Power BI Data Model

Focused View

Hallam Webber

46:51

22 View

1. Introduction.mp4

01:45

2. Overview.mp4

02:18

3. Removing Rows DEMO.mp4

05:23

4. Dates and Data Types DEMO.mp4

08:49

5. Removing Columns DEMO.mp4

05:04

6. Performance Analyzer DEMO.mp4

05:51

7. Aggregations DEMO.mp4

10:34

8. Diagnostics DEMO.mp4

04:07

9. Summary.mp4

03:00

Description

In Optimizing a Power BI Data Model we start by investigating the underlying structure and operation of Power BI's VertiPaq database engine. Armed with this knowledge, we investigate various strategies for optimizing performance. Not to give the game away, most of the strategies involve reducing the size of the data model and loading pre-summarized data. We also look at tools within Power BI and Power Query Editor for analyzing report and query performance as well as internal error tracking and diagnosis.

Learning Objectives

Remove unnecessary rows and tailor data sets for report audiences
Change data types to improve storage and split columns into multiple columns to reduce the overall number of unique values
Remove redundant or duplicate data and replace columns with measures where possible
Use Performance Analyzer to highlight report bottlenecks
Create aggregations for imported and direct query data models
Configure and use Power BI's and Power Query's diagnostic tools

Intended Audience

This lesson is intended for anyone who wants to improve the speed and responsiveness of their reports by improving the underlying data model.

Prerequisites

We would highly recommend taking the Developing a Power BI Data Model and Using DAX to Build Measures in Power BI lessons first, as they go into depth about how to implement several of the topics discussed in this lesson.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

Data Modeling

Hallam Webber

Instructor's Courses

Hallam is a software architect with over 20 years experience across a wide range of industries. He began his software career as a Delphi/Interbase disciple but changed his allegiance to Microsoft with its deep and broad ecosystem. While Hallam has designed and crafted custom software utilizing web, mobile and desktop technologies, good quality reliable data is the key to a successful solution. The challenge of quickly turning data into useful information for digestion by humans and machines has led Hallam to specialize in database design and process automation. Showing customers how leverage new technology to change and improve their business processes is one of the key drivers keeping Hallam coming back to the keyboard.

Cloud Academy

View courses Cloud Academy

Join thousands of users in achieving your personal goals through Cloud Academy. Score job-ready tech skills that you can practice in a real environment, without the risk of extra costs or making mistakes. It’s simply the smartest way to gain certifications and get career-ready.