Day: March 10, 2022

Defining Problem Statements

Define Problem Statement – Daily Product Revenue¶ Let us try to get daily product revenue using retail tables. daily is derived from orders.order_date. product has to be derived from products.product_name. revenue has to be derived from order_items.order_item_subtotal. We need to join all the 3 tables, then group by order_date, product_id as well as product_name to …

Defining Problem Statements Read More »

Overview of Data Model

Overview of Data Model¶ We will be using retail data model for this section. It contains 6 tables. Table list orders order_items products categories departments customers orders and order_items are transactional tables. products, categories and departments are non transactional tables which have data related to product catalog. customers is a non transactional table which have …

Overview of Data Model Read More »