The request
“A healthcare claims star schema with Claims linked to Patient, Provider, Date, Diagnosis, and Procedure dimensions, storing claim and approved amounts.”
Then tryAdd an insurance plan dimensionAdd a claim status to Claims
What is in this drawing
Read the decisions behind it.
01
Surrogate keys for dimensions
02
Claim grain as individual claim line
03
Separate date dimension for time analysis
When building a healthcare claims data mart for OLAP queries.
More like this