Data Modeling with Microsoft Power BI: Self-Service and Enterprise Data Warehouse with Power BI (Paperback)
Ehrenmueller-Jensen, Markus
買這商品的人也買了...
商品描述
Data modeling is the single most overlooked feature in the Power BI Desktop, yet it's what sets Power BI apart from other tools on the market. This practical book serves as your fast-forward button for data modeling with Power BI, Analysis Services tabular, and SQL databases. It serves as a starting point for data modeling, as well as a handy refresher.
Author Markus Ehrenmueller-Jensen, founder of Savory Data, shows you the basic concepts of Power BI's data model with hands-on examples in DAX, Power Query, and T-SQL. If you're looking to build a data warehouse layer, chapters with T-SQL examples will get you started. You'll begin with simple steps and gradually solve more complex problems.
This book shows you how to:
- Normalize and denormalize with DAX, Power Query, and T-SQL
- Apply best practices for calculations, flags and indicators, time and date, and role-playing dimensions with DAX, Power Query, and T-SQL
- Solve challenges such as binning, budget, localized models, composite models, and key value with DAX, Power Query, and T-SQL
- Discover and tackle performance issues by applying solutions in DAX, Power Query, and T-SQL
- Work with tables, relations, set operations, normal forms, dimensional modeling, and ETL
商品描述(中文翻譯)
資料建模是 Power BI Desktop 中最常被忽視的功能，然而這正是讓 Power BI 與市場上其他工具有所不同的地方。這本實用書籍將作為您在 Power BI、Analysis Services tabular 和 SQL 資料庫中進行資料建模的快速入門指南，同時也是一本方便的複習資料。
作者 Markus Ehrenmueller-Jensen 是 Savory Data 的創辦人，他通過 DAX、Power Query 和 T-SQL 的實際範例向您展示了 Power BI 資料模型的基本概念。如果您想要建立資料倉儲層，書中的 T-SQL 範例將幫助您入門。您將從簡單的步驟開始，逐漸解決更複雜的問題。
本書將向您展示如何：
- 使用 DAX、Power Query 和 T-SQL 進行規範化和反規範化
- 在 DAX、Power Query 和 T-SQL 中應用最佳實踐，包括計算、標誌和指標、時間和日期以及角色扮演維度
- 通過 DAX、Power Query 和 T-SQL 解決二進制分組、預算、本地化模型、複合模型和鍵值等挑戰
- 通過在 DAX、Power Query 和 T-SQL 中應用解決方案來發現和解決性能問題
- 處理表格、關聯、集合操作、正規化形式、維度建模和 ETL 相關問題
