Tag: Advanced Power BI

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

Implementing The Pareto (80/20) Principle in Your Power BI Analysis

Have you ever heard of the Pareto Principle, also known as the 80/20 Rule? The rule stipulates that for every 20% of something, you’ll generally receive 80% of the results. If we look at this from a business perspective, we’re saying that 20% of our customers should make up 80% of our profits, or 20%

Continue reading

Segmentation Example Using Advanced DAX in Power BI

Once you get more and more into advanced DAX formulas, you will see the world of analytical opportunities immeasurably expand for you. In this example I will show you by just how much. In this blog post, I am going to explore some relatively advanced DAX logic and then build upon it by combining an

Continue reading

Power BI Data Sets: Learn How To Detect Abnormal Behavior Using DAX

In this blog post, I will show you in detail how you can discover abnormal patterns of behavior within your Power BI data sets. This is not something that will immediately stand out when running analysis across your data so you have to think quite analytically about it. By thinking deeply about what you want to

Continue reading

Calculating Average in Power BI: Isolating Weekday or Weekend Results Using DAX

Calculating an average in Power BI can be done in many ways to give you precise information for your business reports. However, sometimes calculating average sales per day may not be enough. You might run into a scenario where you only sell during weekdays. If you run an averaging pattern in Power BI and you

Continue reading