The input table, sales_transactions, contains sales transaction data from an office supply chain store. The input table columns are:
Column Name | Description |
---|---|
orderid | Order (transaction) identifier |
orderdate | Order date |
orderqty | Quantity of product ordered |
region | Geographic region of store where order was placed |
customer_segment | Segment of customer who ordered product |
prd_category | Category of product ordered |
product | Product ordered |
orderid | orderdate | orderqty | region | customer_segment | prd_category | product |
---|---|---|---|---|---|---|
3 | 2010-10-13 00:00:00 | 6 | Nunavut | Small Business | Office Supplies | Storage & Organization |
293 | 2012-10-01 00:00:00 | 49 | Nunavut | Consumer | Office Supplies | Appliances |
293 | 2012-10-01 00:00:00 | 27 | Nunavut | Consumer | Office Supplies | Binders and Binder Accessories |
483 | 2011-07-10 00:00:00 | 30 | Nunavut | Corporate | Technology | Telephones and Communication |
515 | 2010-08-28 00:00:00 | 19 | Nunavut | Consumer | Office Supplies | Appliances |
515 | 2010-08-28 00:00:00 | 21 | Nunavut | Consumer | Furniture | Office Furnishings |
613 | 2011-06-17 00:00:00 | 12 | Nunavut | Corporate | Office Supplies | Binders and Binder Accessories |
613 | 2011-06-17 00:00:00 | 22 | Nunavut | Corporate | Office Supplies | Storage & Organization |
643 | 2011-03-24 00:00:00 | 21 | Nunavut | Corporate | Office Supplies | Storage & Organization |
678 | 2010-02-26 00:00:00 | 44 | Nunavut | Home Office | Office Supplies | Paper |
807 | 2010-11-23 00:00:00 | 45 | Nunavut | Home Office | Office Supplies | Paper |
807 | 2010-11-23 00:00:00 | 32 | Nunavut | Home Office | Office Supplies | Rubber Bands |
868 | 2012-06-08 00:00:00 | 32 | Nunavut | Home Office | Office Supplies | Appliances |
... | ... | ... | ... | ... | ... | ... |