KNIME 101 - ETL Tools for Beginners

For first time users. Essential ETL tools.

What you'll learn:

• JOIN Types
• Changing names of the column headers
• Merging columns to create a new column
• Pattern Matching Criteria
• Range Checking Criteria
• Finding Data Patterns

Data pre-processing and coding is a prerequisite to move ahead in Data Science. KNIME eliminates those hurdles for you.

This course is for anyone who is familiar with tools such as Excel or Power Query (ETL). This course will help you get a head start in Data Science without any coding.

We’ll learn some practical applications of data blending and manipulation and apply our knowledge in the real world and solve business queries immediately. Following are the topics that we'll cover in this course:

• JOIN Types - Left Outer, Right Outer, Full Outer, Inner, Left Anti, and Right Anti

• Splitting one column into two

• Change the name of the column headers

• Merge columns to create a new column

• Find out list of Male/Female candidates (Pattern Matching Criteria)

• Filter out people whose credit score exceed a certain limit (Range Checking Criteria)

• Pivoting with multiple columns and complex aggregation methods

• Finding data patterns

By the end of the course, we will feel comfortable working with the KNIME Analytics Platform.