There are three main points of advantages in using aggregations (what we can get from the official documentation): Better query performance over big dataOptimized data refreshBalanced architectures First, I connet to the AdventureWorksDW database. We choose a couple of tables (fact + dimension): Connect the tables into a data model Now, to have an aggregation … Continue reading Aggregations in Power BI
Author: Jani Zajc
Non-linear Time Visuals
Sometimes a requirement in a project is to have visual that represents a trend over time. Easy. Value, on the axis some time dimension values and voila! Easy as pie. Well, however, then there's the client that is/was used to seeing trends and the comparison versus some previous value, that is also not from the … Continue reading Non-linear Time Visuals
Camel Case Column Renaming – The new Way in #PowerBI #PowerQuery
A new splitter function has been discovered in Power Query (by Chris Webb and also others probably) which is not in the highlight notes of the February 2019 PBI release, but it is a very nice addition - Splitting Text By Character Transition. So, I had an adequate use case some time ago when I didn't … Continue reading Camel Case Column Renaming – The new Way in #PowerBI #PowerQuery
Row Store to Column store… Story
First of all, defining the terms, a row store table or index is a classical table without any index (heap) or with a CI (clustered index) in a row store format. This was not regularly mentioned or discussed, because it was the only way for years...(decades...). Except starting with SQL Server 2014 it was the … Continue reading Row Store to Column store… Story
Pareto Rule, ABC Class in DAX
The pareto rule can be applied to almost all areas of life. Here, we are going to explore how we can calculate it in DAX, efficiently. Starting with the source calculation, which is adapted from the Dynamic - ABC Classification from the guys of SQLBI.com. With the addition of variables in DAX some calculations can … Continue reading Pareto Rule, ABC Class in DAX