Learn Knime Fast By Solving 3 It Case Studies

Free Download Learn Knime Fast By Solving 3 It Case Studies
Published 7/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.54 GB | Duration: 1h 30m
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
Homepage

www.udemy.com/course/learn-knime-fast/