Category: Business Intelligence

How To Detect & Showcase Outlier Results In Power BI

In this video tutorial, I’m going to show you just how amazing Power BI is as an analytical tool. I’ll take you through how you can effectively visualize outliers in your data sets. 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.

Continue reading

Average Results Per Month – DAX & Power BI Analysis Technique

In this video tutorial, I dive into some procurement & purchasing type analysis that you can do with Power BI. Specifically, we’re going to look at the average monthly purchases a business may be making. I run through what DAX formula combination you need to be able to calculate averages at a monthly context. I

Continue reading

Procurement Decision Making Models & Analysis In Power BI

Today, we’re going to dive into some purchasing decision-making within organizations. This tutorial showcases the versatility of Power BI to help make insightful decisions for a procurement division. I’m going to run through an intro example where we’ll start from raw data, create a quick data model and then run some analysis. Then I’ll get

Continue reading

Month On Month Change For Custom Calendars In Power BI – 445 Calendars

This video tutorial is all about how you can run time intelligence calculations over custom calendars in Power BI. This is really relevant to those who deal with 445 calendars which is a very common scenario for Power BI users. Not all business out there work to a standard calendar around financial years or calendar

Continue reading