Learn Knime Fast By Solving 3 It Case Studies

Learn the Knime Interface, automate & data cleanse a sales report, split & join files, and idenfity Crypto arbitrage!

What you'll learn

Navigate The Knime Interface

Automate Data Cleansing & Data Transformation

Identify Bitcoin Arbitrage

Read Excel Files

Remove Duplicates

Inner & Left Joins

Row Filters

Column Filters

Number Rounding

Arithmetic, String & Conditional Value Calculations

Pivot Table

Basic Chart Visualisation

Export Files To Excel

Group By Loop

Flow Variables

Get API Requests

Parse JSON To A Table

Requirements

Knime is installed

Description

In this beginner-friendly course, you're going to learn how to use - in my opinion - the best Robotic Process Automation tool on the market - Knime!Course OutlineInstall Knime & learn to navigate the interfaceSolve 3 real world IT case studies with Knime, whilst showing you how to use the program at the same timeCase Study 1: Automate a Supermarket Sales ReportYou’re going to create a workflow that automatically calculates the Profit for each Supermarket item based on Accounting data. You'll data cleanse the Aisle name, aggregate the results into a pivot table, and create some pretty charts for middle management that like to look at colourful pictures.By solving this case study, you’ll learn how to use Knime to:Read Excel filesRemove duplicatesDo an Inner & Left JoinFilter rowsRound numbersTransform arithmetic, string, and conditional valuesCreate a pivot tableDo basic visualisation, andExport to ExcelCase Study 2: Splitting & joining a HR report about Employee CostHR  have a file that contains all employees in the company.HR has asked you to split this file for them by Department so they can then email it to each Department Head and ask them to forecast the salary cost of each of their employees.When the Department Heads have filled it in and emailed it back, HR wants you to combine all the forecasts back together into 1 file.By doing this case study, you'll learn how to do the following in Knime:Read Excel filesUse a Group By LoopUse Flow Variables, andExport to ExcelCase Study 3: Bitcoin arbitrageArbitrage is taking advantage of price differences of an asset. For example, Bitcoin might cost $25000 one exchange, and $30000 on another. Therefore, a price difference of $5000.Arbitrage is buying Bitcoin on the cheaper exchange, and transferring to and selling it on the expensive exchange.We’ll be using Knime to look up 3 Crypto Exchanges to get the price of Bitcoin against the USD, and identify if there’s any arbitrage opportunities.Keep in mind, you won't make any money from doing this - you're like, 10 years too late where the price differences between exchanges used to be huge. This is really for educational purposes only. It's not financial advice, and don't be silly with your money.By doing this case study, you'll learn how to do the following in Knime:Use Flow variablesCreate a GET API RequestParse JSON To TableFilter ColumnsTransform string, andUse Metanodes to tidy up a busy workflowIf you love the sound of all of this, then let's get started by learning how to install Knime and navigating the interface.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Install Knime & Interface Tour

Lecture 2 Install Knime

Lecture 3 Interface Tour

Section 3: Case Study 1: Supermarket Sales Report

Lecture 4 Case Study 1 Intro

Lecture 5 Case Study 1 - Workflow Walkthrough

Section 4: Case Study 2: Split & Join A HR Report

Lecture 6 Case Study 2 Intro

Lecture 7 Case Study 2 - Workflow Walkthrough

Section 5: Case Study 3: Crypto Arbitrage

Lecture 8 Case Study 3 Intro

Lecture 9 API Intro

Lecture 10 Case Study 3 - Workflow Walkthrough

Section 6: Interface Extras

Lecture 11 Interface Extras

Automation enthusiasts who want to learn Knime,People who want to automate reporting & business processes,People who want to identify Crypto Arbitrage with Knime