Querying Data Warehouses - Data Warehouse Systems: Design and Implementation - page 225

customer region store

customer_id
account_num
lname
fname
mi
address1
address2
address3
address4
city
state_province
postal_code
country
customer_region_id
phone1
phone2
birthdate
marital_status
yearly_income
gender
total_children
num_children_at_home
education
date_accnt_opened
member_card
occupation
houseowner
num_cars_owned

region_id
sales_city
sales_state_province
sales_district
sales_region
sales_country
sales_district_id

store_id
store_type
region_id
store_name
store_number
store_street_address
store_city
store_state
store_postal_code
store_country
store_manager
store_phone
store_fax
first_opened_date
last_remodel_date
lease_sqft
store_sqft
grocery_sqft
frozen_sqft
meat_sqft
coffee_bar
video_store
salad_bar
prepared_food
florist

promotion

promotion_id
promotion_district_id
promotion_name
media_type
cost
start_date
end_date

sales_fact

product_id
time_id
customer_id
promotion_id
store_id
store_sales
store_cost
unit_sales

product

product_id
product_class_id
brand_name
product_name
SKU
SRP
gross_weight
net_weight
recyclable_package
low_fat
units_per_case
cases_per_pallet
shelf_width
shelf_height
shelf_depth

time_by_day

product_class

time_id
the_date
the_day
the_month
the_year
day_of_month
week_of_year
month_of_year
quarter
fiscal_period

product_class_id
product_subcategory
product_category
product_department
product_family

Fig. 6.4 Relational schema of the Foodmart data warehouse

cover DAX, in particular since, at the time of writing, it is mostly supported
by Microsoft tools. A topic entirely devoted to the BISM tabular model and
DAX is [ 183 ], although these topics are also covered in the topic [ 79 ]already
cited above.