Tag: Budgeting Power BI

Budgeting Performance Segmentation Using DAX In Power BI

Budgeting performance analysis might sometimes require us to segment the results we currently have to different groups. This is to analyze which performers were better than others versus their targets. You may watch the full video of this tutorial at the bottom of this blog. Power BI can manage performance segmentation, and understand their differences

Continue reading

Budget Allocation: Monthly Forecasts Across Daily Results In Power BI

In this tutorial, I’ll go through a budget allocation technique in Power BI where you allocate Budgets at a monthly level versus Sales or Transaction Data at a daily level. You may watch the full video of this tutorial at the bottom of this blog. This scenario is very common when working with any type

Continue reading

Showcasing Budgets In Power BI – DAX Cumulative Totals

Recently, I built and showed a Budgeting Analysis Dashboard in one of Enterprise DNA’s workshop. One feature of that Dashboard is the Cumulative Budget view. The webinar is linked here. You may watch the full video of this tutorial at the bottom of this blog. The dashboard itself is dynamic so I can change the

Continue reading

Advanced Product Budgeting – Actual Results To Budgets Per Product

I’m going to go over something specific in product budgeting. It’s quite advanced but if you can understand the concepts and the techniques that I go through here, you’ll also have a good understanding of what Power BI can do, how DAX works, and how you can combine a lot of different functions to get

Continue reading

How To Create Budgets With Seasonality Impact Using Power BI

I’m going to show you something specific and quite advanced on budgeting through Power BI. We’re going to dive into how to create budgets with consideration on seasonal impact. You may watch the full video of this tutorial at the bottom of this blog. This has great potential mostly because it paves the way for highly

Continue reading