Tag: Forecasting

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

Implement Budgets & Forecasts Automatically in Power BI Using DAX

I’m going to show you with this tutorial how you can create budgets in Power BI that are purely based of historical information and complete it in an automatic way. When you create budgets and forecasts sometimes you may have to go through a very comprehensive process. So this is obviously isn’t going to cover

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

Create Dynamic Forward Forecasts in Power BI with DAX

Have you ever wanted to create automatic forecasts based on historical information? In the past, this was relatively difficult to do using tools like Excel but I’m going to show you in this video tutorial how you can do this in an almost automatic way inside of Power BI. What we’re going to do is

Continue reading

Compare Performance vs Forecasts Cumulatively w/DAX

Showcasing results cumulatively is, in my opinion, the best way to showcase trends in your data. When comparing data versus budget or forecasts, showing the trends or divergence in trend is essential. You want to make sure you can identify when your performance is breaking down as soon as possible and by viewing this cumulatively

Continue reading