Learn Knime Fast By Solving 3 IT Case Studies

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 Outline

• Install Knime & learn to navigate the interface

• Solve 3 real world IT case studies with Knime, whilst showing you how to use the program at the same time

Case Study 1: Automate a Supermarket Sales Report

You’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 files

• Remove duplicates

• Do an Inner & Left Join

• Filter rows

• Round numbers

• Transform arithmetic, string, and conditional values

• Create a pivot table

• Do basic visualisation, and

• Export to Excel

Case Study 2: Splitting & joining a HR report about Employee Cost

HR  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 files

• Use a Group By Loop

• Use Flow Variables, and

• Export to Excel

Case Study 3: Bitcoin arbitrage

Arbitrage 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 variables

• Create a GET API Request

• Parse JSON To Table

• Filter Columns

• Transform string, and

• Use Metanodes to tidy up a busy workflow

If you love the sound of all of this, then let's get started by learning how to install Knime and navigating the interface.

TAKE THIS COURSE