Retail Transactions SQL Explorer

Browser-based SQL explorer built from an ERP-style retail transactions dataset. Includes KPI views plus a working-layer table that mirrors the Excel driver columns used in the case study.

Open Explorer

Checks Monthly KPIs Channel KPIs Status Distribution

Working + raw

Working Transactions (KPI drivers) Transactions (raw)

Examples

SQL examples (SQL_DEMO.md)

SQL editor

Use the database home to open the query editor and run the examples from SQL_DEMO.md.

Open SQL editor

Notes: Read-only environment. KPI logic is defined in working_transactions and rolled up into the KPI views.

Open this over HTTP, not as a local file.

Datasette Lite cannot fetch file:// resources from your local filesystem. Start a simple web server in this folder, then open the local URL.

Use python3 serve_demo.py and then visit http://127.0.0.1:8000. The helper server adds the CORS headers that Datasette Lite needs.