About BI cockpit v0
v0 is the quick, SQL-only version of the BI cockpit. It exists to test one idea with real users: can a referee that explains why departments report different numbers replace the usual arguments in management meetings?
- How it is built: every page is a single SQL file run by SQLPage. There is no application code and no build step.
- Data: about 6,000 leads of a made-up Swiss insurance-lead business, April to October 2026, as of 28.10.2026 18:00.
- What v0 does not have: metric definitions kept in one file, a reusable referee for any two metrics, motion between levels, a speed budget. Those are in v1.
The three numbers
| Department | Counts | By date |
|---|---|---|
| Marketing | every lead | when it arrived |
| Operations | appointments that are scheduled or held | appointment date |
| Finance | leads invoiced to a broker | invoice date |
All three are correct. They answer different questions. The referee shows the exact steps between them.