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
Writer Nodes (Excel and CSV)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock