Low Code/No-Code Data Literacy with KNIME: From Basic to Advanced

Low Code/No-Code Data Literacy with KNIME: From Basic to Advanced

2h 18mAdvanced2024-05-21

Authors

KNIME AG Licensor

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
80,000 Toman