Category: Scenario Analysis

How To Create Budgets Which Have Seasonality Adjustments – Power BI Technique

We’re going to get advanced today around budgeting in Power BI. Occasionally, you will not actually have some unique budgeting or forecasting data and you need to create it. Most forecast or budgets will likely be created based on historical results in some way. You might do something very simple, like finding the results from

Continue reading

Calculating How Much Profit We May Be Losing Out On – Power BI Analytics

Here I want to dive in a real world application of Power BI – How can we discover how much profit are we missing out on? There are probably a few ways that you could work out solutions to this. The way I have done it with this example is to focus in on margin

Continue reading

Learn Which Customer Groups Experienced The Greatest Growth – Power BI & DAX

In this example, we’ll run through a unique insight you can discover in Power BI. What we need to do is to combine a range of different formula techniques to get the intended result. If you do this inside your own models with your own analysis, you will discover high-quality insights that will generate an

Continue reading

What’s The Most Common Behavior From Your Customers? – Power BI Analysis

In today’s business world, understanding common customer behavior is of utmost importance for many functional areas within companies.  Analyzing consumer behavior serves as a tool to help plan and meet sales objectives. Additionally, understanding buyer behavior helps decide where and how to better position products or services. You can evaluate how your customers act and predict

Continue reading

Predict Future Profitability within Power BI Using DAX

In this video tutorial, I will showcase some of the analytical work I enjoy completing the most in Power BI..that is working on future predictions.  I am always fascinated with trying to understand what could happen in the future. I’ll show you a technique around how you can almost predict future profitability and one that

Continue reading