Clinical Operations Analytics Path · Mission 16 of 25Expert

Comorbidity co-occurrence matrix

Self-join fact_diagnoses to build a principal × secondary co-occurrence matrix. Combines two top-N CTEs (each filtered by dx_type) with a self-join on encounter_id. The full version of the M22 HF-only mission, generalized to the top-5-by-top-5 cross-tab.

The Brief

You'll practice

Self-join fact_diagnosesTop-N CTEsCross-tab via JOIN