Data Modeling · 27. Dezember 2021
Tables and their columns are the very foundation of Power BI data models.
Data Modeling · 27. Dezember 2021
Data modeling and understanding the physical layer are comparable with being a good driver and a good car mechanic. It's unnecessary to excel in both areas. Still, it helps tremendously when driving an F1 car through uncharted terrain if there is some understanding of how an F1 car works if repair becomes necessary.,
DAX · 26. Dezember 2021
This article is about durations.
When we are looking at something like this: 2:00
We think, at least most of the people I know, an event that takes 2 hours.
But when we change the notation just a little to 2:00 AM, we think: Whoa, that’s early (or late, depending on the perspective, of course).
Data Modeling · 07. Dezember 2021
Before we delve into the realm of Power BI data modeling (or Analysis Services Tabular), it's necessary to understand what this data modeling is all about. A thorough understanding of data modeling is vital because the Power BI data model determines the insights that can be derived and visualized from our data, leading us to better and more actionable decisions. Because we are striving for the ideal data model all the time, others call us obsessed with data modeling 😊 To get this...
Power Query · 02. Juni 2021
The other day I was facing an interesting question "How can I randomly draw ten records from the top 50 for each group using Power Query?" As you may guess, this article also contains the answer.
Power BI Service · 03. April 2021
Here I will describe how to buy a brand new SKU, namely the Power BI Premium Per User Add-on. This SKU can be used to upgrade existing Power BI Pro licenses, either if you purchased a Pro license separately or together with an M365 E5 subscription, if you want to unlock new capabilities. The purchase is rather simple, just go to the M365 Admin portal purchase the necessary number of licenses and assign the Add-on to existing users that already have a Power BI Pro license assigned. BE AWARE (1),...
Data Visualization · 03. April 2021
This blog is about one visualization task. In particular, this task is called part-to-whole. Effective visualizations will reveal the contribution of a single item to the whole, as Claus Dieter Wilke calls this in his book "Fundamentals of Data Visualization": "… visualizing proportions … as part of the total." and how this task can be solved using Power BI, now and even more important in the future.
Data Modeling · 28. Februar 2021
Object Level Security (OLS) helps to protect our data assets inside Power BI. OLS can be applied to a table or just a single column.
Power Query · 18. Januar 2021
I tend to create tables using M or a combination of point-and-click and M, because these tables are treated as base tables if the model is refreshed and for this reason these tables will benefit from all the compression magic, whereas tables created using DAX are not that well compressed.