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

Platform demo · Databricks lakehouse

Medallion navigator: bronze → silver → gold → semantic

Explore medallion row counts, quality gates, and job stages that land in a semantic model Power BI can trust. Synthetic manufacturer/distributor facts only.

How this maps to Databricks

Databricks consulting with BI handoff (certified practitioner delivery).

  • Bronze/silver/gold row counts with certified gold flags
  • Databricks job stages from pipeline runs
  • Gold → semantic contract panel
  • Credential claim is separate; this demo is synthetic data
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.

Databricks medallion navigator

Bronze → silver → gold row counts, quality gates, and job stages.

Databricks-certified practitioner delivery; certification is practitioner credentialing — no vendor partnership or endorsement is claimed.

Illustrative pattern · synthetic data

Stack

  1. Bronze Delta
  2. Silver Delta
  3. Gold Delta
  4. Unity Catalog
  5. BI semantic model

Illustrative pattern · synthetic data

Bronze rows

75,792

Illustrative pattern · synthetic data

Silver rows

58,542

Illustrative pattern · synthetic data

Gold rows

52,271

Illustrative pattern · synthetic data

Gold tables are the BI contract after Spark jobs. Certified flags are synthetic.

Illustrative pattern · synthetic data

Rows by medallion layer

Illustrative pattern · synthetic data

Rows per gold table

Illustrative pattern · synthetic data

KPI recipe: gross margin % Databricks SQL

SELECT d.year_month,
       try_divide(SUM(f.gross_margin), SUM(f.revenue)) AS gross_margin_pct
FROM demo.gold.fact_invoices f
JOIN demo.gold.dim_date d ON d.date_key = f.date_key
GROUP BY d.year_month;

Illustrative pattern · synthetic data

Semantic objects

ObjectTypeNotes
demo.gold.bridge_crm_erp_keysUnity Catalog tablebridge
demo.gold.dim_channelUnity Catalog tabledimension
demo.gold.dim_customerUnity Catalog tabledimension
demo.gold.dim_dateUnity Catalog tabledimension
demo.gold.dim_productUnity Catalog tabledimension
demo.gold.dim_regionUnity Catalog tabledimension
demo.gold.dim_sales_repUnity Catalog tabledimension
demo.gold.fact_inventory_backlogUnity Catalog tablefact
demo.gold.fact_invoicesUnity Catalog tablefact
demo.gold.fact_opportunitiesUnity Catalog tablefact
demo.gold.fact_opportunity_stage_histUnity Catalog tablefact
demo.gold.fact_sales_ordersUnity Catalog tablefact
demo.gold.fact_samplesUnity Catalog tablefact
Total RevenueGold-layer metriccertified · Finance
Revenue YTDGold-layer metriccertified · Finance
Gross MarginGold-layer metriccertified · Finance
Gross Margin %Gold-layer metriccertified · Finance
Open BacklogGold-layer metriccertified · Operations
Pipeline ValueGold-layer metriccertified · Sales
Weighted PipelineGold-layer metriccertified · Sales
Sample Conversion %Gold-layer metriccertified · Sales
Draft Channel MixGold-layer metricdraft · Sandbox
Uncertified Discount GuessGold-layer metricdraft · Sandbox
Bookings vs Billings GapGold-layer metricdraft · 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

  • 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

Illustrative pattern · synthetic data

Details

  • fact_invoices certified — gold · updated 20261231
  • fact_sales_orders certified — gold · updated 20261231
  • fact_opportunities certified — gold · updated 20261231
  • fact_samples certified — gold · updated 20261231
  • fact_inventory_backlog certified — gold · updated 20261231
  • dim_customer certified — gold · updated 20261231
  • dim_product certified — gold · updated 20261231

Illustrative pattern · synthetic data

How to present this

  • Gold tables are the BI contract after Spark jobs — semantic measures bind here.
  • Unity Catalog–style certified flags are synthetic for the walkthrough.
  • Job stages come from the synthetic pipeline run table.

Illustrative pattern · synthetic data

What the AI insight is told about this platform

Platform lens: Databricks medallion. Emphasize lakehouse habits and semantic readiness. Delivery is by a Databricks-certified practitioner; certification is practitioner credentialing, so never claim a vendor partnership or endorsement.

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