Icon

Visual Analysis of Sales Data

Workflow that is built according to the instructions on the "Build a workflow" page and in the KNIME Quickstart Guide. It shows possible steps in analyzing (sales) data:

1. Data access - Reading a csv file
2. Data preprocessing - Filtering columns and rows
3. Data visualization - Analyzing the data over time and across groups

URL: Build a workflow https://www.knime.com/getting-started
URL: KNIME Quickstart Guide https://docs.knime.com/latest/analytics_platform_quickstart_guide/index.html

Visual Analysis of Sales Data

This workflow reads and manipulates sales data. Then the data is visualized in two charts.

Data Reading

- Provide file path

Data Preprocessing

- Filter columns and rows

Data Visualization

- Show sales by time and country

How-to

Configure a node

- Hover over the node and click the Rotor icon

- Right click a node and select "Configure"

- Double click a node

- Press F6

Execute a node

- Hover over the node and click the Play icon

- Right click a node and select "Execute"

- Press F7

Open an interactive view

- Hover over the node and click the Magnifying Glass icon

- Right click a node and select "Open view"

Tasks

- Filter data to columns that contain relevant information

- Filter data to rows that you want to include in your analysis

- Visualize the data using a Stacked Area Chart and a Pie/Donut Chart

Select "country", "date" and "amount" columns
Column Filter
Pie Chart
Read sales_2008-2011.csv
CSV Reader
Sales by time
Stacked Area Chart
Remove rowswith duplicate valuesin all columns
Duplicate Row Filter
Exclude rowswhere countryunknown
Row Filter
CSV Reader

Nodes

Extensions

Links