Tag: Advanced Power BI

Implementing 80/20 Logic in Your Power BI Analysis

Have you ever heard of the Pareto Principle? Another name for it is the 80/20 Rule. The rule stipulates that for every 20% of something, you’ll generally receive 80% of the results. So if we look at this from a business perspective, we’re saying that 20% of our customers should make up 80% of our

Continue reading

Evaluate Clusters in Your Data – Advanced Power BI and DAX Technique

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

Where Are Your Best Sales By Product? Advanced Analytics with Power BI

In this particular example, I really wanted to showcase how you can extract information out of your data sets based on ranking techniques in Power BI. With this example, I focus on top product sales in each individual region. If we think about what we have to do there, we need to work out what

Continue reading

Update to Multiple Currencies Management in Power BI – Advanced DAX

There are so many occurrences in financial analysis where we need to integrate exchange rates. Now, I have actually shown an example of how to do this using the LOOKUPVALUE function in Power BI. There is one slight issue with the particular function I went through in the initial video that I didn’t realize at

Continue reading