Customer comparison — this window vs the same window last year
One row per Dynamics 365 Account. Click a column heading to sort. Gold edge = revenue grew but margin fell.
| Customer | Revenue | Prior | Δ rev | GM | Margin % | Prior % | Δ pp |
|---|
What this board answers
The three questions from your July 2025 discovery call, answered from the filtered data.
24-month revenue and margin trend
Bars: monthly revenue (USD). Line: gross margin %. Shaded: the two windows being compared.
Revenue, current windowRevenue, prior-year windowOutside windowMargin %
Margin by product line
Bar = margin %; tick = 30% house target. Right column = revenue in window.
Fabrication network — where the revenue ships from
Three ITL fabrication centres and the customer regions they serve. Circle area = revenue in window; lane colour = serving plant.
Ask the data
A plain-English question over the same semantic model (concept — answers reference the tables above).
Which customers grew revenue but lost margin this year?
