Tag: Sales vs Budgets Power BI

Reports For Retail Sales Performance In Power BI

In this Power BI Showcase, we’ll be reviewing retail site performance reports in Power BI. We’re looking at a sizeable business located on the East Coast of the US. We’re getting the metrics of all the retail sites which includes some main states and cities. You may watch the full video of this tutorial at

Continue reading

Grouping Results Based On Performance Vs Benchmarks In Power BI

In this tutorial, I’m going to break down how to effectively represent a budgeting analysis using segmentation and grouping techniques in Power BI. You may watch the full video of this tutorial at the bottom of this blog. This is a breakout session from a Learning Summit course in Enterprise DNA Online. This technique will

Continue reading

Sales Vs Budgets Insights – Extended Budget Allocation Formula

Actuals vs Budgets - Comparison Insights w/Power BI

In this tutorial, I’m going to show you an extended version of the ultimate Budget Allocation methodology that allows you to compare your Sales vs Budgets. You may watch the full video of this tutorial at the bottom of this blog. The Budget Allocation formula allows you to solve data with mismatched granularities. For example,

Continue reading

Showing Cumulative Results vs Targets Only To Last Sales Date in Power BI

In this tutorial I demonstrate how to create a cumulative visualization in Power BI, showing cumulative results versus targets or budgets. This is a really good visualization to show things over time. You may watch the full video of this tutorial at the bottom of this blog. But, in this example, I only want to

Continue reading