Tag: DAX Formulas

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

Advanced Analytics in Power BI: Layering Multiple 'What If' Analysis

In this tutorial, I show you how you can layer multiple “What If” analysis or scenarios in Power BI, one on top of each other. It takes your analytical output through the roof if you use this technique effectively. As you likely know, I am a huge promoter of scenario analysis in Power BI. Scenario

Continue reading

Advanced DAX For Power BI: Implementing Ranking Logic Across Unique Insights

Here, we’re going to dive into Advanced DAX in Power BI. The idea behind this tutorial is to show you how we can get to a very unique insight with Power BI, but do it in an intuitive way. In this example, I’m going to focus in on margin growth in the sales of an

Continue reading

Power BI Analytics: Run Scenario Analysis On Average Order Size

In this tutorial, we dive into the power of Power BI analytics. I’m going to go through something quite practical for a retailer who sells goods at a high frequency. When you are a business that sells a lot of goods – say an online retailer – if you can analyse how much you would

Continue reading

Evaluating Customer Margin Contraction Using Power BI

Here we’re going to look at customer margin contraction. We’re going to try and work out what customers margins are contracting and why are they contracting. Is it because of their purchasing frequency? Is it because of the products they’re buying? Or because of some other reason? We’re going to solve this analytical problem with

Continue reading