What do you think?
Rate this book
Data Modeling with Microsoft Power BI: Self-Service and Enterprise Data Warehouse with Power BI
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
Normalize and denormalize with DAX, Power Query, and T-SQLApply best practices for calculations, flags and indicators, time and date, role-playing dimensions and slowly changing dimensionsSolve challenges such as binning, budget, localized models, composite models, and key value with DAX, Power Query, and T-SQLDiscover and tackle performance issues by applying solutions in DAX, Power Query, and T-SQLWork with tables, relations, set operations, normal forms, dimensional modeling, and ETL
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
Normalize and denormalize with DAX, Power Query, and T-SQLApply best practices for calculations, flags and indicators, time and date, role-playing dimensions and slowly changing dimensionsSolve challenges such as binning, budget, localized models, composite models, and key value with DAX, Power Query, and T-SQLDiscover and tackle performance issues by applying solutions in DAX, Power Query, and T-SQLWork with tables, relations, set operations, normal forms, dimensional modeling, and ETL
786 pages, Kindle Edition
Published June 10, 2024
8 people are currently reading
10 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 of 1 review
February 24, 2025
Excellent coverage of powerbi from fundamental data modelling practises to power query and dax and how to efficiently design future proof dashboards.
Displaying 1 of 1 review