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
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 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
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
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