As I'm moving to a new site, my articles from this series have been moved.
You will find the articles here:
The article has been moved to its new home. You will find the article here:
The article has been moved to its new home. You will find the article here:
The article has been moved to its new home. You will find the article here:
The article has been moved to its new home. You will find the article here:
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
The article has been moved to its new home. You will find the article here:
The article has been moved to its new home. You will find the article here:
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