Discover · Asset datasheet · BI & Semantics · Fabric IQRFP A.1
Commercial Semantic Model
Power BI / Fabric semantic model holding governed KPI measures (Gross Margin, Net Sales, Price Realization).
Access grantedCertified · trust 95InternalPromoted · v5.1Commercial Analytics
Ownership & purpose
- Owner
- Nestor Teijeiro Prado
- Steward
- Andrei Wint
- Approved purposes
- Performance reporting, Pricing analysis
- Usage (30d) · Updated
- 410 sessions · 2026-10-11
Semantic definitions
Gross Margin — Net Sales minus Cost of Goods Sold, including freight-out and excluding fixed manufacturing variances. Reported in EUR and as % of Net Sales.
GM = Net Sales − COGS ; GM% = GM / Net Sales
Contribution Margin — Net Sales minus all variable costs (raw materials, energy, variable logistics).
CM = Net Sales − Variable Costs
Net Sales — Invoiced gross sales minus rebates, discounts and returns.
Net Sales = Gross Sales − Rebates − Discounts − Returns
Price Realization — Ratio of achieved pocket price to target list price.
PR = Pocket Price / List Price
Lineage · Purview
Graph neighbourhood · Knowledge graph
Open in graph →measures Gross Marginmeasures Net Salesmeasures Price Realizationmeasures Contribution Marginvisualizes Sales Unified Viewvisualizes Price Waterfall Datasetvisualizes Pricing Performance Dashboarddocuments KPI Glossary: Gross Margin Definitionsimilar_to Margin Analysis Workbook (Personal)has_attribute semantic_model_measurehas_attribute kpi_measurehas_attribute measure_measure
Data quality
score 97| Completeness | Mandatory columns not null | 97 | pass |
| Freshness | Refreshed within 24 h | 98 | pass |
| Validity | Values within allowed domain / format | 94 | pass |
| Uniqueness | Primary key unique | 99 | pass |
Fig. 1 · Quality score, last 12 runs. Source: simulated observability rules.
Products and dependants
Part of data products
None
Downstream consumers affected by a change
Pricing Performance Dashboard
Open lineage viewAccess path
- Entra group membership grants access
Discovery does not consume data. Open via the source system under its own controls: