Never thought I would have to tackle this ever in my life, but never say never… today I actually had to figure out how to use an animated GIF as a part of my Power BI report. You might assume that this should be very simple, all you have to do is place this image … Continue reading How To Use Animated GIFs in Power BI
In this lab we will be implementing a forecasting measure using DAX. We will not be generating a forecast data set, rather, we will create a measure that will look at the actuals from the past to forecast what will happen in the future. We will be using a CDC data set of US Deaths. … Continue reading Forecasting Measure in Power BI
This is a common business scenario, but it turns out that you have to do quite a bit of work in Azure Data factory to make it work. So the goal is to take a look at the destination folder, find the file with the latest modified date, and then use that date as the … Continue reading Incrementally Load New Files in Azure Data Factory by Looking Up Latest Modified Date in Destination Folder
Price Volume Mix (PVM) calculation is one of the most popular topics on my blog and YouTube channel. Although, I have covered the DAX for the perfect PVM before, I have gotten a lot of requests to extend the PVM logic to include a separate bucket for discontinued products as well as new products. You … Continue reading Price Volume Mix (PVM) Calculation in Power BI with New and Discontinued Products (Power BI Dax Tutorial)
Have you ever tried to display your North American or European states on a map only to find that one or more of them have suddenly moved to Latin America or Africa? I know that I run into this issue all the time. In this video I will give you two strategies to make the … Continue reading How to Fix Power BI Map Geocoding Issues
Here is an interesting idea, can you have a prescriptive approach in selecting a right chart for your storytelling? In this article https://www.kdnuggets.com/2021/02/telling-great-data-story-visualization-decision-tree.html the author suggests that a simple decision tree can help you in guiding your choices. https://youtu.be/LW-50zDTteQ I found the approach to be very interesting, albeit not all branches of the decision tree … Continue reading Decision Tree for Data Visualizations?
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?
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