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:

  • 5 Hours of On-Demand Video
  • 58 HD Video Lecture
  • Premium eBooks | Practice files
  • Lifetime Support & Access
  • Course Completion Certificate
Enroll Now
LEARN MORE
Nip_Fab_testimonial_page_1.png
“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 - Yodalearning Student
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 - Yoda Learning Student
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
Yoshika Chhabra
E & Y
Read More Testimonials

Lifetime Access

Project Finance Tutorials
$ 29
  • 58 HD Videos
  • 5 Hours of Video
  • Lifetime Support
ENROLL NOW
Get started now!

Click here to make payment in INR

For a newcomer to online training, this program dispelled all my apprehension. Over the years, I learned about MS Office progressively at the workplace. But Yoda learning gave me an insight into Excel. Word and PowerPoint. I can do scores of my activities in a matter of few minutes instead of several man-days. Thank you, Yoda.
Nobinkumar Pradhan
Nobinkumar Pradhan
This course is full of hidden tricks, tools, tips, and amazing learning. The way of teaching of sir is beyond the traditional no confusion lies after you had listened to him carefully. I would like to recommend everyone excel learners go for a structured learning platform ie Yoda Learning Course Excel Ninja.
CA NIRMAL CHOUDHARY
CA NIRMAL CHOUDHARY
Great syllabus for real-life applications. Rishabh's videos and worked examples on file downloads make a huge difference to the learning experience. I have learned a lot through Yoda Learning which has sped up my work and created better presentations and analysis.
Adam
Adam
Previous
Next

14 days Money-back Guarantee

FAQ

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.

FOR ENQUIRY ABOUT EXCEL TO KNIME COURSE? CONTACT US:

[email protected]

IN: +91-7738922884

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