// projects / case-study · 02

CMS Medicare
claims analytics.

Spending and utilization patterns across the CMS public claims datasets — SQL transformations, partitioning strategy, and a Looker Studio dashboard built on top.

// dataset
bigquery-public-data.cms_medicare
// type
planned
Status: in development — case study lands when the project ships.
// 01 / scope

What's planned.

Goal: a clean, reproducible analytics workflow on CMS Medicare claims data — the kind that turns a public dataset into a working dashboard. Modeling questions like provider-level spend variance, regional utilization trends, and procedure-mix shifts over time.

  • Source: BigQuery public dataset bigquery-public-data.cms_medicare
  • Transformations: layered SQL views, partitioned on claim date, clustered on provider
  • Output: an embedded Looker Studio dashboard, plus a writeup of cost/perf tradeoffs
// 02 / planned stack

Stack.

BigQuery SQL Looker Studio dbt