Tag: Advanced analytics

New vs Existing Customers – Advanced Analytics In Power BI

If you’re an online retailer or a high frequency sales operation, then understanding your customer base, like if they are new customers or existing customers, is a really high quality insight that you can achieve using advanced analytics in Power BI. You’ll want to dive into this type of analysis because you need to evaluate

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

How To Evaluate Clusters in Your Data Using DAX Technique in Power BI

In this tutorial, I’m going to show you how showcasing clusters in your data enables you to extract far superior insights than if you just had a scatter chart with a whole lot of information planted in there. I’m going to go through some advanced DAX techniques that you need to utilize in combination with

Continue reading

Analysing Customer Trend Using DAX In Power BI

In this tutorial, we’re really going to use Power BI as an analytical tool to analyse customer trend. We’re going to work out how we can find our customers that are purchasing behind trend. We want to know this so we can keep a really close eye on how our customers’ purchases are going. We

Continue reading