Introduction to KNIME
| Course Details | ||||||||
|---|---|---|---|---|---|---|---|---|
|
||||||||
| Languages | ||||||||
|
||||||||
| Outcomes | ||||||||
|
||||||||
| Price & Terms | ||||||||
|
||||||||
| Technical | ||||||||
|
||||||||
| Specification | ||||||||
|
||||||||
Build KNIME workflows that read files and databases, clean messy records, and merge and aggregate data to answer questions, all without code.
KNIME Analytics Platform lets you prepare and study data by linking visual building blocks into a workflow instead of writing code. You work with an HR department’s information throughout: reading its files, pulling records from a database without typing a query, fixing missing values, duplicates and messy strings, and then merging and summarizing the results to answer the department’s questions.
What You Will Achieve
- Assemble a KNIME workflow that reads a dataset, tidies it and charts the result
- Bring in data from a single file, a batch of files or a database without typing a query
- Get raw records ready for analysis by dropping repeated rows, treating empty fields and correcting text and type problems
- Combine prepared datasets and aggregate them to answer an HR department’s questions
Program Overview
First Steps in KNIME Analytics Platform
A tour of the interface and a first workflow that reads HR data, tidies it and turns it into a simple chart.
- The KNIME user interface
- A first end-to-end workflow on HR data
- A simple plot of the results
Data Access and Cleaning
Ways to bring data in and then prepare it, so the HR records are complete, consistent and ready for analysis.
- Browsing and reading local and remote files
- Reading twenty files in one step
- Database queries built visually
- Removing unneeded data, string cleanup and type conversion
Merging and Aggregating Data
The accessed and cleaned data is combined and summarized to answer the HR department’s questions.
- Lookups that merge datasets
- Aggregation for summary figures
- Answering HR questions with the finished workflow
Certificate Awarded (Paid)
Job Outlook
These skills apply wherever data has to be gathered from files and databases, cleaned and summarized for a team, as in the HR reporting the exercises are built around.
Good for: People who want to prepare and summarize data in KNIME through a visual workflow rather than code.
Keep in mind: All four chapters follow one HR department’s data through reading, cleaning, merging and aggregating, so the course stays with data preparation and summary work in KNIME.
Bottom line: A step-by-step build of one KNIME workflow on HR data that covers the core preparation tasks without any code.
Frequently Asked Questions
What is KNIME Analytics Platform?
It is an open-source, no-code/low-code tool in which you assemble data tasks visually by drag and drop into a workflow. In this course you use it to read, clean, plot, merge and aggregate data.
What dataset do the exercises use?
The exercises follow an HR department's data throughout the course. You read its files, clean them, and then merge and aggregate the results to answer questions the department has asked.
How does the course handle database queries?
The chapter on bringing data in shows how to build a database query visually, so you retrieve records without typing the query yourself. The same chapter covers reading a local file and reading twenty files at once.
What kind of practice does each chapter include?
Each chapter has exercises in which you build part of the HR workflow in KNIME, such as reading twenty files at once, filtering rows, handling missing values, cleaning strings or looking up values to merge datasets.
User Reviews
Write your review
You must be logged in to post a review.
Reviews can only be posted by registered learners. Log in or create a free account, then you will return here to post.
There are no reviews yet.