Pharma Commercial Analytics Path · Mission 13 of 25Hard

Copay distribution per product — NTILE(4) quartiles

NTILE(4) OVER (PARTITION BY product ORDER BY copay) — partitioned window quartiles. Pharma market-access teams band Rx fills by patient out-of-pocket cost to size formulary friction; a brand with most fills in the high-copay quartile faces a coverage problem (patients pay more, abandonment risk rises).

The Brief

You'll practice

NTILE(4) windowPARTITION BY productQuartile bucketing