CMS Medicare Part D Analytics

What problem does it solve?

This Skill consolidates CMS SPUF data into a DuckDB-based medallion architecture (Bronze/Gold/ML) to deliver scalable, explainable Medicare Part D plan recommendations.

Core Features & Use Cases

• Data integration: Ingests CMS Part D data and builds Bronze, Gold, and ML layers for fast, auditable analytics.
• Geospatial & affordability modeling: Computes county-level access and affordability metrics to rank plans.
• Use Case: A policy analyst compares plans across counties to identify cost-effective coverage for insulin users.

Quick Start

Run the pipeline to migrate data, generate formulary and network metrics, compute distance proxies, and produce top recommendations for synthetic beneficiaries.