Medicare Provider Outliers
Provider cost and volume outlier detection across 43.7M rows of public CMS Medicare data — modeled as a dbt star schema on Snowflake, scored within 9,490 specialty-by-state peer groups, and published as a live interactive data app.
An independent build of the full analytics path: three CMS sources (Part D prescribers, Part B physician services, the NPPES registry — calendar year 2023) loaded to Snowflake, an 11-model dbt star schema with 48 passing tests and ~982 lines of schema documentation, robust MAD + classical z-score detection with peer-group floors, and two public credential-free surfaces — an Evidence data app and the dbt docs lineage site.
