Chapter 2 of Adamson's Star Schema covers this well. Both authors are pragmatic and allowed flexibility in their approaches. Lots of misconceptions in this space.

Reading this now. #databs

Finished these two. Really enjoyed Star Schema. Data Modeling Storytelling has some good advice too #bsdata

In data warehousing, edit, publish, but don't manufacture. #databs

Thanks for uploading so much material. Learning a ton. @eczachly.bsky.social