|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/knime-for-microsoft-excel-users/
课程评论：没有评论
课程名称：KNIME for Microsoft Excel Users 课程概述： 您是Excel的重度用户吗？想了解更高效的数据处理方式吗？那么您来对地方了！数据清洗往往是一项繁琐的工作，尤其当时间紧迫时，我们需要快速提供关键的数据分析见解。那么，如何提高ETL（提取、转换、加载）和数据准备过程的效率呢？如何让这一过程变得更有趣？认识一下KNIME！这是一个极好的工具，它为我们提供了一个直观的拖放界面，可以轻松进行数据准备和清理。课程无需编程经验，但如果您愿意，也可以使用R、Python或Java等语言进行编程。因此，KNIME为用户提供了极大的灵活性。 在本课程中，我们将为您成功转型到KNIME打下基础。具体内容包括： - 读取和写入Excel数据（文件、工作表、位置等） - 更新Excel工作表（追加数据、覆盖单元格等） - KNIME中对应Excel公式的使用（如Vlookup、高级筛选等） - Excel工作表格式化（字体、背景颜色、边框等） 此外，我们还将介绍KNIME中的可视化选项，特别是可用的可视化选项和所需的数据处理。准备好了吗？让我们开始吧！
You are an extensive Excel user? You want to learn new and better ways of doing things with your data?Then you are right here!Let's face it. Data cleaning is always a big hassle, especially if we are short on time and want to deliver crucial data analysis insights to our audience.But how can we be more efficient in the ETL/ Data Prep process? How can this process be more FUN?Meet KNIME!A great tool which comes to our rescue. KNIME allows us to do data preparation / data cleaning in a very appealing drag and drop interface. (No coding experience is required yet it still allows us if we want to use languages like R, Python or Java. So, we can code if we want but don't have to!). The flexibility of KNIME makes that happen.In this course we lay the foundation for your successfull transition from Excel to KNIMEMore specifically we learnReading and writing Excel data (file, files, sheet, sheets, locations, …)Updating Excel sheets (append data, overwrite cells, …)Covering KNIME‘s equivalent Excel Formulas (Vlookup, (Advanced) Filtering, …)Formatting Excel Worksheets (Font, background color, bordersFurther we will have an introduction to visualizations in KNIMEIn particularavailable visualization optionsRequired data shapingReady? Set! GO!
