I had the chance to present 8.4.2021 in Power BI User Group Finland how Helen Ltd. uses Power BI composite models at the enterprise scale. Here is a summary of the presentation, with the example… Read More »Power BI Composite Models Architecture Example
The key to drive business with numbers and digitalization is to enable seamless analytics and the excitement of discovery to different analytics user profiles. I have encountered three key analytics user profiles in business: DIY.… Read More »How to Serve Three Dissimilar Analytics User Profiles
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