Data Modeling

Data Modeling #

There are great resources out there covering the basic Data Modeling considerations. I do recommend the Book Fundamentals of Data Engineering: Plan and Build Robust Data Systems 1st Edition by Joe Reis, and Matt Housley for getting started.

However, data modeling is often approached with a rigid, almost dogmatic mindset—you’re either an Inmon or Kimball person, or you swear by Data Vault.

In reality, I believe a more pragmatic approach is necessary. No single method is universally superior. More often than not, I find myself making compromises, and the results can be quite elegant when you can introduce a normalized layer in your warehouse. That layer doesn’t need to be permanent—it can be ephemeral, serving its purpose as needed.