Please enable JavaScript.
Coggle requires JavaScript to display documents.
Dimensional Modelling (Slowly Changing Dimensions (SCD) (Type 2 - New…
Dimensional Modelling
-
Dimension
-
// Customer // Products // Store // Time
// Sale at store // conversion // clickthrough // checkin // refund
-
Data Marts
Different views of company data, consolidated into more query friendly formats
-
High redundancy levels, but useful
Fact
Count, Measure, Sum, Average or some other statistic to be measured and sliced and diced
-
Use
Best for reading, analysing data
-
-
Approaches
Kimball
Less traditional and less obvious, but also very useful
-
-
-
-
-
-
-