Data modeling interview filters so many data engineers! How to model slowly-changing dimensions

[SnazzyKicks]

This is great and to the point. But pls add more to this topic .. some challenges/real time examples. Would be of great help to lot of people in the DE community @Zach

[InsightsofAJ]

Great one. I would say that leaning normalization is a good start.

[jonskaggs]

I’ve always wanted to model data, but I’ve never had the right dimensions for it. 🤓

[denist]

Hi Zach, thanks for sharing your thoughts. I just wanted to see if there was a mistyped last name in your CC (0:16) -- "... go read the Kimball book, some people say, go read the Eman book ..." Should this be -- "... go read the Kimball book, some people say, go read the Inmon book ..." (Bill Inmon)

[wtfzalgo]

I like the metaphorical explanation. Why don't you write your own platform agnostic data modeling book?

[Paul-yqym]

Opposite for me. Have done OLTP and OLAP data modeling for years, but can't get past the deep questions on latest tools of the day, PySpark, Azure Data Factory, etc.

[maleldil]

Why have the end date be in the future instead of just null?

[srinubathina]

I want to learn data modeling from you do you offer any course to do that because I want to learn in depth
knowledge on this concept

[patparillo]

I know you mentioned learning by doing which is my preferred approach as well however do you have any resources on learning about scd type 1, type 2 etc?

[workmode]

What about modeling in MPPs like Redshift? Traditional dimensions/facts does not match the archi of MPPs