what is knime? · what is knime? • knime = konstanz information miner • developed at university...
TRANSCRIPT
![Page 1: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/1.jpg)
WhatisKNIME?WhatisKNIME?
![Page 2: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/2.jpg)
What is KNIME? • KNIME=KonstanzInformationMiner• DevelopedatUniversityofKonstanzinGermany• Desktopversionavailablefreeofcharge(OpenSource)• Modularplatformforbuildingandexecutingworkflowsusingpredefinedcomponents,callednodes• Functionalityavailablefortaskssuchasstandarddatamining,dataanalysisanddatamanipulation• ExtrafeaturesandfunctionalitiesavailableinKNIMEbyextensions• WritteninJavabasedontheEclipseSDKplatform
![Page 3: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/3.jpg)
KNIME เปน Analytic Platform แบบ Open Source ทไดรบการจดอนดบจาก Gartner (ประกาศเมอเดอน Jan 2019) อยในกลม Leader ดาน Data Science & Machine Learning มาหลายปตดกน KNIME เปน Data driven software ททาอะไรไดกได เชนText mining, Image processing, สามารถเชอมกบภาษาPython, R, Spark H2O, Keras/TensorFlow for Deep Learning ไดอยางลนไหล
![Page 4: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/4.jpg)
![Page 5: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/5.jpg)
KNIME Software Overview
![Page 6: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/6.jpg)
KNIME resources https://www.knime.com
![Page 7: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/7.jpg)
What can you do with KNIME? DatamanipulationandanalysisFile&databaseI/O,filtering,grouping,joining,....
Datamining/machinelearningWEKA,R,Interactiveplotting
ScriptingIntegrationR,Perl,Python,Matlab ...
MuchmoreBioinformatics,textminingandnetworkanalysis
![Page 8: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/8.jpg)
![Page 9: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/9.jpg)
![Page 10: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/10.jpg)
![Page 11: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/11.jpg)
![Page 12: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/12.jpg)
![Page 13: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/13.jpg)
Data Visualization Nodes
![Page 14: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/14.jpg)
InnerJoin
![Page 15: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/15.jpg)
Exercise-1
![Page 16: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/16.jpg)
Data Manipulation • Columns:
• binning• replace• filtersmissingvalues
• Rows:• filtering• sampling• partitioning
• Matrix:• Transpose
![Page 17: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/17.jpg)
Exercise-2
![Page 18: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/18.jpg)
Data TransformationStringManipulation
![Page 19: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/19.jpg)
Exercise-3StringManipulation
![Page 20: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/20.jpg)
Connect to Database
![Page 21: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/21.jpg)
Write to Database
![Page 22: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/22.jpg)
Exercise-4
![Page 23: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/23.jpg)
Missing Value
![Page 24: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/24.jpg)
Detect Outliers
Source ::https://towardsdatascience.com/a-brief-overview-of-outlier-detection-techniques
![Page 25: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/25.jpg)
Detect Outliers
Source ::https://towardsdatascience.com/a-brief-overview-of-outlier-detection-techniques
![Page 26: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/26.jpg)
Detect Outliers
![Page 27: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/27.jpg)
PredictiveAnalyticProcess
http://www.proglobalbusinesssolutions.com/six-steps-in-crisp-dm-the-standard-data-mining-process/
![Page 28: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/28.jpg)
Churn prediction�
Churn prediction หรอ การทานายลกษณะลกคาทกาลงจะยกเลกบรการ
churn คอ การทลกคา สมาชก (Subscribers) หรอ ผใชงาน (Users) ทซอสนคาหรอใชบรการอย หรอ มการซอหรอใชบรการอยเปนประจา เกดเปลยนใจหยดใชหยดซอ หรอ ยกเลกบรการกบคณ ตดสนใจยกเลกสญญา
https://www.brandingchamp.com/customer-churn-%E0%B8%84%E0%B8%B7%E0%B8%AD-%E0%B8%AD%E0%B8%B0%E0%B9%84%E0%B8%A3/
![Page 29: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/29.jpg)
Churn prediction
2Steps1. TrainingModel2. DeployModel
• CustomerData• ContractData.csv
• OperationData• CallsData.xlsx
Churn=0customerremainedwithcontractChurn=1customerquitcontract
![Page 30: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/30.jpg)
Churn prediction
![Page 31: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/31.jpg)
Churn prediction
![Page 32: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/32.jpg)
Churn prediction
![Page 33: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/33.jpg)
Churn prediction
![Page 34: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/34.jpg)
Churn prediction
![Page 35: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/35.jpg)
Churn predictionTrain Model
![Page 36: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/36.jpg)
Churn predictionTrain Model
![Page 37: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/37.jpg)
Churn predictionEvaluate Model
![Page 38: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/38.jpg)
Churn prediction
![Page 39: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/39.jpg)
Churn predictionEvaluate ModelScoretheModelRemembertousethePredictornodeappropriate foryourmodel!Evaluatepredictions basedonconfusionmatrixandROC.
![Page 40: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/40.jpg)
ROC CurveROC curve ยอมาจาก Receiver operating characteristic curve
![Page 41: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/41.jpg)
Churn predictionDeploy Model
![Page 42: What is KNIME? · What is KNIME? • KNIME = Konstanz Information Miner • Developed at University of Konstanz in Germany • Desktop version available free of charge (Open Source)](https://reader034.vdocuments.us/reader034/viewer/2022052520/6085fd9af03f687d7d7eb50c/html5/thumbnails/42.jpg)
Churn prediction
Training Video