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
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%
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
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
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
