A simplified OLAP pivot table — Country × Year → Net Revenue — over the DuckDB Northwind data warehouse.
The Northwind data warehouse has a view called vw_sales_detail with ~8,000 sales records spanning 21 countries across 3 years (2013–2015). We'll create an interactive pivot table that summarizes net revenue by country and year.
| Existing Sample (complex) | Our Version (simplified) | |
|---|---|---|
| Rows | customer_country, category_name | customer_country |
| Columns | year_quarter | year |
| Values | net_revenue | net_revenue |
| Data Source | DuckDB — vw_sales_detail | DuckDB — vw_sales_detail |
Same data warehouse, same view — just fewer dimensions so we can focus on learning the configuration steps.
1 Create the report — new report entry + enable the Report Generation capability
2 Configure the data source — connect to DuckDB, set output type to None
3 Configure the pivot table — define rows, columns, values, and the DuckDB view