INTERACTIVE DATA ENGINEERING DEMO
Sales Analytics Data Lab
Explore KPIs, trends, SQL and ETL concepts through a responsive analytics dashboard. Built with synthetic sample orders, not real customer data.
Demo data · 500 synthetic sales orders · 2024–2026 · CSV-powered dashboard · PostgreSQL schema and Python ETL included in the source files. Not a live database connection.
Loading sample data…
Monthly revenue
SEKRevenue by category
SEKSample order records
First 12 filtered orders. Data is generated for demonstration.
| Order | Date | Region | Category | Units | Revenue (SEK) |
|---|
Behind the dashboard
CSV→Python + Pandas→PostgreSQL→Analytics
The included ETL script validates and transforms the same sample records and can load them into PostgreSQL. This page currently loads the CSV directly.
SQL example
SELECT region,
ROUND(SUM(revenue_sek), 2) AS revenue
FROM sales_orders
GROUP BY region
ORDER BY revenue DESC;