Table of contents

Prelude to data modeling

The following article provides a gentle introduction to data modeling with Power BI

Prelude to data modeling with Power BI

the power bi data model

This article provides a short introduction into the world of the Power BI data model.

Tables, columns, and some things related

This article provides an introduction to the world of tables and columns. As tables are at the very foundation of the data model it's necessary to have a solid understanding on how to model tables.

The article

Calculated columns and measures

Here the difference between a calculated column and a measure is explained, guidance is provided when to use what. Be prepared for - it depends.

The article

The danger of the one-table solution

Granularity - Your majesty!

Consider the columns of your data model being a club, that the engine has to wield, make it compact by using the least necessary granularity.

Here you will find the article about granularity



This article is the beginning of a mini-series related to the sword of the data model - relationships.

The article

Extended tables

Extended tables are at the very heart of the performance of the Power BI / SSAS Tabular data model,

The article

Circular dependencies

One of the “details” that can easily draw you in the “whirlpool”, is called – circular dependency! I’m quite sure that all of us were at least once (hopefully it was only once) annoyed with the message: “A circular dependency was detected…”

Here you will find the article that explains why this happens and how you can avoid circular dependencies.

Role-playing dimensions

Two "actors" for two "roles" vs one "actor" for two "roles"? Learn which approach is better when it comes to #datamodeling in #PowerBI.

Here you will find the article

Bi-directional relationships

If you carefully follow our “Data Modeling” series, you may recall that I’ve used a theatre to illustrate the concept of role-playing dimensions. In this article, however, there will be no actors and no theatre…But, models with bi-directional relationships, or bi-directional filters if you prefer, can quickly turn into a tragedy!
Here you will find the article

Parent-child hierarchies


out-of-the-box thinking

Disconnected tables

A different approach to the event-in-progress problem