Net sales
—After synthetic discountsSales workspace
Sales performance overview
Loading the synthetic CSV data…
Sales transactions
—One row per product saleUnits sold
—Selected populationAverage transaction
—Net sales per CSV rowTrend
Monthly net sales
Monthly net sales as a table
| Month | Net sales (CAD) |
|---|
Mix
Top product categories
Concentration
Top customers
Drill-down
Sales transaction explorer
Each row represents one product sale from the consolidated synthetic transaction CSV.
| Transaction | Sale date | Customer | Salesperson | Product | Category | Qty | Net sales |
|---|
What this demonstrates
Start with familiar CSV files and explore what AI can build
One consolidated sales file
The transaction CSV contains sales of familiar food products, including sale date, customer, salesperson, product, quantity, price, discount, and net sales in one flat table.
Four small reference files
Customers, salespeople, products, and product categories give business-friendly names and groupings for analysis.
Validated relationships
Every transaction key resolves to the matching reference CSV, and dashboard totals reconcile to the consolidated sales file.
Portable dashboard
The website is generated from the CSV collection. It has no SQLite database, source-system credential, or live ERP connection.
Practical pathway
An exported sales file can be a safe starting point
For a real organization, the synthetic transactions could be replaced by an approved, minimized, read-only ERP export. Definitions, privacy, refresh, reconciliation, retention, and access still require explicit ownership and validation.