← All demos
// finance

EBITDA – actual vs. budget

A finance overview for management: where the group makes money, how it compares to budget and what exactly drove the gap.

Web replica of a Power BI report on fictional data. No company data.

What the report shows
  • An EBITDA bridge from budget to actual split into volume, price & mix, cost and other effects.
  • Variance to budget by division with cross-filtering – clicking a division filters the whole report.
  • Monthly trend against budget and a detail table by month and division.
How it is built in Power BI
  • Variance decomposition into volume and price/mix effects in DAX
  • Waterfall built from a helper table of steps
  • Budget and actual in one model, variances via DIVIDE
  • Cross-filtering and synced slicers
// contact

Let's talk about data.

Happy to discuss BI, reporting or AI in analytics. Drop me a line.

Actions
LinkedInGitHubČeská verze
↑↓ move↵ openEsc close
Česká verze