Icon

Ecommerce NEW - Exercise

There has been no title set for this workflow's metadata.

There has been no description set for this workflow's metadata.

Read: -"eCommerce-TransactionsL3M.xlsx" -" eCommerce-TransactionsHistory" files with excel reader nodes Read: -"eCommerce-CustomerMD.csv" - "eCommerce-ProductMD.csv" files with csv reader nodes Concatenate historical and L3Mtransactions files Convert Customer ID tostring Left outer Joininformation fromconcatenatedtransactions file witheCommerce-CustomerMD.csv oncustomer ID Inner Join the new filewith eCommerce-ProductMD.csv to retrieveinfo on StockCode Calculate Sales bymultiplying the$Quantity$*$Price$ Manage missing values:fix Countries with no infowith value "Unspecified" Exclude rows withCategory = "Others" Sum sales and quantity grouping byStockCode,Description, Category,Subcategory Sum sales and quantity grouping byCountry Sort by decreasingsales Keep top 10 only Group loop for each subcategory, to keep only the top 3 products Sort by decreasingsales Write the following results in excel: - Top 10 products- Top products by subcategory- Top countries- 2019 Sales Convert Invoice_timeto date format Filter Invoices from2019 Calculate total Sales Calculate Sales->Sum Quantity->Sum Price->Meanat category level Create a flowvariablewith totals Calculate footprint>Sales/Sum(Sales)*100 Extract month numberof the invoice Sum sales bycategory and month Visualize sales bymonth Save the image withname Seasonality.svg Read: -"eCommerce-TransactionsL3M.xlsx" -" eCommerce-TransactionsHistory" files with excel reader nodes Read: -"eCommerce-CustomerMD.csv" - "eCommerce-ProductMD.csv" files with csv reader nodes Concatenate historical and L3Mtransactions files Convert Customer ID tostring Left outer Joininformation fromconcatenatedtransactions file witheCommerce-CustomerMD.csv oncustomer ID Inner Join the new filewith eCommerce-ProductMD.csv to retrieveinfo on StockCode Calculate Sales bymultiplying the$Quantity$*$Price$ Manage missing values:fix Countries with no infowith value "Unspecified" Exclude rows withCategory = "Others" Sum sales and quantity grouping byStockCode,Description, Category,Subcategory Sum sales and quantity grouping byCountry Sort by decreasingsales Keep top 10 only Group loop for each subcategory, to keep only the top 3 products Sort by decreasingsales Write the following results in excel: - Top 10 products- Top products by subcategory- Top countries- 2019 Sales Convert Invoice_timeto date format Filter Invoices from2019 Calculate total Sales Calculate Sales->Sum Quantity->Sum Price->Meanat category level Create a flowvariablewith totals Calculate footprint>Sales/Sum(Sales)*100 Extract month numberof the invoice Sum sales bycategory and month Visualize sales bymonth Save the image withname Seasonality.svg

Nodes

  • No nodes found

Extensions

  • No modules found

Links

Download

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

Download Workflow
Created by: demauro.a
Created at: 2021-01-10
On NodePit since: 2024-09-17
Last update: 2024-10-18
Created with KNIME version: v5.2.0

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

Try NodePit Runner!