OLAP Sales Cube

500K-row retail star schema, built by DuckDB in GitHub Actions and queried in your browser with DuckDB-WASM. No servers.

Loading DuckDB-WASM…

Pivot / slice & dice

Click an underlined row label to drill down (Year → Quarter → Month, Region → Country → Store, Category → Brand → Product). Remove a filter chip to roll up.

Result

Chart

Generated SQL


  

SQL console

Tables: fact_sales, dim_date, dim_store, dim_product, agg_sales_cube and the denormalized sales.