KNIME 101 - ETL Tools for Beginners

Name: KNIME 101 - ETL Tools for Beginners
Rating: 4.3 (49 reviews)

For first time users. Essential ETL tools.

(49 ratings)

5,355 students

Created by Yoda Learning

Last updated 5/2020

English

English [Auto]

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

Requirements

Everyone who deals with the data on day-to-day basis
If you want to learn basics of KNIME
Anyone into Analysis, Machine Learning and AI

Description

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.

Who this course is for:

If you use a lot of Excel and want to take your skills to the next level
Anyone who struggle to write VBA Macros code for automation
Anyone who is completely new to KNIME
Users who are looking for quick shortcuts, tips & tricks of KNIME

Yoda Learning

Data Analyst |MS Office Expert & PMP | Instructor/Programmer

4.4 Instructor Rating
10,112 Reviews
139,804 Students
24 Courses

20,000 Classroom Students | 100,000+ Students Online

ex-KPMG, ex-J.P. Morgan | Chartered Accountant
Taught 12k+ participants across PwC, EY and Deloitte over last 10 years

I am a Chartered Accountant from India. I have worked with KPMG (Audit) and J.P. Morgan (Debt Capital Markets) and Futures First (Proprietary Trading Desk) before venturing into Corporate Training (first part-time and then full-time)

After a decade of corporate training and winning multiple accolades in Office Productivity and Financial Modelling, in 2015, I created a mission to help 1 million people by 2020. I started creating high-quality video courses and helped people online to become faster-smarter-better at work. A lot of my students at PwC, EY, Deloitte, Amazon, Uber, Tata Group, Rio Tinto use these video courses to excel at work.

If I’m going to succeed in my mission of helping 1 million professional in the next five years, I NEED YOU to succeed… I can’t reach my goal without helping you reach yours!