Clinical Operations Analytics Path · Mission 18 of 25Expert

Department CCSR concentration (HHI)

Multi-CTE pipeline ending in a Herfindahl-Hirschman Index (HHI) computation — sum of squared shares per department. Quantifies how 'specialized' each department's case mix is. Industrial-strength per-group ratio aggregation.

The Brief

You'll practice

Multi-CTE pipelineSUM(share*share) HHIFloat promotion