Book description
Data modeling is the single most overlooked feature in 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 semantic 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, role-playing dimensions and slowly changing dimensions
- 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
Publisher resources
Table of contents
- Foreword
-
Preface
- Who Is This Book For?
- What Is Data Modeling?
- What Is Power BI?
- What Is So Special About a Power BI Data Model?
- What Is DAX?
- What Is Power Query?
- What Is SQL?
- A New Release Every Few Weeks
- How to Read This Book
- Installing Necessary Software
- Additional Tools
- Demo Files
- Conventions Used in This Book
- Using Code Examples
- O’Reilly Online Learning
- How to Contact Us
- Acknowledgments
- I. Data Modeling 101
- 1. What Is a Data Model?
- 2. Building a Data Model
- 3. Real-World Examples
- 4. Performance Tuning
- II. Data Modeling in Power BI
- 5. Understanding a Power BI Data Model
- 6. Building a Data Model in Power BI
- 7. Real-World Examples Using Power BI
- 8. Performance Tuning in the Power BI Data Model
- III. Data Modeling for Power BI with the Help of DAX
- 9. Understanding a Data Model from the DAX Point of View
- 10. Building a Data Model with DAX
- 11. Real-World Examples Using DAX
- 12. Performance Tuning with DAX
- IV. Data Modeling for Power BI with the Help of Power Query
- 13. Understanding a Data Model from the Power Query Point of View
- 14. Building a Data Model with Power Query and M
- 15. Real-World Examples Using Power Query and M
- 16. Performance Tuning the Data Model with Power Query
- V. Data Modeling for Power BI with the Help of SQL
- 17. Understanding a Relational Data Model
- 18. Building a Data Model with SQL
- 19. Real-World Examples Using SQL
- 20. Performance Tuning the Data Model with SQL
- Epilogue
- Index
- About the Author
Product information
- Title: Data Modeling with Microsoft Power BI
- Author(s):
- Release date: June 2024
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781098148553
You might also like
book
Expert Data Modeling with Power BI - Second Edition
Take your Power BI reports to the next level by learning various data modeling techniques and …
book
Data Analysis with Microsoft Power BI
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, …
book
Definitive Guide to DAX, The: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel, 2nd Edition
Now expanded and updated with modern best practices, this is the most complete guide to Microsoft's …
book
Learning Microsoft Power BI
Microsoft Power BI is a data analytics and visualization tool powerful enough for the most demanding …