Database Reference
In-Depth Information
Family
Country
Customer
Family Name
Country Name
Customer ID
First Name
Middle Initial
Last Name
Birth Date
Gender
Education
Marital Status
Member Card
Yearly Income
Occupation
Total Children
Nb Children Home
House Owner
Nb Cars Owned
Department
State
Department Name
State Name
Category
City
Category Name
City Name
Subcategory
Geography
Subcategory Name
Store
Store ID
Store Name
Store Type
Store Manager
Store Sqft
Grocery Sqft
Frozen Sqft
Meat Sqft
Coffe Bar
Class
Product
Year
Product ID
Product Name
SKU
SRP
Year No
Quarter
Brand
Quarter Name
Brand
Month
Brand Name
Sales
Month No
Month Name
Store Sales
Store Cost
Unit Sales
/Sales Average
/Profit
Promotion
Promotion Name
Calendar
Media
Time
Date
Day Name Week
Day Nb Month
Week Nb Year
Promotion Media
Media Type
Fig. 4.23
Conceptual schema of the Foodmart cube
(m) Unit sales by promotion and store, for stores in the states of
California and Washington.
(n) Sales profit by month and sales profit growth with respect to the
previous month.
(o) Sales profit by month and sales profit growth with respect to the
same month of the previous year.
Search WWH ::
Custom Search