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

Platform demo · Snowflake + BI

Time travel + secure-view handoff for BI

As-of monthly revenue slider (time-travel metaphor), warehouse size vs concurrency, and secure view vs table for Tableau/Power BI consumption—on denser synthetic history.

How this maps to Snowflake

Snowflake consulting and BI integration.

  • As-of date slider reconstituting monthly KPIs
  • Warehouse size vs concurrency coaching
  • Secure view vs table BI handoff
  • Synthetic scenario; not a live Snowflake account
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.

Snowflake time travel + BI handoff

As-of monthly revenue from denser history; secure view vs table for consumption.

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

Illustrative pattern · synthetic data

Stack

  1. Stage
  2. Raw schema
  3. Modeled schema
  4. Secure views
  5. BI tool

Illustrative pattern · synthetic data

Months in series

48

Illustrative pattern · synthetic data

Latest month revenue

$1,620,669

Illustrative pattern · synthetic data

Secure views

1

Illustrative pattern · synthetic data

Illustrative pattern · synthetic data

Monthly revenue (synthetic USD)

Illustrative pattern · synthetic data

KPI recipe: gross margin % Snowflake SQL

CREATE OR REPLACE SECURE VIEW ANALYTICS.BI.GROSS_MARGIN_BY_MONTH AS
SELECT d.YEAR_MONTH,
       DIV0(SUM(f.GROSS_MARGIN), SUM(f.REVENUE)) AS GROSS_MARGIN_PCT
FROM ANALYTICS.MODELED.FACT_INVOICES f
JOIN ANALYTICS.MODELED.DIM_DATE d ON d.DATE_KEY = f.DATE_KEY
GROUP BY d.YEAR_MONTH;

Illustrative pattern · synthetic data

Semantic objects

ObjectTypeNotes
ANALYTICS.MODELED.BRIDGE_CRM_ERP_KEYSSnowflake tablebridge
ANALYTICS.MODELED.DIM_CHANNELSnowflake tabledimension
ANALYTICS.MODELED.DIM_CUSTOMERSnowflake tabledimension
ANALYTICS.MODELED.DIM_DATESnowflake tabledimension
ANALYTICS.MODELED.DIM_PRODUCTSnowflake tabledimension
ANALYTICS.MODELED.DIM_REGIONSnowflake tabledimension
ANALYTICS.MODELED.DIM_SALES_REPSnowflake tabledimension
ANALYTICS.MODELED.FACT_INVENTORY_BACKLOGSnowflake tablefact
ANALYTICS.MODELED.FACT_INVOICESSnowflake tablefact
ANALYTICS.MODELED.FACT_OPPORTUNITIESSnowflake tablefact
ANALYTICS.MODELED.FACT_OPPORTUNITY_STAGE_HISTSnowflake tablefact
ANALYTICS.MODELED.FACT_SALES_ORDERSSnowflake tablefact
ANALYTICS.MODELED.FACT_SAMPLESSnowflake tablefact
Total RevenueSecure view columncertified · Finance
Revenue YTDSecure view columncertified · Finance
Gross MarginSecure view columncertified · Finance
Gross Margin %Secure view columncertified · Finance
Open BacklogSecure view columncertified · Operations
Pipeline ValueSecure view columncertified · Sales
Weighted PipelineSecure view columncertified · Sales
Sample Conversion %Secure view columncertified · Sales
Draft Channel MixSecure view columndraft · Sandbox
Uncertified Discount GuessSecure view columndraft · Sandbox
Bookings vs Billings GapSecure view columndraft · 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_opportunities snowflake — CLUSTER BY (created_date_key)
  • dim_customer snowflake — AUTO
  • vw_secure_revenue snowflake — SECURE VIEW

Illustrative pattern · synthetic data

How to present this

  • Drag the as-of slider to reconstitute trailing revenue from the monthly series (time-travel metaphor).
  • Illustrative pattern: warehouse size trades credits for concurrency; no cost or performance figures are modelled.
  • Prefer secure views for BI handoff when row filters must stay in the warehouse.

Illustrative pattern · synthetic data

What the AI insight is told about this platform

Platform lens: Snowflake time travel + handoff. Emphasize BI-ready models and CRM/ERP reconciliation.

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