This video brings the concepts talked about in previous videos and the Weekend Work playlist together. What is a Kimble or Star Schema and how is it put together. We look at how it helps to standardise your data, you will need to massage manual entry during the normalisation stage to correct typos and other inconsistencies, but once your data is consistent then the magic starts to happen.
FACT Table – Record of events
DIMENSION Table – Descriptions to support your facts.
For those of you from an Excel background think of a pivot table, Dimensions are the row or column headers while the aggregated values in the middle are facts. Simplistic, but a great way to remember it!