Aurea Quantra
Azure · synthetic demo · manufacturing & distribution scenario
Synthetic demo Saturday, November 21, 2026 11:43 AM All demos Consulting page Book My BI Diagnostic

Platform demo · Azure data

Pipeline map: ADF/Synapse stages into defensible KPIs

Inspect synthetic ADF-style runs—duration, SLA pressure, and landing-target choice (Azure SQL / Synapse / Fabric-adjacent) before executive consumption.

How this maps to Azure

Azure data consulting for mid-market BI and analytics.

  • Pipeline stage durations and row throughput
  • SLA breach flags on long runs
  • Landing-target switch rewriting the handoff story
  • Synthetic scenario; not a live Azure subscription
Filters Invoice scope
Server CSV

Filters apply to revenue charts and the first two KPIs. Other tabs use the full demo model. Use Copy link to share this view.

Azure pipeline map

ADF / Synapse-style runs, row throughput and status, and where curated facts land.

Aurea Quantra is independent. No partnership with Microsoft is claimed; product names belong to their owners.

Illustrative pattern · synthetic data

Stack

  1. ERP / CRM
  2. Azure Data Factory
  3. ADLS Gen2
  4. Azure SQL / Synapse
  5. Semantic model
  6. Power BI

Illustrative pattern · synthetic data

Pipeline runs

15

Illustrative pattern · synthetic data

Succeeded

15

Illustrative pattern · synthetic data

Not succeeded

0

Illustrative pattern · synthetic data

Illustrative pattern · synthetic data

Rows written by pipeline (latest runs)

Illustrative pattern · synthetic data

Runs by status

Illustrative pattern · synthetic data

KPI recipe: gross margin % T-SQL

SELECT d.year_month,
       CAST(SUM(f.gross_margin) AS decimal(18, 4))
         / NULLIF(SUM(f.revenue), 0) AS gross_margin_pct
FROM dbo.fact_invoices AS f
JOIN dbo.dim_date AS d ON d.date_key = f.date_key
GROUP BY d.year_month;

Illustrative pattern · synthetic data

Semantic objects

ObjectTypeNotes
dbo.bridge_crm_erp_keysAzure SQL tablebridge
dbo.dim_channelAzure SQL tabledimension
dbo.dim_customerAzure SQL tabledimension
dbo.dim_dateAzure SQL tabledimension
dbo.dim_productAzure SQL tabledimension
dbo.dim_regionAzure SQL tabledimension
dbo.dim_sales_repAzure SQL tabledimension
dbo.fact_inventory_backlogAzure SQL tablefact
dbo.fact_invoicesAzure SQL tablefact
dbo.fact_opportunitiesAzure SQL tablefact
dbo.fact_opportunity_stage_histAzure SQL tablefact
dbo.fact_sales_ordersAzure SQL tablefact
dbo.fact_samplesAzure SQL tablefact
Total RevenueSemantic model measurecertified · Finance
Revenue YTDSemantic model measurecertified · Finance
Gross MarginSemantic model measurecertified · Finance
Gross Margin %Semantic model measurecertified · Finance
Open BacklogSemantic model measurecertified · Operations
Pipeline ValueSemantic model measurecertified · Sales
Weighted PipelineSemantic model measurecertified · Sales
Sample Conversion %Semantic model measurecertified · Sales
Draft Channel MixSemantic model measuredraft · Sandbox
Uncertified Discount GuessSemantic model measuredraft · Sandbox
Bookings vs Billings GapSemantic model measuredraft · Sandbox

Illustrative pattern · synthetic data

Data-quality checks

Computed from the demo tables when the app loads them. “warn” marks mismatches this scenario includes on purpose.

CheckTableRows checkedFlaggedStatus
Invoices have a customer key fact_invoices 22,000 0 pass
Invoice customer keys exist in dim_customer fact_invoices 22,000 0 pass
Invoice product keys exist in dim_product fact_invoices 22,000 0 pass
Invoice dates exist in dim_date fact_invoices 22,000 0 pass
Invoice revenue is not negative fact_invoices 22,000 0 pass
Gross margin does not exceed revenue fact_invoices 22,000 0 pass
Opportunity customer keys exist in dim_customer fact_opportunities 4,500 0 pass
Customer keys are unique dim_customer 500 0 pass
Customers matched between CRM and ERP dim_customer 500 90 warn
Every month 2023-01..2026-12 has invoices fact_invoices 48 0 pass

Illustrative pattern · synthetic data

Pipeline / job stages

  • bi_dataset_publish · adf · succeeded · 3,039 rows
  • bi_dataset_publish · adf · succeeded · 3,265 rows
  • bi_dataset_publish · adf · succeeded · 1,888 rows
  • semantic_refresh · adf · succeeded · 6,498 rows
  • semantic_refresh · adf · succeeded · 9,237 rows
  • semantic_refresh · adf · succeeded · 4,866 rows
  • synapse_load · adf · succeeded · 10,028 rows
  • synapse_load · adf · succeeded · 6,235 rows
  • synapse_load · adf · succeeded · 6,888 rows
  • ingest_crm_opps · adf · succeeded · 6,858 rows
  • ingest_crm_opps · adf · succeeded · 8,894 rows
  • ingest_crm_opps · adf · succeeded · 6,694 rows
  • ingest_erp_orders · adf · succeeded · 4,997 rows
  • ingest_erp_orders · adf · succeeded · 3,016 rows
  • ingest_erp_orders · adf · succeeded · 8,597 rows

Illustrative pattern · synthetic data

How to present this

  • Pick a landing target to reframe where curated facts land before the semantic model.
  • Run status and row counts come from the synthetic pipeline run table.
  • Synthetic runs — not a live Azure subscription.

Illustrative pattern · synthetic data

What the AI insight is told about this platform

Platform lens: Azure pipeline map. Emphasize warehouse-to-BI handoff and maintainable integration.

The model also receives the synthetic KPIs, the current invoice slice and the semantic model summary.