Icon

Team 1 Group Assignment 1

What was the average discount of each product and how many were sold? Who is the top salesperson per store for Q1 2017? What are the top selling Bike Categories? Which bike stores have a Trek Marlin 7 in stock? Who is our top selling stores management and I need their contact information? Who are the top customers by order quantity? Node 1 Select Table 'Products"Sales Table "customers"Sales Table "orders"Sales Table "order_items"Join customer table to orders table by customer idJoin customer and order tables with the order items tablefilter only customer data and quantityaggregate order quantity by customerSort by top customersFilter to show only columnsProduct Name & DiscountJoin table Products & Order Items into one through product_idRetrieve the database information from SQLSelect Table "Order_Items"Group the bikes by product nameGet the count of bikes by product nameAverage the discount applied to each saleSort the data table by quantity soldand average discount from highest discount to lowest discountJoin the staffs table with the joined orders and stores tableNode 18Select Table "Orders" Select table "Staffs"Select table "Stores"Join orders table and stores table by store_idFilter columns to include only First and last name, email, store id and order idFilter out orders for Jan-Mar 2017to identify sales in "Q1"Joins by product idNode 26Order ItemsProductsCategoriesJoins by category idAggregate order quantity by category idSort by top selling category nameNode 41StoresStocksProductsJoin Stores and StockJoin Product and StockFilter row by quantity and productFilter Unneeded DataNode 49StaffsordersOrder itemsjoined by Store idJoined by order idaggregate order by count and group with management info, store idFilter to include only top store MySQL Connector DB Table Selector DB Table Selector DB Table Selector DB Table Selector DB Joiner DB Joiner DB Column Filter DB GroupBy DB Sorter DB Column Filter DB Joiner MySQL Connector DB Table Selector DB GroupBy DB Sorter DB Joiner MySQL Connector DB Table Selector DB Table Selector DB Table Selector DB Joiner DB Column Filter DB Row Filter DB Joiner MySQL Connector DB Table Selector DB Table Selector DB Table Selector DB Joiner DB GroupBy DB Sorter MySQL Connector DB Table Selector DB Table Selector DB Table Selector DB Joiner DB Joiner DB Row Filter DB Column Filter MySQL Connector DB Table Selector DB Table Selector DB Table Selector DB Joiner DB Joiner DB GroupBy DB Row Filter What was the average discount of each product and how many were sold? Who is the top salesperson per store for Q1 2017? What are the top selling Bike Categories? Which bike stores have a Trek Marlin 7 in stock? Who is our top selling stores management and I need their contact information? Who are the top customers by order quantity? Node 1 Select Table 'Products"Sales Table "customers"Sales Table "orders"Sales Table "order_items"Join customer table to orders table by customer idJoin customer and order tables with the order items tablefilter only customer data and quantityaggregate order quantity by customerSort by top customersFilter to show only columnsProduct Name & DiscountJoin table Products & Order Items into one through product_idRetrieve the database information from SQLSelect Table "Order_Items"Group the bikes by product nameGet the count of bikes by product nameAverage the discount applied to each saleSort the data table by quantity soldand average discount from highest discount to lowest discountJoin the staffs table with the joined orders and stores tableNode 18Select Table "Orders" Select table "Staffs"Select table "Stores"Join orders table and stores table by store_idFilter columns to include only First and last name, email, store id and order idFilter out orders for Jan-Mar 2017to identify sales in "Q1"Joins by product idNode 26Order ItemsProductsCategoriesJoins by category idAggregate order quantity by category idSort by top selling category nameNode 41StoresStocksProductsJoin Stores and StockJoin Product and StockFilter row by quantity and productFilter Unneeded DataNode 49StaffsordersOrder itemsjoined by Store idJoined by order idaggregate order by count and group with management info, store idFilter to include only top store MySQL Connector DB Table Selector DB Table Selector DB Table Selector DB Table Selector DB Joiner DB Joiner DB Column Filter DB GroupBy DB Sorter DB Column Filter DB Joiner MySQL Connector DB Table Selector DB GroupBy DB Sorter DB Joiner MySQL Connector DB Table Selector DB Table Selector DB Table Selector DB Joiner DB Column Filter DB Row Filter DB Joiner MySQL Connector DB Table Selector DB Table Selector DB Table Selector DB Joiner DB GroupBy DB Sorter MySQL Connector DB Table Selector DB Table Selector DB Table Selector DB Joiner DB Joiner DB Row Filter DB Column Filter MySQL Connector DB Table Selector DB Table Selector DB Table Selector DB Joiner DB Joiner DB GroupBy DB Row Filter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: buechner34
Created at: 2021-09-11
On NodePit since: 2021-09-13
Last update: 2024-11-13
Created with KNIME version: v4.4.1

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!