Decades of records, none of them searchable
What was in the way?
Years of inspection reports, compliance files, contracts and spreadsheets sat scattered and unsearchable. Staff spent hours each week digging through archives to answer routine questions, and knowledge left when people did.
We built an Agentic RAG application. Staff upload records; the system embeds them for semantic search and pairs a structured database alongside the vector store, so numeric data keeps its meaning and trends are answered from real figures, not guesses.
What was in the way
Scattered records - inspection reports, compliance files, contracts and spreadsheets, none of it searchable
Hours lost weekly - staff digging through archives to answer routine questions
Knowledge walked out - what people knew left when they did
What we built
Agentic RAG - staff upload records, the system embeds them for semantic search
A structured database alongside the vector store - numeric data keeps its meaning
Trends answered from real figures, not guesses

