From scattered PDF reports to sector benchmarks.
An internal tool that reads diagnostic reports in PDF, extracts structured data with an LLM and rolls it up into benchmarks by sector, company and unit.
Diagnostic reports accumulated in a corporate drive as PDFs. The data was there, but comparing one company with its sector meant opening files one by one.
- A pipeline that picks up diagnostic reports from the corporate drive as they are added.
- An LLM extraction step that reads both text and images and returns structured data.
- A hierarchy of sector, company and unit that every extracted record is attached to.
- Benchmark dashboards and reports that compare a unit with its company and its sector.
03 — Engineering highlights
Text and vision extraction
Charts and tables are read as images as well as text, so data locked in figures is not lost.
Corporate drive integration
Reports are read through the drive's official API, with no manual exports or copies.
Retrieval service
A separate service keeps the extracted content searchable across every report.
Isolation in the database
Row-level security in the database controls who can see which records.
Reports that used to sit in folders now feed comparable data. A unit can be read against its company and its sector without opening a single PDF.