Pro DAX with Power BI: Business Intelligence with PowerPivot and SQL Server Analysis Services Tabular

© Philip Seamark, Thomas Martens 2019

P. Seamark, T. MartensPro DAX with Power BIhttps://doi.org/10.1007/978-1-4842-4897-3_2

2. Data Modeling

Philip Seamark¹  and Thomas Martens²

(1)

UPPER HUTT, New Zealand

(2)

Hamburg, Hamburg, Germany

 

Introduction

Even if Power BI is around for quite some time, it seems that data modeling is often neglected, meaning often reports unfold their magic just upon a single table. Sometimes tremendous effort is spent to gather data from various sources to create a single table, and then this single table is used to create appealing visuals.

But then, out of a sudden, it seems to become overly complex to create a measure, or even worse, the measure composed returns an unexpected result.

To fully utilize the analytical potential ...