MVP Example Outputs

Top-Level Batch Summary

Screenshot 2025-10-04 at 08.55.50.png

Detailed Batch Summary

Screenshot 2025-10-04 at 09.00.20.png

‘Interactive’ Charts. User defines KPI to show

Screenshot 2025-10-04 at 09.06.59.png


Reporting Database Requirements

Component Description
✅ Gold-layer SQL Views Clean views that flatten joins (Batches + Products + Financials)
✅ Query Templates Stored SQL templates for top 50 queries
✅ Metadata/Tag Layer Field-level tagging (product, cost, date, scheme)
✅ Function Registry AI-readable functions for LLMs to use deterministically
✅ Logging Layer Traceable source for every answer (SQL, timestamp, user)
✅ Tool-based Orchestration Agent layer that picks tools, confirms logic, and runs safely