In this tutorial, I’ll show you how a powerful data outlier and anomaly type analysis using dynamic outlier trigger points. What’s the importance of dynamic outliers? Well, look at this example. Look at the number 10,000 in the scatter chart. In any particular quarter or quarterly selection, if Sales were above 10,000 or more than
We are going to take Power BI development to the next level and discover important new trends in our data. First, we need to dive into our data outliers through some advanced logic in Power BI using DAX. I’ll help you understand the difference between raw and filtered contexts. So, we’re going to analyze and
Many times with the analytical work that you are completing, you may want to showcase anomalies. The reason for doing this type of analysis is that you will sometimes want to understand why you’re receiving some type of outlier or anomaly in your data set. Additionally, you want to be able to narrow your focus into
In this tutorial, I’ll take you through an outlier detection analysis, detecting and visualizing outlier results. Your data doesn’t even need to be unique or customized. The great thing is that you can do this on basically any data set. I’m going to show you just how amazing Power BI is as an analytical tool.
