Rose City Clinics Analytics Intelligence
This is a working example of AI-powered analytics — a large language model connected to organized, structured healthcare data. Ask any question in plain English. The AI writes the query, runs it against the real data, and returns an answer in seconds.
Dataset Overview
· 287 providers across 53 clinic locations
· 52,000 patients · 31 specialties · 22 service lines
· 249,925 encounters and 287,000 appointments (2022–2024)
· 38,789 referrals with network leakage tracking
· Financial data: claims, denials, and accounts receivable
Browse suggested questions on the left, or type your own below.
Referral Leakage
Revenue at risk, external patterns
Scheduling & Access
Wait times, no-shows, access
Encounters & Productivity
wRVU, encounters, providers
Revenue & Denials
Collections, denials, AR aging