Low Code/No-Code Data Literacy with KNIME: From Basic to Advanced
2h 18mAdvanced2024-05-21
Authors

KNIME AG Licensor
Course details
Low-code/no-code data analytics tools have been instrumental in enabling the transition from manual, code-heavy, and resource-intensive environments to an automated, scalable, and insights-driven focus. Instead of commands, low-code/no-code platforms have built-in functionality that enables users to start creating data science applications via a drag-and-drop interface. In contrast to coding approaches, low-code/no-code technologies offer an opportunity for users to concentrate on data science and less on the lines of code. The intuitive visual environment also enables business users with less technical skills to build and consume applications. In this course, learn how to use KNIME Analytics Platform to access, blend, analyze and visualize data in a low-code/no-code environment. For anyone who works with data, this course can take your data literacy to the next level by learning how to use a tool that makes sophisticated data analytics accessible to non-technical people.
Skills covered
KNIMEData AnalysisData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOne-Off
Concepts
KNIME Analytics Platform
- What is KNIME Analytics Platform
- What is a node What is a workflow
- How to install KNIME Analytics Platform
- Tour of the user interface of KNIME Analytics Platform
- Build your first workflow with KNIME Analytics Platform
- How to import and export KNIME workflows
- The KNIME Community Hub
- Collaboration and execution on KNIME Community Hub
- How to install KNIME extensions
Data Access
- Data access with KNIME - Reading files
- Data access with KNIME - Accessing databases
Data Cleaning
- Data cleaning with KNIME - How to filter rows
- Data cleaning with KNIME - How to filter columns
- Data cleaning with KNIME - How to handle missing values
Data Transformation
- Data transformation with KNIME - Numbers, strings, and rules
- Data transformation with KNIME - How to split cells
Workflow Documentation
- How to keep workflows tidy and documented
Data Merging
- Data merging with KNIME - How to concatenate tables
- Data merging with KNIME - Value lookup
- Data merging with KNIME - How to join two tables
Data Aggregation
- Data aggregation with KNIME - Simple aggregations
- Data aggregation with KNIME - The GroupBy node
- Data aggregation with KNIME - Pivoting
Data Export and Visualization
- Data export with KNIME - Write to a CSV file
- Data visualization with KNIME - How to create a scatter plot
- Three steps to build an interactive dashboard with KNIME
Flow Variables
- Flow variables in KNIME Analytics Platform - Concept and application
Components
- What is a component in KNIME Analytics Platform
- Create, modify, and configure a component in KNIME Analytics Platform
Workflow Control
- What is a loop
- Build, execute, and debug a loop in KNIME Analytics Platform
- Switch workflow branch execution in KNIME Analytics Platform
Error Handling
- Error handling with try-catch in KNIME Analytics Platform
Date and Time Data
- Handling date and time data with KNIME - Convert strings, extract date, and time fields
- Handling date and time data with KNIME - Modify and filter date and time data
Databases
- Querying databases from KNIME Analytics Platform
- Modify database tables from KNIME Analytics Platform