← 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.