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

Platform demo · AWS analytics

Lake consumption: S3/Glue inventory and the engine that reads it

Browse catalog objects and lake landings, then toggle Athena vs Redshift-style consumption to see how BI reaches the same curated facts.

How this maps to AWS

AWS data analytics consulting for mid-market teams.

  • Catalog inventory with bytes estimates
  • Glue/land pipeline stages
  • Athena vs Redshift consumption paths
  • Synthetic data; not a live AWS 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.

AWS lake → consumption

Landing inventory, catalog objects, and which engine reads them.

Illustrative pattern · synthetic data

Stack

  1. ERP / CRM
  2. S3 landing
  3. Glue Data Catalog
  4. Athena / Redshift
  5. BI tool

Illustrative pattern · synthetic data

Catalog objects

7

Illustrative pattern · synthetic data

Est. bytes

21,175,000

Illustrative pattern · synthetic data

Landing stages

12

Illustrative pattern · synthetic data

Illustrative pattern · synthetic data

Estimated size by catalog object (bytes)

Illustrative pattern · synthetic data

KPI recipe: gross margin % Athena SQL

SELECT d.year_month,
       CAST(SUM(f.gross_margin) AS DOUBLE)
         / NULLIF(SUM(f.revenue), 0) AS gross_margin_pct
FROM demo_lake.fact_invoices f
JOIN demo_lake.dim_date d ON d.date_key = f.date_key
GROUP BY d.year_month;

Illustrative pattern · synthetic data

Semantic objects

ObjectTypeNotes
demo_lake.bridge_crm_erp_keysGlue catalog tablebridge
demo_lake.dim_channelGlue catalog tabledimension
demo_lake.dim_customerGlue catalog tabledimension
demo_lake.dim_dateGlue catalog tabledimension
demo_lake.dim_productGlue catalog tabledimension
demo_lake.dim_regionGlue catalog tabledimension
demo_lake.dim_sales_repGlue catalog tabledimension
demo_lake.fact_inventory_backlogGlue catalog tablefact
demo_lake.fact_invoicesGlue catalog tablefact
demo_lake.fact_opportunitiesGlue catalog tablefact
demo_lake.fact_opportunity_stage_histGlue catalog tablefact
demo_lake.fact_sales_ordersGlue catalog tablefact
demo_lake.fact_samplesGlue catalog tablefact
Total RevenueAthena view metriccertified · Finance
Revenue YTDAthena view metriccertified · Finance
Gross MarginAthena view metriccertified · Finance
Gross Margin %Athena view metriccertified · Finance
Open BacklogAthena view metriccertified · Operations
Pipeline ValueAthena view metriccertified · Sales
Weighted PipelineAthena view metriccertified · Sales
Sample Conversion %Athena view metriccertified · Sales
Draft Channel MixAthena view metricdraft · Sandbox
Uncertified Discount GuessAthena view metricdraft · Sandbox
Bookings vs Billings GapAthena view 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
  • 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

Details

  • fact_invoices 3,960,000 B — redshift · KEY(customer_key)
  • fact_sales_orders 2,240,000 B — redshift · KEY(customer_key)
  • fact_opportunities 630,000 B — snowflake · CLUSTER BY (created_date_key)
  • dim_customer 45,000 B — snowflake · AUTO
  • gold_ops_mart 4,840,000 B — synapse · HASH(customer_key)
  • ext_s3_invoice_landing 7,040,000 B — redshift · EVEN
  • vw_secure_revenue 2,420,000 B — snowflake · SECURE VIEW

Illustrative pattern · synthetic data

How to present this

  • Toggle Athena vs Redshift to see which engine reads the curated tables; no cost figures are modelled.
  • Glue/land stages illustrate lake inventory before BI consumption.
  • Not a live AWS account.

Illustrative pattern · synthetic data

What the AI insight is told about this platform

Platform lens: AWS lake consumption. Emphasize trusted BI consumption of lake/warehouse data.

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