Clinical Operations Analytics Path · Mission 23 of 25Master

CCSR service-line rollup

Roll a clinical fact table up to the AHRQ CCSR grouper, the standard service-line vocabulary used at every US health system. Practice multi-aggregate queries with computed percentages and float-promotion gotchas.

The Brief

You'll practice

CCSR rollupAVG LOS% calc + float promotion