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
Sometimes when analyzing your Power BI reports, you may want to know how many transactions have occurred over a particular period of time. In this blog post, I’ll show you exactly how to calculate transactions within a given period of days using time intelligence in Power BI. This post will cover a high quality piece
It’s the goal of every organization to see their business become successful. That said, understanding customer behavior deeply is one of the elements you can leverage for increased business success. One way to do this is by knowing your customers’ last purchase date in Power BI. In this blog post, I am going to demonstrate
With Basket Analysis, what we’re trying to achieve is analyzing one grouping of products versus another grouping of products. There’s plenty of application for this across Power BI. The theory we’re trying to work through with this type of analysis is if one grouping of products is bought with another grouping of products. By running
