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

Platform demo · Amazon Redshift

Warehouse design: dist/sort keys and Spectrum notes

Walk dist/sort recommendations on synthetic warehouse objects, WLM queue metaphor, and Spectrum external toggles that finance can actually consume.

How this maps to Amazon Redshift

Amazon Redshift consulting and warehouse modernization.

  • Dist/sort key cards on fact tables
  • WLM queue metaphor for BI vs ETL
  • Spectrum external object toggle
  • Synthetic facts; not a live Redshift cluster
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.

Redshift warehouse design

Dist/sort recommendations and Spectrum-style external objects.

Illustrative pattern · synthetic data

Stack

  1. S3 + Spectrum
  2. Staging schema
  3. Dist/sort-keyed facts
  4. WLM queues
  5. BI tool

Illustrative pattern · synthetic data

Warehouse objects

3

Illustrative pattern · synthetic data

KEY distributed

2

Illustrative pattern · synthetic data

External / Spectrum

1

Illustrative pattern · synthetic data

Illustrative pattern · synthetic data

Estimated size by warehouse object (bytes)

Illustrative pattern · synthetic data

KPI recipe: gross margin % Redshift SQL

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

Illustrative pattern · synthetic data

Semantic objects

ObjectTypeNotes
analytics.bridge_crm_erp_keysRedshift tablebridge
analytics.dim_channelRedshift tabledimension
analytics.dim_customerRedshift tabledimension
analytics.dim_dateRedshift tabledimension
analytics.dim_productRedshift tabledimension
analytics.dim_regionRedshift tabledimension
analytics.dim_sales_repRedshift tabledimension
analytics.fact_inventory_backlogRedshift tablefact
analytics.fact_invoicesRedshift tablefact
analytics.fact_opportunitiesRedshift tablefact
analytics.fact_opportunity_stage_histRedshift tablefact
analytics.fact_sales_ordersRedshift tablefact
analytics.fact_samplesRedshift tablefact
Total RevenueView metriccertified · Finance
Revenue YTDView metriccertified · Finance
Gross MarginView metriccertified · Finance
Gross Margin %View metriccertified · Finance
Open BacklogView metriccertified · Operations
Pipeline ValueView metriccertified · Sales
Weighted PipelineView metriccertified · Sales
Sample Conversion %View metriccertified · Sales
Draft Channel MixView metricdraft · Sandbox
Uncertified Discount GuessView metricdraft · Sandbox
Bookings vs Billings GapView 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

Details

  • fact_invoices redshift — DIST KEY(customer_key) · SORT date_key,customer_key
  • fact_sales_orders redshift — DIST KEY(customer_key) · SORT order_date_key
  • ext_s3_invoice_landing redshift — DIST EVEN · SORT

Illustrative pattern · synthetic data

How to present this

  • WLM metaphor: short BI queries vs long ETL share separate queues in a healthy design.
  • Toggle Spectrum external to refresh trust notes about lake-sourced facts.
  • Not a live Redshift cluster.

Illustrative pattern · synthetic data

What the AI insight is told about this platform

Platform lens: Redshift warehouse design. Emphasize dist/sort, WLM, and metric ownership.

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