A multi-page clinical analytics dashboard simulating EHR operational metrics: 500 patients, 12 providers, 2,000 visits across 6 departments. Tracks wait times, no-show rates, top diagnoses, top medications, and department-level visit volume — the kind of data hospital operations leaders actually look at every day.
Real EHR analyst tools are server-rendered for performance and accessibility. Thymeleaf + Spring keeps the codebase tight and renders the dashboard in under 100ms even with thousands of rows — no client-side hydration cost.
Wait time, no-show rate, and visits-per-day are calculated with native GROUP BY queries against H2 (in PostgreSQL mode). The same SQL would run unchanged against a real Postgres or Oracle EHR data warehouse — which is what hospitals actually use.
With open-in-view: false, lazy associations would throw exceptions during Thymeleaf rendering. Custom findAllWithRefs queries eagerly fetch Patient + Provider in one round-trip, eliminating N+1 queries on the visit log.
open-in-view: false, JOIN FETCH for eager loading, transaction boundaries