Loading

author: Markus Enhrenmueller-Jensen

2024-06-21

O'Reilly Media

Data Modeling With Microsoft Power Bi: Self-Service And Enterprise Data Warehouse With Power Bi

AED 510
Easy Payment Plan
Easy Payment Plans
EPP available for order over AED 1,000
i
Same-day to 2-day delivery
Check availability in store
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
View full description
Loyalty dots logo
Earn 510 loyalty dots equivalent to AED 5.09 when you sign-in and order
AED 510
Easy Payment Plan
Easy Payment Plans
EPP available for order over AED 1,000
i
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
View full description
View less description

publisher

O'Reilly Media

Specifications

Books

Number of Pages
750
Publication Date
2024-06-21
View more specifications
View less specifications
Customers