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

Platform demo · Fabric readiness

OneLake path: lakehouse → warehouse → semantic → report

Click through curated stages and quality checks that precede Copilot—trust and semantic contract before Fabric sprawl. Synthetic manufacturer facts only.

How this maps to Microsoft Fabric

Microsoft Fabric consulting and readiness for mid-market teams.

  • Clickable OneLake-style stage canvas
  • Quality events feeding trust badges
  • Shortcut vs materialize row-count toggle
  • Pragmatic staging: Power BI-quality model before Fabric sprawl
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.

OneLake path: lakehouse → semantic → report

Pick a stage, compare shortcut vs materialize, and see the quality checks that gate the semantic model.

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

Illustrative pattern · synthetic data

Stack

  1. Source systems
  2. OneLake
  3. Lakehouse
  4. Warehouse
  5. Semantic model (Direct Lake)
  6. Power BI report

Illustrative pattern · synthetic data

Pipelines

8

Illustrative pattern · synthetic data

Quality checks

10

Illustrative pattern · synthetic data

Checks failing

0

Illustrative pattern · synthetic data

Illustrative pattern · synthetic data

Rows flagged by each quality check

Illustrative pattern · synthetic data

Latest pipeline runs by status

Illustrative pattern · synthetic data

KPI recipe: gross margin % DAX (Direct Lake semantic model)

Gross Margin % =
DIVIDE (
    SUM ( fact_invoices[gross_margin] ),
    SUM ( fact_invoices[revenue] )
)

Illustrative pattern · synthetic data

Semantic objects

ObjectTypeNotes
lakehouse.bridge_crm_erp_keysLakehouse tablebridge
lakehouse.dim_channelLakehouse tabledimension
lakehouse.dim_customerLakehouse tabledimension
lakehouse.dim_dateLakehouse tabledimension
lakehouse.dim_productLakehouse tabledimension
lakehouse.dim_regionLakehouse tabledimension
lakehouse.dim_sales_repLakehouse tabledimension
lakehouse.fact_inventory_backlogLakehouse tablefact
lakehouse.fact_invoicesLakehouse tablefact
lakehouse.fact_opportunitiesLakehouse tablefact
lakehouse.fact_opportunity_stage_histLakehouse tablefact
lakehouse.fact_sales_ordersLakehouse tablefact
lakehouse.fact_samplesLakehouse tablefact
Total RevenueDAX measurecertified · Finance
Revenue YTDDAX measurecertified · Finance
Gross MarginDAX measurecertified · Finance
Gross Margin %DAX measurecertified · Finance
Open BacklogDAX measurecertified · Operations
Pipeline ValueDAX measurecertified · Sales
Weighted PipelineDAX measurecertified · Sales
Sample Conversion %DAX measurecertified · Sales
Draft Channel MixDAX measuredraft · Sandbox
Uncertified Discount GuessDAX measuredraft · Sandbox
Bookings vs Billings GapDAX 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
  • snow_task_mart · snow_task · succeeded · 5,182 rows
  • snow_task_mart · snow_task · succeeded_with_warnings · 5,003 rows
  • snow_task_mart · snow_task · succeeded · 4,306 rows
  • synapse_load · adf · succeeded · 10,028 rows
  • synapse_load · adf · succeeded · 6,235 rows
  • synapse_load · adf · succeeded · 6,888 rows
  • gold_ops_facts · dbx_job · succeeded · 8,512 rows
  • gold_ops_facts · dbx_job · succeeded · 7,519 rows
  • gold_ops_facts · dbx_job · succeeded · 3,959 rows
  • silver_conform · dbx_job · succeeded · 5,586 rows
  • silver_conform · dbx_job · succeeded · 6,943 rows
  • silver_conform · dbx_job · succeeded · 6,042 rows
  • bronze_normalize · dbx_job · succeeded · 7,611 rows
  • bronze_normalize · dbx_job · succeeded · 1,073 rows
  • bronze_normalize · dbx_job · succeeded · 3,977 rows
  • land_s3_raw · glue · succeeded · 1,027 rows
  • land_s3_raw · glue · succeeded_with_warnings · 2,074 rows
  • land_s3_raw · glue · succeeded · 2,196 rows

Illustrative pattern · synthetic data

How to present this

  • Shortcut vs materialize changes where the data lives, not the numbers: a shortcut reads it in place, materializing copies it into OneLake.
  • The quality checks below run against the demo tables themselves when the app loads its data.
  • Not a live Fabric workspace.

Illustrative pattern · synthetic data

What the AI insight is told about this platform

Platform lens: Fabric OneLake path. Emphasize trust, curation, and semantic readiness—not urban intelligence demos.

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