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

Platform demo · Tableau consumption

Viz playground: parameters, marks, and LOD framing

Same operational facts with Tableau-style controls—mark type, color dimension, and FIXED vs INCLUDE explanations on extract-ready dimensions.

How this maps to Tableau

Tableau consulting: trusted extracts, modeling, and leadership dashboards.

  • Parameter controls for mark type and color dim
  • Conformed customer/product dimensions
  • LOD-style FIXED vs INCLUDE coaching copy
  • Honest disclosure: synthetic facts; not a live Tableau Cloud tenant
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.

Tableau viz playground

Parameter-style controls over conformed dimensions — extract-ready facts.

Illustrative pattern · synthetic data

Stack

  1. Warehouse tables
  2. Published data source
  3. Extract
  4. Calculated fields / LOD
  5. Workbooks

Illustrative pattern · synthetic data

Customer types

5

Illustrative pattern · synthetic data

Categories

5

Illustrative pattern · synthetic data

Illustrative pattern · synthetic data

Revenue by customer type

Illustrative pattern · synthetic data

Revenue by category

Illustrative pattern · synthetic data

KPI recipe: gross margin % Tableau calculation

// Gross Margin %
SUM([gross_margin]) / SUM([revenue])

// Per-customer margin, independent of the view's level of detail
{ FIXED [customer_key] : SUM([gross_margin]) / SUM([revenue]) }

Illustrative pattern · synthetic data

Semantic objects

ObjectTypeNotes
bridge_crm_erp_keysData source tablebridge
dim_channelData source tabledimension
dim_customerData source tabledimension
dim_dateData source tabledimension
dim_productData source tabledimension
dim_regionData source tabledimension
dim_sales_repData source tabledimension
fact_inventory_backlogData source tablefact
fact_invoicesData source tablefact
fact_opportunitiesData source tablefact
fact_opportunity_stage_histData source tablefact
fact_sales_ordersData source tablefact
fact_samplesData source tablefact
Total RevenueCalculated fieldcertified · Finance
Revenue YTDCalculated fieldcertified · Finance
Gross MarginCalculated fieldcertified · Finance
Gross Margin %Calculated fieldcertified · Finance
Open BacklogCalculated fieldcertified · Operations
Pipeline ValueCalculated fieldcertified · Sales
Weighted PipelineCalculated fieldcertified · Sales
Sample Conversion %Calculated fieldcertified · Sales
Draft Channel MixCalculated fielddraft · Sandbox
Uncertified Discount GuessCalculated fielddraft · Sandbox
Bookings vs Billings GapCalculated fielddraft · 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

Details

  • Color dimension Parameter — customer_type | category | region
  • Mark type Parameter — circle | square | bar
  • LOD style Explain — FIXED customer vs INCLUDE type

Illustrative pattern · synthetic data

How to present this

  • Change mark type / color dim in the controls — charts re-encode without leaving the demo.
  • LOD note: FIXED answers ‘per customer’; INCLUDE answers ‘within the viz level’.
  • Not a live Tableau Cloud workbook — consumption pattern only.

Illustrative pattern · synthetic data

What the AI insight is told about this platform

Platform lens: Tableau viz playground. Emphasize parameters, clean dims, and exploratory encoding.

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