Data Modeling Fundamentals: Star Schema, Snowflake Schema, and Normalization

<p>Follow analytics engineer Kirsten Vale through her first months at Loomcraft Furniture Co. as she navigates the tension between OLTP normalization and analytical reporting &mdash; designing a star schema, snowflaking a growing product hierarchy, and solving a costly historical-reporting bug with slowly changing dimensions.</p>

Tools: PostgreSQL, Star Schema, Snowflake Schema, Data Normalization, Slowly Changing Dimensions