Budgeting Analysis On Best & Worst Performers Using Power BI

I run through a lot of budgeting analysis because I think using Power BI for this type of analysis is extremely effective. Power BI as a tool covers a lot of the analytical components that need to be executed well to complete this analytical work, and then showcases it in an effective way. In this

Continue reading

The Importance Of Creating Compelling Power BI Visualizations

I think this is a good opportunity to run through why creating great visualizations is so important in Power BI. So many times I see reports unfortunately let down by the visualization components of developing within Power BI Desktop. What I demonstrate in this tutorial is a number of techniques that you could leverage off

Continue reading

Running Sensitivity Analysis For Power BI Using DAX

Have you ever thought it would be nice to work out what the most optimal outcome is from your scenario analysis work that you’re doing inside of Power BI? In this tutorial, I show you exactly how you can discover this and also include sensitivity analysis techniques to your what-if parameter and scenario analysis work.

Continue reading

Managing Seasonality In Your Budget Analytics – Advanced Power BI

Completing budgeting analysis in Power BI is unfortunately just not that easy. What I’m going to go through today is possibly the most advanced technique that you can get to with budget analytics as we need to incorporate some seasonality into our budgeting numbers. I detail this quite extensively in the video tutorial, so there’s

Continue reading

Find Your Top Clients Across Different Measures in Power BI

Here at Enterprise DNA, we are building an analytical movement with Power BI. Today, I am going to walk you through how you can create an awesome visualization where we dynamically showcase only our top ranked clients using multiple measures in Power BI. What we have here is a slicer which dynamically changes the visualizations

Continue reading