|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-knime-fast/
课程评论：没有评论
课程名称：通过解决3个IT案例快速学习Knime 课程概述： 本课程为初学者设计，旨在教授如何使用市场上最优秀的机器人流程自动化工具Knime。通过实际操作，您将通过解决三个真实的IT案例，迅速掌握Knime的使用技巧。 课程大纲： 1. 安装Knime并学习如何导航其界面。 2. 解决三个现实世界的IT案例，边学习边使用该程序。 案例研究1：自动化超市销售报告 您将创建一个工作流程，自动计算每个超市商品的利润，包括数据清理、结果聚合到透视表以及为中层管理制作漂亮的图表。通过此案例，您将学习如何使用Knime进行： - 读取Excel文件 - 删除重复项 - 进行内部和左连接 - 过滤行 - 四舍五入数字 - 转换算术、字符串和条件值 - 创建透视表 - 基本可视化 - 导出到Excel 案例研究2：拆分和合并员工成本HR报告 此案例中，您将处理HR提供的员工文件，按照部门拆分文件，并在部门负责人填写后合并预测数据。您将在Knime中学习如何： - 读取Excel文件 - 使用分组循环 - 使用流变量 - 导出到Excel 案例研究3：比特币套利 您将利用Knime分析三个加密货币交易所的比特币价格，以识别套利机会。请注意，这仅用于教育目的，而非财务建议。通过此案例，您将学习如何在Knime中： - 使用流变量 - 创建GET API请求 - 将JSON解析为表格 - 过滤列 - 转换字符串 - 使用元节点整理复杂工作流 如果您对这个课程感兴趣，那么让我们开始学习如何安装Knime并导航其界面吧！
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.
