# Northwind Sales PivotTable

Data warehouse analysis — revenue by country, category & quarter

Data Warehouse — powered by DuckDB, the “SQLite for analytics”. Server-side embedded OLAP database (single file, zero setup). Aggregation runs on the server, only results sent to the browser. Sweet spot: up to 1–10 million rows. Handles 10–100M rows with tuning. For even larger data warehouses, ClickHouse scales to billions of rows. Read more →