Icon

KNIME_​exam

Data Input

(The "Reader" Phase)

Exploratory Data Analysis

(EDA)

Data Cleaning

(The "Transformation" Phase)

Data Manipulation & Joining

Data Analysis & Visualization

Bar Chart
MATRIX OF PAYMENT METHOD VS. LOCATION TO SEE TRANSACTION COUNTS
Pivot
IT SHOWS NUMBER OF MISSING VALIUES AND UNIQE VALUES PER COLUMN
Statistics View
Rule Engine
IT SHOWING THE ITEM AND PRICE GEP PER UNIT
Scatter Plot
IT SHOWS NUMBER OF MISSING VALIUES PER COLUMN
Statistics
ADJUST MISSING VALUES OF SOME COLUMNS WITH MOST FREQUENT VALUES
Missing Value
NO DUBLICATE ROWS FOUND
Duplicate Row Filter
CSV Reader
Pie Chart
CHANGE DATA TYPE OF TRANSACTION DATE
String to Date&Time
ADJUST MISSING VALUES OF TRANSACTION DATE, QUANTITY AND PRICE PER UNIT COLUMN
Missing Value
CHANGE DATE TYPE OF QUANTITY AND PRICE PER UNIT COLUMN
String to Number
REPLACE UNKNOWN AND ERROR VALUES FROM LOCATION COLUMN TO 0
Rule Engine
REPLACE UNKNOWN AND ERROR VALUES FROM PAYMENT METHOD COLUMN TO 0
Rule Engine
CALCULATE TOTAL REVENUE BY ITEM OR LOCATION
GroupBy
CREATE A NEW COLUNM TOTAL_SALES BY MULTIPLYING QUNTITY AND PRICE PER UNIT CELLS
Math Formula

Nodes

Extensions

Links