Finding Patterns In Your Data – Advanced Analytical Technique with Power BI

Today I’m going showcase how you can discover patterns in your data when using Power BI. As you know, Power BI is an amazing analytical tool and by using scatter charts effectively you can showcase some amazing insights. What I do find with scatter charts, especially if there are a lot of data points, is

Continue reading

Calculate Rolling Totals in Power BI Using DAX

Here I’m going to show you how you can calculate the amount sold between two different dates. Another way to think about this is calculating rolling sales or running totals. We need the calculation to be dynamic, so that as we move through time we have a number that re-calculates based on the time frame

Continue reading

Inventory Management Insights with Power BI

In this example, we’re going to dive into inventory management data. I’m adding a bit more variety into some of the Power BI development that I showcase here, and this is quite a unique insight around managing your inventory. All data has it’s nuances so learning a variety of techniques will place any analyst in

Continue reading

Where Are Your Best Sales By Product? Advanced Analytics with Power BI

In this particular example, I really wanted to showcase how you can extract information out of your data sets based on ranking techniques in Power BI. With this example, I focus on top product sales in each individual region. If we think about what we have to do there, we need to work out what

Continue reading