Cloud Academy – Optimizing a Power BI Data Model

在优化 Power BI 数据模型中，我们首先研究 Power BI 的 VertiPaq 数据库引擎的底层结构和操作。有了这些知识，我们研究了各种优化性能的策略。为了不放弃游戏，大多数策略都涉及减小数据模型的大小和加载预先汇总的数据。我们还研究了 Power BI 和 Power Query 编辑器中用于分析报告和查询性能以及内部错误跟踪和诊断的工具。

学习目标
删除不必要的行并为报告受众定制数据集
更改数据类型以改进存储并将列拆分为多列以减少唯一值的总数
删除冗余或重复数据并在可能的情况下用度量替换列
使用性能分析器突出显示报告瓶颈
为导入和直接查询数据模型创建聚合
配置和使用 Power BI 和 Power Query 的诊断工具

目标受众
本课程面向希望通过改进基础数据模型来提高报告速度和响应能力的任何人。

先决条件
我们强烈建议您首先参加 Power BI 课程中的开发 Power BI 数据模型和使用 DAX 构建度量，因为它们深入探讨了如何实施本课程中讨论的几个主题。

MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz, 2 Ch
Difficulty: Intermediate | Genre: eLearning | Language: English + srt | Duration: 9 Lectures (47m) | Size: 690.5 MB

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 course 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 courses first, as they go into depth about how to implement several of the topics discussed in this course.