KNIME Interface Walkthrough | Yoda Learning Academy

Autoplay
Autocomplete

Previous Lesson Complete and Continue

EXCEL TO KNIME ONLINE COURSE

Section 1: Introduction to KNIME

Downloading KNIME Analytics Platform (1:04)
KNIME Interface Walkthrough (5:34)
How to use the Exercise Files (1:03)
Practice Files - Please download

Section 2: Input & Output Nodes (Read & Write)

Reader Nodes (File, Excel, CSV) (4:52)
Writer Nodes (Excel and CSV) (3:55)
Table Creator (2:19)
Excel to KNIME Course Feedback

Section 3: Data Blending

Understanding different types of JOINS (6:24)
Working with JOIN Types (8:09)
Column Rename (2:40)
Column Appender (2:14)
Column Combiner (2:43)
Column Merger (2:03)
Excel to KNIME Course Feedback

Section 4: Data Manipulation - Part 1 (Filter & Splitter)

Duplicate Row Filter (4:59)
Row Filter (6:33)
Nominal value row filter (2:41)
Rule-based Row Filter (5:53)
Date&Time-based Row Filter (2:54)
Column Filter (3:27)
Splitter Nodes (Row, Nominal Value, and Rule-based Row) (4:36)
Excel to KNIME Course Feedback

Section 5: Data Manipulation - Part 2 (Transform)

Sorter (2:26)
Column Resorter (2:04)
Pivoting Basics (4:37)
GroupBy Basics (4:04)
UnPivoting (5:20)
Concatenate (3:22)
Missing Value Basics (5:40)
Excel to KNIME Course Feedback

Section 6: Data Manipulation - Part 3 (Split & Join Text)

Cell Splitter (2:40)
Cell Splitter By Position (2:33)
Column Aggregator (5:21)
Excel to KNIME Course Feedback

Section 7: Data Manipulation - Part 4 (Convert & Replace)

Data Type Conversions (Number, String, and Date&Time) (5:18)
Extract Date&Time Fields (2:16)
MathFormula and Rule Engine (12:38)
String Manipulation - Part 1 (5:40)
String Manipulation - Part 2 (3:50)
Column Expressions (7:51)
Excel to KNIME Course Feedback

Section 8: Bonus

Annotations, Comments, and Metanodes (Basics) (3:36)
Statistics - Basics (3:14)

Section 9: Project - 3 year Sales by 4 Business Segments (60K rows)

Practice files for Project #1
KNIME CheatSheet v1.0
Using File Reader and Use of Joiner Node (6:35)
Appending Sales Files using Concatenate Node (8:20)
Adding in New Data to Existing Workflow (7:27)
Quiz -Q.-1
Modularization of Nodes into Metanodes (4:50)
Database Connectors, Knime Extensions, and Statistics Node (7:06)
Quiz -Q.-2
Date Extraction Node and GroupBy Node (5:12)
Using Row and Column Filter (4:08)
Quiz -Q.-3
Using Math Formula and Writer Nodes (1:41)
Configuring and Applying Math Formula and Writer Nodes (4:48)
Quiz -Q.-4
Recency, Frequency, and Monetary) RFM Segmentation (3:29)
Creation of RFM Segmentation (6:19)
Using Auto Binner to Bucket RFM Segmentation (10:28)
Quiz -Q.-5
A Quick Recap (2:55)
Using Table Creator and Cell Replacer Nodes - Part 1 (2:25)
Using Table Creator and Cell Replacer Nodes - Part 2 (6:11)
Quiz -Q.-6
Cleaning Up a Workspace (4:43)
Quiz -Q.-7
Pie and Bar Charts in KNIME (2:50)
Creating Pie and Bar Charts (7:27)
Pivot Charts (2:11)
Importing and Exporting Workflows in KNIME (3:45)
Quiz -Q.-8
Project Conclusion (10:36)
Excel to KNIME Course Feedback

KNIME Interface Walkthrough

In this video, you will get to know the KNIME User Interface.

Complete and Continue

Lesson Content Locked

Your session expired. Please sign in again to continue.

Login