## EXCEL TO KNIME TUTORIALS

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

This Course includes:

“I am very impressed with Yoda Learning courses – I particularly like the short videos that allow me to get to a topic quickly and the other gem is the shortcuts.”

## Course Curriculum

0101 Downloading KNIME Analytics Platform
0102 KNIME Interface Walkthrough
0103 How to use the Exercise Files

Download Course Curriculum

0201 Reader Nodes (File, Excel, and CSV)
0202 Writer Nodes (Excel and CSV)
0203 Table Creator

Download Course Curriculum

0301 Understanding different types of JOINS
0302 Working with JOIN Types
0303 Column Rename
0304 Column Appender
0305 Column Combiner
0306 Column Merger

Download Course Curriculum

0401 Duplicate Row Filter
0402 Row Filter
0403 Nominal Value Row Filter
0404 Rule-based Row Filter
0405 Date&Time-based Row Filter
0406 Column Filter
0407 Splitter Nodes (Row, Rule-based Row, and Nominal Value)

Download Course Curriculum

0501 Sorter
0502 Column Resorter
0503 Pivoting
0504 GroupBy
0505 Unpivoting
0506 Concatenate
0507 Missing Value

Download Course Curriculum

0601 Cell Splitter
0602 Cell Splitter By Position
0603 Column Aggregator

Download Course Curriculum

0701 Data Type Conversions (Number, String, and Date&Time)
0702 Extract Date&Time Fields
0703 Math Formula and Rule Engine
0704 String Manipulation – Part 1
0705 String Manipulation – Part 2
0706 Column Expressions

Download Course Curriculum

0801 Annotations, Comments, Meta nodes (Basics)
0802 Statistics node

Download Course Curriculum

0901 Using File Reader and Use of Joiner Node
0902 Appending Sales Files using Concatenate Node
0903 Adding in New Data to Existing Workflow
0904 Modularization of Nodes into Meta nodes
0905 Database Connectors, Knime Extensions, and Statistics Node
0906 Date Extraction Node and GroupBy Node
0907 Using Row and Column Filter
0908 Using Math Formula and Writer Nodes
0909 Configuring and Applying Math Formula and Writer Nodes
0910 Recency, Frequency, and Monetary) RFM Segmentation
0911 Creation of RFM Segmentation
0912 Using Auto Binner to Bucket RFM Segmentation
0913 A Quick Recap
0914 Using Table Creator and Cell Replacer Nodes – Part 1
0915 Using Table Creator and Cell Replacer Nodes – Part 2
0916 Cleaning Up a Workspace
0917 Pie and Bar Charts in KNIME
0918 Creating Pie and Bar Charts
0919 Pivot Charts
0920 Importing and Exporting Workflows in KNIME
0921 Project Conclusion

Download Course Curriculum

## COURSE INSTRUCTOR

### Rishabh Pugalia

Course Narrator

Worked with KPMG, and became a Chartered Accountant
Traded Interest Rate Futures, and then worked with J.P. Morgan (Fixed Income)

## We’ve helped over 7,800 learners overcome their learning “plateau”...

Don’t take my word for it – check out this feedback from some of the professionals representing virtually every business domain, background and experience level…
“I am very impressed with Yoda Learning courses – I particularly like the short videos that allow me to get to a topic quickly and the other gem is the shortcuts.”
Peter Klugsberger
Mckinsey & Company
“The courses are not only technically very knowledgeable, but also genuinely helpful for professionals who want to work smarter, not harder.”
Karnika Bhalla
Delloite
“The training curriculum and course was extremely well designed, thorough and catered to use cases relevant to our domain of work.”
Yoshika Chhabra
E & Y

### Lifetime Access

Project Finance Tutorials
\$ 29
• 58 HD Videos
• 5 Hours of Video
• Lifetime Support

14 days Money-back Guarantee

### DO YOU PROVIDE SUPPORT DURING THE COURSE?

We have a chat panel in every lecture window. You can take screenshots, upload file, and send queries to our support desk. QnA should be related to the case study files ONLY.

### DO I GET A CERTIFICATE AT EACH LEVEL?

No, you do not get a Certificate at each level. We only provide the course completion certificate.

### CAN I DOWNLOAD THE COURSE?

No. But, you can watch the videos unlimited number of times.

### CAN I ACCESS THE COURSE FROM MORE THAN ONE COMPUTER?

Yes, you can access the course from only 2-3 devices (computer or mobiles) with your login credentials.

### EXPLAIN THE REFUND POLICY.

You can ask for refund within 14-days of enrollment. No questions asked.

#### [email protected] IN: +91-7738922884

Feel free to call us for any query related to the course. Our support team will resolve your issue.