Skip to content
  • Blog
  • About
  • Blog
  • About

Power BI Financial Date Table

  • March 5, 2019February 13, 2021

Power Query M code to create date table to cover most fiscal date related reporting needs What Most data models need a calendar table. The more the calendar table can do itself the simple and… Read More »Power BI Financial Date Table

Power BI R Matrix Bubble Chart Sales Opportunity Analysis

  • November 21, 2018February 15, 2021

A powerful Power BI R graph, customized matrix bubble chart, to visualize 3 facts by 2 dimensions at the same time What Sales, % of opportunities won (hitrate), and margin % are some of the… Read More »Power BI R Matrix Bubble Chart Sales Opportunity Analysis

SQL How to Forecast with Linear Regression

  • September 15, 2018February 15, 2021

SQL can be used to create even hundreds of thousands of linear models with one variable, quickly. What Solving the SLOPE and INTERCEPT parameters of a linear model equation with one variable is easy with… Read More »SQL How to Forecast with Linear Regression

Power BI DAX When to Use Measure VS Calculated Column VS Other Tools

  • June 11, 2018February 15, 2021

What It is good to look after the DAX MEASURE calculation performance and user experience. Consider when it might be smarter to use Power Query or SQL or DAX CALCULATED COLUMN and make a certain… Read More »Power BI DAX When to Use Measure VS Calculated Column VS Other Tools

Three Key Practices to Perfect Data Visualization

  • February 22, 2018February 23, 2021

Data visualization communicates what is happening and why it is important. The best visualizations tell a simple story in a matter of seconds. The story has a designed impact to the listener. Here are listed… Read More »Three Key Practices to Perfect Data Visualization

  • « Previous
  • 1
  • 2
  • 3
  • 4

Recent Posts

  • Product Thinking in Data Modelling June 27, 2023
  • 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

Tag Cloud

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