Data Model

Jump to bottom

Yomi Ogunyinka edited this page Jul 6, 2021 · 2 revisions

Data Model - retail_dw

Fact - fact_product_revenue_dly
- date_id
- product_id
- product_revenue
- outstanding_revenue
- total_order_cnt
- revenue_order_cnt
- cancelled_order_cnt
- outstanding_order_cnt
- batch_id (referring to control table
- batch_date
Dimension - dim_product(type 1 dimension)
- product_id(primary key)
- product_name
- product_price
- category_name
- department_id
- department_name
- batch_id
- batch_date
Dimension - dim_customer(all fields)