Icon

Visualization workflow - Template

Visualization workflow - Template

Visualization workflow - Template

This is a workflow template to collect customer and sales related data from different sources (local and remote) and different file types (Excel, CSV, database). The workflow should blend the collected pieces of data and do some data cleaning, transformation and aggregation to make it ready for visualization and further analysis. The last part of the workflow should build a composite view to visualize the data from different aspects.
The Microsoft Authentication and SharePoint Online Connector nodes are optional, all example files are bundled in the workflow's "data" folder and can be used via local file import.

Data importImport the following files:1. Sales.xlsx (sales data for mutiple products over multiple quarters)2. Demographics_History.xlsx (customer related data)3. Sentiment Analysis.csv (new sentiment evaluation results)4. Sentiment Rating.csv (sentiment rating and description)5. Webdata Old System.xlsx (old web activity data)6. WebActivity.sqlite (new web activity data) Data transformation and blending1. Remove old sentiment rating and web activity columns from the Demographics & History table2. Replace sentiment descriptions with sentiment ratings3. Concatenate old and new web activity records and join them with the sentiment ratings and then with the demographics data4. Remove duplicates; convert category column to string; remove rows where a numerical value is missing5. Join the sales data with the rest of the rest6. Pivot the table to see the quarterly sales results for each product Visualization1. Stacked area chart to visualize quarterly product sale2. Assign a color to each product3. Scatter plot display Basket value vs. Basket size4. Bar chart to display sentiment rating frequencies5. Histogram to visualize customer age distribution Sign in to your Microsoft accountConnect to a Sharepoint folderSales dataDemographics & HistoryNew Sentiment EvaluationExclude Sentiment Ratingand Web ActivityNumeric sentiment scoresSentiment scores+Web activityAdd Demographics DataQuarterly product saleColor by productBasket value vs. Basket sizea MicrosoftAuthentication SharePointOnline Connector Excel Reader Excel Reader CSV Reader Column Filter Cell Replacer Joiner Joiner Stacked Area Chart Color Manager Scatter Plot Data importImport the following files:1. Sales.xlsx (sales data for mutiple products over multiple quarters)2. Demographics_History.xlsx (customer related data)3. Sentiment Analysis.csv (new sentiment evaluation results)4. Sentiment Rating.csv (sentiment rating and description)5. Webdata Old System.xlsx (old web activity data)6. WebActivity.sqlite (new web activity data) Data transformation and blending1. Remove old sentiment rating and web activity columns from the Demographics & History table2. Replace sentiment descriptions with sentiment ratings3. Concatenate old and new web activity records and join them with the sentiment ratings and then with the demographics data4. Remove duplicates; convert category column to string; remove rows where a numerical value is missing5. Join the sales data with the rest of the rest6. Pivot the table to see the quarterly sales results for each product Visualization1. Stacked area chart to visualize quarterly product sale2. Assign a color to each product3. Scatter plot display Basket value vs. Basket size4. Bar chart to display sentiment rating frequencies5. Histogram to visualize customer age distribution Sign in to your Microsoft accountConnect to a Sharepoint folderSales dataDemographics & HistoryNew Sentiment EvaluationExclude Sentiment Ratingand Web ActivityNumeric sentiment scoresSentiment scores+Web activityAdd Demographics DataQuarterly product saleColor by productBasket value vs. Basket sizea MicrosoftAuthentication SharePointOnline Connector Excel Reader Excel Reader CSV Reader Column Filter Cell Replacer Joiner Joiner Stacked Area Chart Color Manager Scatter Plot

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: Dora Barna
Created at: 2022-07-05
On NodePit since: 2022-07-07
Last update: 2024-05-01
Created with KNIME version: v4.6.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!