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.

Identify the Dimension and Fact in the following designs.

Student Example

FirstName	LastName	DOB	Ht	Wt	Gender	Course	Grade
Ross	Geller	1967-10-18	72	170	Male	Paleontology	A
Rachel	Green	1969-05-05	65	125	Female	Fashion Design	B+
Monica	Geller	1964-04-22	66	130	Female	Culinary Arts	A
Chandler	Bing	1968-04-08	73	180	Male	Advertising	B
Joey	Tribbiani	1968-01-09	71	185	Male	Acting	C+

CAR Sales Example

Manufacturer	Model	Sales_in_thousands	Vehicle_type	Price_in_thousands	Engine_size	Horsepower	Wheelbase	Width	Length	Curb_weight	Fuel_capacity	Fuel_efficiency	Latest_Launch	Power_perf_factor
Acura	Integra	16.919	Passenger	21.5	1.8	140	101.2	67.3	172.4	2.639	13.2	28	2/2/2012	58.28
Acura	TL	39.384	Passenger	28.4	3.2	225	108.1	70.3	192.9	3.517	17.2	25	6/3/2011	91.371
Acura	CL	14.114	Passenger	[NULL]	3.2	225	106.9	70.6	192	3.47	17.2	26	1/4/2012	[NULL]
Acura	RL	8.588	Passenger	42	3.5	210	114.6	71.4	196.6	3.85	18	22	3/10/2011	91.39
Audi	A4	20.397	Passenger	23.99	1.8	150	102.6	68.2	178	2.998	16.4	27	10/8/2011	62.778
Audi	A6	18.78	Passenger	33.95	2.8	200	108.7	76.1	192	3.561	18.5	22	8/9/2011	84.565
Audi	A8	1.38	Passenger	62	4.2	310	113	74	198.2	3.902	23.7	21	2/27/2012	134.657
BMW	323i	19.747	Passenger	26.99	2.5	170	107.3	68.4	176	3.179	16.6	26	6/28/2011	71.191

Advance Data Warehousing

More Examples