Visits and enrolment, 24 months
Oct 2024 – Sep 2026 · selected period shaded
Visits completedVisits plannedNew participants consented
What this board answers
Three questions the ACI data team asks every Monday
The cohort pathway — new participants in the selected period
Referral → consent → Epic visit → REDCap form → biospecimen → analysis dataset. Thin branches are where participants leak out.
By study
Illustrative study names — not attributed to any investigator
Ask the data
Natural-language layer over the same model
Private model on an OMRF server · PHI never leaves
Which lupus cohort visits are missing REDCap forms this quarter?
Sources & lineage
Nightly refresh, all on-premises · illustrative
Sources
Epic scheduled export (visits, encounters)
REDCap API (eCRFs, consent, biospecimen log)
Excel trackers (effort, freezer inventory)
→
Staging & model
MS-SQL staging + de-identification step
Star schema: Participant · Visit · Form · Specimen · Effort
Row-level security by study
→
Delivery
Power BI report (this board)
Ask the data — private model, same semantic layer
Runs inside OMRF's network; PHI never leaves
1 Published context from omrf.org: "6,000 patient visits last year" across OMRF's multiple sclerosis and rheumatology centers; "50+ active clinical trials"; 1 of 7 NIH Autoimmunity Centers of Excellence; ~60 labs; 15+ years as a Native American Research Center of Health. The research-visit, enrolment, form, specimen and effort figures on this page are illustrative demonstration data generated for this board — de-identified, internally consistent, and not OMRF's actual results. Study names are generic and not attributed to any investigator.
