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

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

Nodes

Extensions

Links