Wow! eBook
Data Modeling with Microsoft Power BI: Self-Service and Enterprise Data Warehouse with Power BI
Author(s): Markus Ehrenmueller-Jensen (Author)
- Publisher: O'Reilly Media
- Publication Date: July 16, 2024
- Edition: 1st
- Language: English
- Print length: 482 pages
- ISBN-10: 109814855X
- ISBN-13: 9781098148553
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
Editorial Reviews
Review
—Paul Turley | Microsoft Data Platform MVP
This excellent book will tell you why to “star schema all the things.” It explains in great
depth why data modeling is important and provides ample examples. Reading this book
will make your life as a Power BI developer easier.
Markus’s book Data Modeling with Microsoft Power BI provides a very good introduction
to data modeling principles for an effective data model in Power BI as well as in Excel’s
data model, Power Pivot.
The book is written in an explanatory way, using clear language that can be read by both
novices and experts alike. It is very accessible and a must-have for those who want to
learn more about data modeling.
I especially like Markus’s division of the book into a kind of matrix, where each of the five
main sections is divided into four chapters dealing with the same four subtopics—
understanding the data model, building a data model, examples from the real world, and
performance optimization—which become more and more complex throughout the book
so you gradually get more and more insight into the many facets of data modeling.
Creating a fancy report and tinkering with DAX or M-Code in the times of AI is not
hard—creating a high-performing model that will work is. Markus is a “Model Wizard”
and has fixed more of my work than I would like to admit. This hands-on guide will give
you a shot at mastering the model-building challenges ahead of you.
Although Power BI has evolved in leaps and bounds, the challenge of building a solid and
performing model has not. Markus has seen endless environments and setups. I am a
witness to his magic; he helped me fix broken models just by taking a quick look. With his
new book he shares his knowledge with all of us and with his hands-on approach, he will
guide you to becoming a model Wizard of your own.
Data Modeling with Microsoft Power BI is a must-read for anyone looking to master this
powerful tool. Markus Ehrenmueller-Jensen has created an easy-to-read and fun guide
that will help you unlock the full potential of Power BI.
