Expert Data Modeling with Power BI - Second Edition: Enrich and optimize your data models to get the best out of Power BI for reporting and business n

Take your Power BI reports to the next level by learning various data modeling techniques and leveraging the latest features of Power BI effectively

Purchase of the print or Kindle book includes a free eBook in PDF format.

Key Features

• Get an understanding of data modeling techniques using Power BI with this up-to-date guide
• Learn how to define the relationships between data sets to extract valuable insights
• Explore best practices for data preparation and modeling and build optimal data models to solve a wide variety of real-world business challenges

Book Description

This book is a comprehensive guide to understanding the ins and outs of data modeling and how to create full-fledged data models using Power BI confidently.

In this new, fully updated edition, you'll learn how to connect data from multiple sources, understand data, define and manage relationships between data, and shape data models to gain deep and detailed insights about your organization. As you advance through the chapters, the book will demonstrate how to prepare efficient data models in the Power Query Editor and use simpler DAX code with new data modeling features. You'll explore how to use the various data modeling and navigation techniques and perform custom calculations using the modeling features with the help of real-world examples. Finally, you'll learn how to use some new and advanced modeling features to enhance your data models to carry out a wide variety of complex tasks. Additionally, you'll learn valuable best practices and explore common data modeling complications and the solutions to supercharge the process of creating a data model in Power BI and build better-performing data models.

By the end of this Power BI book, you'll have gained the skills you need to structure data coming from multiple sources in different ways to create optimized data models that support high-performing reports and data analytics.

What you will learn

• Implement virtual tables and time intelligence functionalities in DAX to build a powerful model
• Identify Dimension and Fact tables and implement them in Power Query Editor
• Deal with advanced data preparation scenarios while building Star Schema
• Discover different hierarchies and their common pitfalls
• Understand complex data models and how to decrease the level of model complexity with different approaches
• Learn advanced data modeling techniques such as calculation groups, aggregations, incremental refresh, RLS/OLS, and more
• Get well-versed with datamarts and dataflows in PowerBI

Who this book is for

This MS Power BI book is for BI users, data analysts, and analysis developers who want to become well-versed with data modeling techniques to make the most of Power BI. Basic working knowledge of Power BI and the Star Schema functionality are required to help you to understand the concepts covered in this book.

將您的 Power BI 報告提升到更高的水平，學習各種數據建模技術，並有效利用 Power BI 的最新功能。

購買印刷版或 Kindle 版本的書籍，將包含一本免費的 PDF 電子書。

主要特點：

- 通過這本最新指南，了解使用 Power BI 的數據建模技術。
- 學習如何定義數據集之間的關係，以提取有價值的洞察。
- 探索數據準備和建模的最佳實踐，並構建最佳數據模型，以解決各種現實世界的業務挑戰。

書籍描述：

這本書是一本全面指南，旨在深入了解數據建模的方方面面，並自信地使用 Power BI 創建完整的數據模型。

在這本全新的、完全更新的版本中，您將學習如何從多個來源連接數據，理解數據，定義和管理數據之間的關係，並塑造數據模型，以深入且詳細地了解您的組織。隨著您進一步閱讀，本書將演示如何在 Power Query Editor 中準備高效的數據模型，並使用新的數據建模功能簡化 DAX 代碼。您將探索各種數據建模和導航技術，並通過真實世界的示例使用建模功能進行自定義計算。最後，您將學習如何使用一些新的高級建模功能來增強數據模型，以執行各種複雜任務。此外，您還將學習寶貴的最佳實踐，並探索常見的數據建模問題及其解決方案，以加速在 Power BI 中創建數據模型的過程，並構建性能更好的數據模型。

通過閱讀本 Power BI 書籍，您將獲得結構化來自多個來源的數據的技能，以不同的方式創建優化的數據模型，支持高性能的報告和數據分析。

您將學到什麼：

- 使用 DAX 實現虛擬表和時間智能功能，構建強大的模型。
- 確定維度和事實表，並在 Power Query Editor 中實現它們。
- 在構建星型模式時處理高級數據準備場景。
- 探索不同的層次結構及其常見問題。
- 了解複雜的數據模型，以及如何通過不同的方法降低模型複雜性。
- 學習高級數據建模技術，如計算組、聚合、增量刷新、RLS/OLS 等。
- 熟悉 PowerBI 中的數據集和數據流。

本書適合對 BI 用戶、數據分析師和分析開發人員，他們希望熟悉數據建模技術，以充分利用 Power BI。您需要具備基本的 Power BI 工作知識和星型模式功能，以幫助您理解本書中涵蓋的概念。

1. Introduction to Data Modeling in Power BI
2. Data Analysis eXpressions and Data Modeling
3. Data Preparation in Power Query Editor
4. Getting Data from Various Sources
5. Common Data Preparation Steps
6. Star Schema Preparation In Power Query Editor
7. Data Preparation Common Best Practices
8. Data Modeling Components
9. Star Schema and Data Modeling Common Best Practices
10. Advanced Data Modeling Techniques
11. Row-Level and Object-Level Security
12. Dealing with More Advanced Data Warehousing Concepts in Power BI
13. Introduction to Dataflows
14. DirectQuery Connections to Power BI Datasets and Analysis Services in Composite Models
15. New Options, Features, and DAX Functions

1. Power BI中的資料建模介紹
2. 資料分析表達式和資料建模
3. 在Power Query Editor中進行資料準備
4. 從不同來源獲取資料
5. 常見的資料準備步驟
6. 在Power Query Editor中準備星型模式
7. 資料準備的常見最佳實踐
8. 資料建模組件
9. 星型模式和資料建模的常見最佳實踐
10. 高級資料建模技巧
11. 行級和物件級安全性
12. 在Power BI中處理更高級的資料倉儲概念
13. 資料流程介紹
14. Power BI資料集和分析服務的DirectQuery連接和複合模型
15. 新選項、功能和DAX函數