Steven Franconeri, a Kellogg School of Management professor, has written a good article "4 keys to Effective – and Honest – Data Visualizations". I thought that he made some solid points; however, I strongly disagree with his opinion about what makes a chart honest or dishonest. https://youtu.be/E6A0cry7PUw As you look at the global temperature trend … Continue reading What Kellogg Professor Got Wrong about Effectiveness and Honesty in Data Visualizations
Category: Tutorial
Power BI Best Practices Analyzer in Tabular Editor
Wanted to do a quick video on how to use Power BI Best Practices Analyzer using Tabular Editor. There was a great blog post on it here: https://powerbi.microsoft.com/en-us/blog/best-practice-rules-to-improve-your-models-performance/ that covered a lot of details on what best practices were there to be aware of as well as the tool itself. However, the article seemed to … Continue reading Power BI Best Practices Analyzer in Tabular Editor
Progressive Discount (Tax or Commission) Calculation (Power BI DAX Tutorial)
I have to warn you, this is NOT a level 100 or even 200 tutorial. If you decided to proceed, that you absolutely positively have to get that progressive calculation work and I will have to assume that your DAX is pretty good, otherwise you would not be even attempting to tackle this problem. Also, … Continue reading Progressive Discount (Tax or Commission) Calculation (Power BI DAX Tutorial)
Constant Currency Analysis (Power BI DAX Tutorial)
Constant currency analysis is very popular when we need to take out FX rate fluctuations from our analysis. There are many different methodologies that companies used for determining what constant FX rate to apply to the historical values. In our tutorial, we will take a look at the time window for our analysis, figure out … Continue reading Constant Currency Analysis (Power BI DAX Tutorial)
Data Persuasion with BI: Top 5 Reasons Your Last Presentation was a FAIL
Unfortunately, life is hard and in BI world we are guaranteed to fail with our Data Persuasion every now and then. Having failed with my BI presentations many a time, I decided to write this article and frame up my top five reasons why I did and also suggest a few things for what you … Continue reading Data Persuasion with BI: Top 5 Reasons Your Last Presentation was a FAIL
Cumulative Discount or Commission Calculation (Power BI DAX Tutorial)
If you are looking to challenge your DAX skills while trying to figure out how to calculate a Cumulative Discount (or a Cumulative Commission) then this tutorial is for you. https://youtu.be/9hGowlw4YPc A Cumulative discount is calculated by finding the cumulative sales in the specified discount window, and then, using the cumulative sales as the parameter … Continue reading Cumulative Discount or Commission Calculation (Power BI DAX Tutorial)
How to Calculate Revenue and Margin Using Price and Cost History Tables (Power BI DAX Tutorial)
I use Sales data a lot in my tutorials and usually the Sales Fact table will have the following fields in it: DateProductRevenueUnits Along with a bunch of other stuff…. Now, it is actually very common for a company to only provide Units in the Sales Table along with a Price History and/or Cost History … Continue reading How to Calculate Revenue and Margin Using Price and Cost History Tables (Power BI DAX Tutorial)
Data Persuasion: Basic Concepts and Definitions
The older and wiser that I get, the more I realize that our framework of values and motivations is often not so much based on our own experiences and learnings but rather on effectiveness of persuasion of individuals who have taken their time and used their skills to instill our values and to create our motivations. You too can learn how to use data to persuade your audience...
DAX for Perfect Price Volume Mix (PVM) Calculation (Power BI Tutorial)
EDIT 2021-03-18: I have added two additional buckets for PVM analysis with New Products and Discontinued Products in this new blog post/video. This is the third installment in the series; however, you are not required to read the previous two to follow along. Part I - I frame up the basic concept of analysis in … Continue reading DAX for Perfect Price Volume Mix (PVM) Calculation (Power BI Tutorial)
Part II – The Definitive Guide to Price Volume Mix Calculation (PVM) in Power BI – The Perfect Mix
EDIT 2020-12-14: if you are looking for the perfect mathematical formula and the DAX necessary to implement PVM, please go the latest post/video in this series - DAX for Perfect Price Volume Mix (PVM) Calculation (Power BI Tutorial) In the Part I of this series, I mentioned that I was cutting some corners with my calculation … Continue reading Part II – The Definitive Guide to Price Volume Mix Calculation (PVM) in Power BI – The Perfect Mix
business intelligist 