Clinical Trials & Research Analytics Path · Mission 23 of 25Master

Adverse-event temporal cluster detection

Self-join on a fact table with a date-window predicate. Practice the 'find groups of N events within a time window' pattern that powers fraud-velocity rules, sepsis-bundle alerts, and cluster detection across nearly every operational domain.

The Brief

You'll practice

Self-join with rn directionalityDate-window predicateHAVING aggregate filter