Net revenue
€0
0%vs comparable prior period
Finance analytics case study
Revenue Trend Report
A decision-focused Power BI concept that turns monthly revenue, budget and cost movement into a concise executive view—built to reveal momentum, variance and the markets driving change.
Interactive report
Executive revenue overview
Use the period controls to recalculate the full report. KPIs, trend lines, product mix and regional performance remain tied to one filter context.
Contribution profit
€0
0%contribution margin
Budget variance
€0
0%against revenue plan
Best month
—
€0highest net revenue
Revenue vs budget
Monthly net revenue and plan
Revenue mix
Share by product vertical
Market contribution
Revenue allocation and year-on-year movement
| Market | Revenue | Share | YoY |
|---|
Business interpretation
From movement to action
The report is designed around the questions finance leaders ask first: what changed, where it changed and which response deserves priority.
Momentum strengthened
Revenue finishes above plan as the second half outperforms the first, with Q4 providing the strongest quarterly contribution.
Mix supports margin
Higher-value Casino and Live Casino activity expands the contribution base while Sportsbook remains the largest single product vertical.
Protect efficient growth
Prioritise retention in high-growth markets and review acquisition efficiency before increasing spend in slower regional segments.
Build approach
Model and methodology
A compact star schema and explicit measures keep finance logic auditable, reusable and responsive to report filters.
Semantic model
- FactRevenue at month × market × product grain, containing revenue, variable cost and budget amounts.
- DimDate, DimMarket and DimProduct filter the fact table through one-to-many, single-direction relationships.
- Power Query standardises source types and keys; DAX handles filter-sensitive financial measures.
- Variance uses budget as its denominator and returns blank when a valid comparison is unavailable.
Representative DAX
Revenue Variance % =
VAR ActualRevenue = [Net Revenue]
VAR BudgetRevenue = [Revenue Budget]
RETURN
DIVIDE (
ActualRevenue - BudgetRevenue,
BudgetRevenue
)
Have a reporting challenge?
Let’s turn the numbers into a decision.
I build clear analytical experiences that connect reliable models, useful measures and executive-ready data storytelling.