Skip to content
  • Blog
  • About
  • Blog
  • About

Power BI Composite Models Architecture Example

  • May 2, 2021May 3, 2021

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

How to Serve Three Dissimilar Analytics User Profiles

  • January 14, 2021February 15, 2021

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

How to Forecast Long-term Electricity Demand for Hedging, Residential Sector

  • November 20, 2020February 15, 2021

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

The Cost of Relationships, Snowflake vs Star Schema

  • October 8, 2020February 16, 2021

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

Power BI DAX How to Summarize Data From Multiple Tables

  • April 14, 2020February 17, 2021

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

  • « Previous
  • 1
  • 2
  • 3
  • 4
  • Next »

Recent Posts

  • How to Manage Analytics and Data Engineering Work with Azure Boards September 11, 2022
  • Operating Model for an Analytics Team June 28, 2022
  • Spark SQL vs T-SQL Date Query Differences March 28, 2022
  • Data Lake VS Delta Lake – Data Upsert and Partition Compaction Management August 21, 2021
  • Azure Synapse Serverless SQL Optimization with Examples June 6, 2021

Tag Cloud

Advanced Analytics (4) Analytics (2) Azure (2) Azure Boards (1) Business Development (4) Databricks (1) Databrics (1) Data Engineering (2) Data Factory (1) data lake (2) Data Modelling (7) Data Science (1) Data Visualization (2) data warehouse (2) DAX (7) delta lake (1) Leadership (2) Machine Learning (2) Management (2) on-demand SQL (1) Organizational Development (1) parquet (2) Power BI (12) Power Query (1) R (1) serverless SQL (2) SQL (4) Synapse (2)