KNIME 101 - ETL Tools for Beginners
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
Course content
KNIME Overview4 lectures • 8min
- Downloading KNIME Analytics PlatformPreview01:04
- KNIME Interface WalkthroughPreview05:34
- How to use the Exercise Files01:03
- Practice Files00:05
Input & Output Nodes (Read & Write)3 lectures • 11min
Data Blending6 lectures • 24min
Data Manipulation - Part 1 (Filter & Splitter)7 lectures • 31min
Data Manipulation - Part 2 (Transform)7 lectures • 28min
Data Manipulation - Part 3 (Split & Join Text)3 lectures • 11min
Data Manipulation - Part 4 (Convert & Replace)6 lectures • 38min
Bonus2 lectures • 7min
Instructor
![Yoda Learning](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.3 Instructor Rating
- 7,599 Reviews
- 117,443 Students
- 29 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!