The following article provides a gentle introduction to data modeling with Power BI
This article provides a short introduction into the world of the Power BI data model.
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
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
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 are at the very heart of the performance of the Power BI / SSAS Tabular data model,
The article
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.
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
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