Data Modeling with Microsoft Power BI : Self-Service and Enterprise Data Warehouse with Power BI - Markus Enhrenmueller-Jensen

Data Modeling with Microsoft Power BI

Self-Service and Enterprise Data Warehouse with Power BI

By: Markus Enhrenmueller-Jensen

Paperback | 21 June 2024

At a Glance

Paperback


RRP $133.00

$58.25

56%OFF

or 4 interest-free payments of $14.56 with

 or 
In Stock and Aims to ship in 1-2 business days

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

More in Database Design & Theory

Python All-in-One For Dummies : 3rd Edition - John C. Shovic

RRP $74.95

$50.35

33%
OFF
Information Modeling and Relational Databases : 2nd Edition - Terry Halpin
Scaling Python with Dask : From Data Science to Machine Learning - Holden Karau
Database in Depth : O'Reilly Ser. - Chris J. Date

RRP $66.50

$31.75

52%
OFF
Data Visualisation : 2nd Edition - A Handbook for Data Driven Design - Andy Kirk
Artificial Intelligence in Finance : A Python-Based Guide - Yves Hilpisch