Blog
In-depth guides, tutorials, and best practices for database design, data architecture, and healthcare data modeling.
Platform comparisons, TCO analysis, and governance frameworks — written for the people who approve the budget.
A practical comparison of erwin Data Modeler against free alternatives — when erwin is worth the cost, when dbdiagram.io and dbt are enough, and how to choose for healthcare data teams.
Showing 1–6 of 81 posts
A practical guide to modeling healthcare claims data using erwin Data Modeler — logical entity design, physical DDL generation, ISO-11179 naming conventions, and exporting to Snowflake and SQL Server.
Paste any healthcare SQL schema and instantly generate a complete data dictionary, business glossary, HIPAA PHI classification, dbt YAML, and data governance report — powered by 100,000+ healthcare term definitions.
The complete guide to healthcare revenue cycle data for data architects and engineers. Covers claims adjudication, denial management, charge capture, accounts receivable, prior authorization, and production-ready revenue cycle data model design for Snowflake, Databricks, and BigQuery.
The complete guide to healthcare provider data management for data architects and engineers. Covers NPI numbers, provider credentialing, network participation, taxonomy codes, and production-ready provider master data model design for Snowflake, Databricks, and BigQuery.
The complete guide to member enrollment data for health plan data architects and engineers. Covers member eligibility, enrollment spans, demographics, cost-sharing, risk adjustment, and HEDIS quality measures — with a production-ready Star Schema for Snowflake, Databricks, and BigQuery.
Get the latest healthcare data architecture articles delivered to your inbox.