Section 1: Lab: Getting Started with KNIME Analytics Platform 5
- What KNIME is: node-based visual workflows and low-code data science
- Install KNIME 5 and choose between the LTS and the standard release
- The new interface: Node Repository, Description, Node Monitor and Space Explorer
- Configure and execute nodes, read node status, and save and export workflows
- Install extensions and find example workflows on the KNIME Community Hub
Section 2: Lab: Importing and Exploring Data
- Read data with CSV Reader, Excel Reader and the DB nodes for databases
- Check the schema, data types and basic statistics of each column
- Find missing values, duplicates, malformed values and outliers
- Lab: explore a customer dataset and summarise its data quality issues
Section 3: End-to-End Data Preparation with Nodes
- Convert types, use String Manipulation and create new columns with the Expression node
- Missing Value, Rule Engine, Row Filter and Column Filter
- Joiner, Concatenate, GroupBy and Pivot to combine and summarise data
- Binning, Normalizer and One to Many to prepare features
- Lab: build a workflow that takes a raw file all the way to model-ready data
Section 4: Visualisation, Components and Data Apps
- Bar charts, scatter plots, box plots and heatmaps to see patterns in data
- Group nodes into metanodes and components to keep workflows readable and reusable
- Build interactive views with component views and open them as a data app
- Lab: a customer exploration data app with selectable filters
Section 5: Lab: K-AI and Python in KNIME
- K-AI, the AI assistant, in both Q&A mode and build mode that adds nodes for you
- What data leaves your machine when you use K-AI, and why it matters
- The Python Script node with the knime.scripting.io module and the bundled environment
- Lab: use pandas to extend a workflow where built-in nodes fall short