Microsoft Power BI Performance Best Practices: A comprehensive guide to building consistently fast Power BI solutions

Merchant, Bhavik

  • 出版商: Packt Publishing
  • 出版日期: 2022-04-22
  • 定價: $1,760
  • 售價: 9.0$1,584
  • 語言: 英文
  • 頁數: 312
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1801076448
  • ISBN-13: 9781801076449
  • 相關分類: Power BI
  • 立即出貨 (庫存=1)

商品描述

Supercharge performance analytics and create repeatable patterns to ensure you get the best performance and scalability from your analytics solutions with Power BI


Key Features:

  • Learn how to build performant data models and apply Row-Level Security
  • Identify and fix performance issues in reports, DAX, and datasets using DAX Studio/VertiPaq Analyzer
  • Use a formal process to manage performance, from setting targets to monitoring and remediating issues


Book Description:

This book comprehensively covers every layer of Power BI, from the report canvas to data modeling, transformations, storage, and architecture.

Developers and architects working with any area of Power BI will be able to put their knowledge to work with this practical guide to design and implement at every stage of the analytics solution development process. This book is not only a unique collection of best practices and tips, but also provides you with a hands-on approach to identifying and fixing common performance issues.

Complete with explanations of essential concepts and practical examples, you'll learn about common design choices that affect performance and consume more resources and how to avoid these problems. You'll grasp the general architectural issues and settings that broadly affect most solutions. As you progress, you'll walk through each layer of a typical Power BI solution, learning how to ensure your designs can handle scale while not sacrificing usability. You'll focus on the data layer and then work your way up to report design. We will also cover Power BI Premium and load testing.

By the end of this Power BI book, you'll be able to confidently maintain well-performing Power BI solutions with reduced effort and know how to use freely available tools and a systematic process to monitor and diagnose performance problems.


What You Will Learn:

  • Understand how to set realistic performance targets and address performance proactively
  • Understand how architectural options and configuration affect performance
  • Build efficient Power BI reports and data transformations
  • Explore best practices for data modeling, DAX, and large datasets
  • Understand the inner workings of Power BI Premium
  • Explore options for extreme scale with Azure services
  • Understand how to use tools that help identify and fix performance issues


Who this book is for:

Data analysts, BI developers, and data professionals who have learnt the basics of Power BI and now want to understand how to build advanced analytics solutions will find this business intelligence book useful. Familiarity with the major components of Power BI and a beginner-level understanding of their purpose and use cases are required.

商品描述(中文翻譯)

加速性能分析並創建可重複的模式,以確保您從Power BI的分析解決方案中獲得最佳性能和可擴展性。

主要特點:
- 學習如何構建高效的數據模型並應用行級安全性
- 使用DAX Studio/VertiPaq Analyzer識別和修復報表、DAX和數據集中的性能問題
- 使用正式流程管理性能,從設定目標到監控和修復問題

書籍描述:
本書全面涵蓋Power BI的每一個層面,從報表畫布到數據建模、轉換、存儲和架構。

任何與Power BI的任何領域合作的開發人員和架構師都能夠通過這本實用指南在分析解決方案開發過程的每個階段設計和實施。本書不僅是一個獨特的最佳實踐和技巧集合,還提供了一種實踐方法來識別和修復常見的性能問題。

通過對基本概念的解釋和實際示例,您將了解影響性能並消耗更多資源的常見設計選擇以及如何避免這些問題。您將掌握廣泛影響大多數解決方案的一般架構問題和設置。隨著進展,您將遍歷典型Power BI解決方案的每一層,學習如何確保設計能夠處理規模而不損失可用性。您將專注於數據層,然後逐步進行報表設計。我們還將涵蓋Power BI Premium和負載測試。

通過閱讀本Power BI書籍,您將能夠自信地維護性能良好的Power BI解決方案,並知道如何使用免費工具和系統化流程來監控和診斷性能問題。

您將學到什麼:
- 了解如何設定實際的性能目標並主動解決性能問題
- 了解架構選項和配置如何影響性能
- 構建高效的Power BI報表和數據轉換
- 探索數據建模、DAX和大型數據集的最佳實踐
- 了解Power BI Premium的內部運作
- 探索使用Azure服務進行極端規模的選項
- 了解如何使用幫助識別和修復性能問題的工具

本書適合對Power BI基礎知識有所了解並希望了解如何構建高級分析解決方案的數據分析師、BI開發人員和數據專業人士。需要熟悉Power BI的主要組件並具有初級水平的理解其目的和用例。