When an analytics team follows the same working, documentation, and communication practices the team members have an easier time understanding each other as there is a single source of truth. Furthermore, solutions are accessible, transparent,… Read More »Operating Model for an Analytics Team
A Power BI DAX query time comparison of snowflake and star schema based on a sales reporting model done with Power BI. What Consider the relationships of the tables in Figure 1 below. The setup… Read More »The Cost of Relationships, Snowflake vs Star Schema
SUMMARIZE AND SUMMARIZECOLUMNS DAX function examples. Discussion on DAX MEASURE usage vs static alternatives. What Often there is a need to (distinct) count or sum values based on multiple filtered tables over a selected variable… Read More »Power BI DAX How to Summarize Data From Multiple Tables
An example on creating a virtual table relationship with DAX TREATAS function. What Sometimes due to business logic we want to link two tables with a different key than the one already in the data… Read More »Power BI DAX How to Link Data Without a Table Relationship
An example on DAX SUMX function which is the perfect row iteration function for a lot of use cases What Often there is a need to calculate a DAX measure in a row level combining… Read More »Power BI DAX How to Calculate in Row Level with Multiple Tables