Should core PowerBI visuals natively support Parent Child hierarchies? Yes... do they? No... We have to deal with blanks and repeats and all kinds of things to make our charts and tables look nice. Well, in this video I offer you my approach to clean up your visualizations so they look exactly the way you want them to look.
Category: Storytelling
Streak Analysis – From DAX to Reporting
If you are trying to manage customer or employee engagement, but have no quantitative understanding of impressions, engagements, and conversions, then you have zero grasp of your reach. If basics are covered, you should focus on the quality of the engagement. Streak Analysis could be very useful to understand patterns of engagement. Learn how to create the DAX calculations and use them in a report in this video.
Elevate Your Dashboard Credibility with Expert Storytelling Tips
I've just dropped a new video that dives deep into the art of crafting highly credible and compelling dashboards. https://youtu.be/RpQyKz43BnE In this video, I'm peeling back the layers on what it truly takes to enhance your dashboard's credibility. You'll learn the dual pillars of establishing trust: showcasing your competence and demonstrating honesty to your audience. … Continue reading Elevate Your Dashboard Credibility with Expert Storytelling Tips
How To Use Animated GIFs in Power BI
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
Forecasting Measure 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
Price Volume Mix (PVM) Calculation in Power BI with New and Discontinued Products (Power BI Dax Tutorial)
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)
Decision Tree for Data Visualizations?
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?
Market Basket Analysis (Power BI DAX Tutorial)
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)
Dynamic Dropdown Navigation in PowerBI
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
What Kellogg Professor Got Wrong about Effectiveness and Honesty in Data Visualizations
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