More Examples

Dimension columns typically contain descriptive attributes that provide context or categorization to the data, while fact columns contain measurable, numerical data that can be analyzed or aggregated.

Student Example

FirstName LastName DOB Ht Wt Gender Course Grade

Identify the Dimension and Fact in the above design.

CAR Sales Example