KNIME lessons

Open-source node-based workflows for ETL and analytics. 13 lessons across 4 tracks, each ending with a short self-check.

13lessons

70mtotal

4tracks

26checks

Node-based fundamentals

The workbench, node states, and reading and writing files.

3 · 16m

The KNIME workbenchNode repository, workflow editor, console — and how a workflow is put together.beginner5m Node states and executionThe traffic-light system, and what each colour is telling you.beginner5m Reading and writing filesCSV Reader, Excel Reader, writers, and reading many files at once.beginner6m

Data manipulation

Filtering columns and rows, rule logic, and handling missing values.

3 · 16m

Column Filter and Row FilterReducing the table in both directions.beginner5m The Rule EngineConditional logic — the IF/CASE of KNIME.beginner6m Missing valuesThe Missing Value node, and choosing a strategy per column.beginner5m

Transformation & aggregation

Joining, concatenating, grouping, pivoting.

4 · 23m

The Joiner nodeJoin types, multiple keys, and the outputs that show unmatched rows.intermediate7m Concatenate and Column AppenderStacking tables and attaching columns.beginner5m The GroupBy nodeGrouping and aggregating — and the column naming that surprises people.intermediate6m Pivoting and UnpivotingRows to columns and back.intermediate5m

Execution & sharing

Organising, annotating, exporting and running workflows.

3 · 15m

Organising workflowsAnnotations, metanodes and components — keeping a large workflow readable.beginner5m Views and data explorationStatistics, Data Explorer and the visual nodes for checking your work.beginner5m Exporting and running workflowsSharing workflows, and the options for running them unattended.intermediate5m