Tag: DAX Calculations

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

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

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

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

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