Tag: DAX

Learn How to Detect Abnormal Patterns Behavior in Your Datasets – Advanced Power BI

In this video tutorial, I will show you in detail how you can discover abnormal patterns of behavior within your 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 achieve and

Continue reading

How to Calculate The Number of Transactions Made in the Last N Days – Power BI Using DAX

Sometimes with your analysis in Power BI you may want to know how many transactions have occurred over a particular period of time. In this particular tutorial, I’ll show you exactly how you can calculate transactions within a given period of days.  Analyzing the transactional frequency could be crucial for a business.  Especially if you

Continue reading

Using The ALL Function In Power BI For High Quality Insights

This video tutorial shows you how you can use the ALL Function in Power BI to showcase unique insights. Think about this one from a deeper analytical perspective. We’re going to dive into the average order size for sales we may be making across a variety of different products. If you’re selling to a lot

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

Dynamic Scenario Analysis of Average Order Size – Analytics with Power BI

In this video tutorial, I’m going to go through something quite practical for a retailer who sells goods at a high frequency. When you are a business that sells a lot of goods – let’s think about an online retailer – if you can analyse how much you would benefit from increasing your average order

Continue reading