Overview

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.

Skills

Reviews