Expert Data Modeling with Power BI: Get the best out of Power BI by building optimized data models for reporting and business needs
暫譯: 專業數據建模與 Power BI：透過建立最佳化的數據模型以滿足報告和商業需求，充分發揮 Power BI 的潛力

Bakhshi, Soheil

Expert Data Modeling with Power BI: Get the best out of Power BI by building optimized data models for reporting and business needs
  • 出版商: Packt Publishing
  • 出版日期: 2021-06-11
  • 定價: $2,180
  • 售價: 6.0 折 $1,308
  • 語言: 英文
  • 頁數: 612
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1800205694
  • ISBN-13: 9781800205697
  • 相關分類: Power BI

    • 立即出貨 (庫存=1)

買這商品的人也買了...

相關主題

商品描述

Key Features

  • Understand data modeling techniques to get the best out of data using Power BI
  • Define the relationships between data to extract valuable insights
  • Solve a wide variety of business challenges by building optimal data models

Book Description

Microsoft Power BI is one of the most popular business intelligence tools available on the market for desktop and the cloud. This book will be your guide to understanding the ins and outs of data modeling and how to create data models using Power BI confidently. You'll learn how to connect data from multiple sources, understand data, define and manage relationships between data, and shape data models.

In this book, you'll explore how to use data modeling and navigation techniques to define relationships and create a data model before defining new metrics and performing custom calculations using modeling features. As you advance through the chapters, the book will demonstrate how to create full-fledged data models, enabling you to create efficient data models and simpler DAX code with new data modeling features. With the help of examples, you'll discover how you can solve business challenges by building optimal data models and changing your existing data models to meet evolving business requirements. 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.

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 reporting 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
  • Explore best practices for data preparation and data modeling
  • Discover different hierarchies and their common pitfalls
  • Understand complex data models and how to decrease the level of model complexity with different data modeling approaches

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 knowledge of Power BI and Star Schema will help you to understand the concepts covered in this book.

商品描述(中文翻譯)

#### 主要特點

- 理解數據建模技術，以充分利用 Power BI 中的數據
- 定義數據之間的關係，以提取有價值的見解
- 通過構建最佳數據模型來解決各種商業挑戰

#### 書籍描述

Microsoft Power BI 是市場上最受歡迎的商業智慧工具之一，適用於桌面和雲端。本書將指導您了解數據建模的方方面面，以及如何自信地使用 Power BI 創建數據模型。您將學習如何連接來自多個來源的數據，理解數據，定義和管理數據之間的關係，並塑造數據模型。

在本書中，您將探索如何使用數據建模和導航技術來定義關係並創建數據模型，然後再定義新的指標並使用建模功能執行自定義計算。隨著您逐步深入各章節，本書將展示如何創建完整的數據模型，使您能夠創建高效的數據模型和更簡單的 DAX 代碼，並利用新的數據建模功能。通過示例，您將發現如何通過構建最佳數據模型來解決商業挑戰，並改變現有數據模型以滿足不斷變化的商業需求。最後，您將學習如何使用一些新的和高級的建模功能來增強您的數據模型，以執行各種複雜任務。

到本書結束時，您將掌握從多個來源以不同方式結構數據的技能，以創建支持報告和數據分析的優化數據模型。

#### 您將學到什麼

- 在 DAX 中實現虛擬表和時間智能功能，以構建強大的模型
- 識別維度表和事實表，並在 Power Query 編輯器中實現它們
- 在構建星型架構時處理高級數據準備場景
- 探索數據準備和數據建模的最佳實踐
- 發現不同的層級及其常見陷阱
- 理解複雜的數據模型，以及如何通過不同的數據建模方法降低模型的複雜性

#### 本書適合誰

這本 MS Power BI 書籍適合希望熟練掌握數據建模技術的 BI 使用者、數據分析師和分析開發人員，以充分利用 Power BI。對 Power BI 和星型架構的基本知識將幫助您理解本書所涵蓋的概念。

作者簡介

Soheil Bakhshi is the founder of Data Vizioner and is a sought after BI consultant. Working in data and analytics for more than 20 years, Soheil’s experience lies in Microsoft BI, Data Warehousing, and Power BI platform. He possesses MSCE, MCSA certifications and is a Microsoft MVP (Most Valuable Professional). He has a passion for sharing knowledge via his website and speaking at conferences and Power BI community events locally and globally. In following his desire for simplicity and efficiency, he is behind Power BI community tools and commercial products such as Power BI Exporter and Power BI Documenter.

作者簡介(中文翻譯)

Soheil Bakhshi 是 Data Vizioner 的創辦人，也是備受追捧的商業智慧（BI）顧問。擁有超過 20 年的數據與分析工作經驗，Soheil 的專長包括 Microsoft BI、數據倉儲和 Power BI 平台。他擁有 MSCE 和 MCSA 認證，並且是 Microsoft MVP（最有價值專業人士）。他熱衷於通過自己的網站分享知識，並在當地及全球的會議和 Power BI 社群活動中演講。為了追求簡單與效率，他參與了 Power BI 社群工具和商業產品的開發，如 Power BI Exporter 和 Power BI Documenter。

目錄大綱

Table of Contents

1.Introduction to data modelling 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 Shema and Data Modeling Common Best Practices
10.Advanced Data Modeling Techniques
11.Row Level Security
12.Extra Options and Features Available for Data Modeling

目錄大綱(中文翻譯)

Table of Contents

1.Introduction to data modelling 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 Shema and Data Modeling Common Best Practices

10.Advanced Data Modeling Techniques

11.Row Level Security

12.Extra Options and Features Available for Data Modeling

類似商品