I had the chance to make a public presentation on the development and results of a forecasting model used in the hedging of the electricity sales of Helen Ltd. Helen has over 450,000 customers throughout… Read More »How to Forecast Long-term Electricity Demand for Hedging, Residential Sector
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
Think about trying to find something from a book without looking the table of contents. This is what SQL server does as a standard with a table which does not have indexes. What In this… Read More »SQL Window Function 4 Times Faster with an Index
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