Working Out Sales Periods Using DAX in Power BI: Weekday vs. Weekend

It’s important for many businesses to make sure that you are analyzing over the correct sales periods or correct time periods in which you actually have results. If you implement formulas incorrectly in Power BI, especially with iterating functions like AVERAGEX or SUMX, and you iterate over days when you don’t have results, or days without

Continue reading

Basket Analysis Example – Power BI Advanced Analytics

In this tutorial, I’m going to run through some of the most advanced types of analytical work you can do with Power BI, and that is Basket Analysis. This theoretical concept has lots of applications across Power BI. What I’m going to go into here is how you can use this type of analysis to

Continue reading

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