ANALYTICS + GROUNDED Q&A

Shelf: Community Library Dashboard

A unified dashboard for a small community library, with catalog, borrowing, and member-request data feeding both analytics cards and a citation-backed assistant.

Back to Projects View Repository

Build Shape

Integrated Records

Imports sample catalog, borrowing activity, and member-request data into SQLite with explicit source tables.

Analytics Surface

Computes active titles, overdue rates, request backlog, and availability gaps for a compact operational view.

Grounded Assistant

Answers questions by querying the records first, then returns cited evidence for every natural-language response.

Repo Hygiene

Includes sample data only, a runnable setup, tests, and a short design-decisions section in the README.

Engineering Focus

Multi-source integration. Keep each imported record traceable instead of flattening away provenance.

Analytics from real tables. Cards and charts are computed from the same data layer the assistant uses.

No uncited answers. The model can summarize retrieved facts, but it cannot answer without cited records.