I have decided to spend some more time on Market Basket Analysis, but before I get into the storytelling part of it, I had to clean up and fix a few things in the model file for the Market Basket Analysis that I created a few years ago. https://youtu.be/3OlZuXH9Y_g Market Basket Analysis is very important … Continue reading Market Basket Analysis (Power BI DAX Tutorial)
I have already done a video/post on how to implement a static drop down navigation, so in this tutorial I will cover how to implement a dropdown navigation where options are dynamically populated based on the identity of the user. https://youtu.be/wcNYHmCMEuA The Power BI desktop file used in this tutorial can be downloaded here. The … Continue reading Dynamic Dropdown Navigation in PowerBI
I suspect that many of you have looked at the title of this video and immediately thought that I was just being silly and provocative. And, generally speaking, you would be right as I do enjoy a fair amount of silly and provocation every now and then. However, in this case, even though I do … Continue reading Is Snowflake One Bad Quarter Away from Being Microsoft Power BI Biggest Threat?
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
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)
I found this interesting chart on Datawrapper.de and it made me think about how (and whether) my chart selections also changed over time. https://youtu.be/NV5QeQdnv1Y (Datawrapper is a pretty cool tool that allows users to upload their data and create pretty stunning visualizations) In this chart, Datawrapper has analyzed changes in distribution of chart styles selected … Continue reading How Good are Your Chart Choices?
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)
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)
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)
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...