Healthcare claims snowflake schema

This healthcare claims snowflake schema places billed and paid amounts in FactClaim. The claim references date, patient, provider and diagnosis dimensions. Provider details roll through specialty to department, while diagnosis codes roll through disease group. The normalized structures prevent the same specialty, department or disease group text from being repeated on every dimensional row. Analysts can aggregate claims by date, clinical department, specialty or disease group while retaining a clear relationship back to the individual claim. This is useful where reporting hierarchies are governed separately from transaction data. It can also make changes to clinical groupings visible and reusable across reports.