Skip to content

Data Model

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)

Clone this wiki locally