— blog
Dimensional-modeling
Let's explore the source of my reflections — on data, AI, and everything that sits between a raw dataset and a good decision — turn complexity into clarity, and share it all in the most naive way.
- Aug 89 min
Dimensional Modeling - Part 2: Basic Dimension Table Techniques
Data WarehouseDatabaseData EngineeringData ModelingDimensional ModelingThe topics covered include Degenerate Dimension, Conformed Dimension, Role-Playing Dimension, Junk Dimension, Outrigger Dimension, and Slowly Changing Dimensions (SCD). The SCD category further delves into different types, such as Type 0 to Type 7, each with its unique approach to handling historical and changing data.
- Apr 213 min
Dimensional Modeling - Part 1: Basic Fact Table Techniques
Data WarehouseDatabaseData EngineeringData ModelingDimensional ModelingIn this article, I will introduce the concept of the Basic Fact table in Dimensional data modeling. To understand this technique, we will explore the different types of data modeling and recap some fundamental knowledge, including the star and snowflake schemas, and the concepts of normalization.