Clinical Operations Analytics Path · Mission 22 of 25Master

The comorbidity profile — what travels with heart failure

Practice the cohort-then-comorbidity pattern: first identify a patient population by their principal diagnosis, then aggregate the secondary diagnoses on those same encounters. This is the core HCC-recapture / risk-adjustment query run quarterly at every ACO and Medicare Advantage plan.

The Brief

You'll practice

Cohort CTESubquery INTwo-pass aggregation