====== Knowledge Engineering and Business Intelligence ====== ---- ===== News ===== === Dear students, === We will have an additional lecture on **Wednesday, 3rd of June, 12:45pm - 2:00pm**. The link is [[https://fhnw.zoom.us/j/95153387074]] We will give a short repetition of the topics and how they relate to each other. Furthermore, there will be a Q&A session. Best regards, Knut /* === Dear students, === For the lecture on 11th of May 2020 please use this room: [[https://fhnw.zoom.us/j/95153387074]]. Best regards, Knut Hinkelmann === Dear students, === Good news: We start definitely on **20th of April at 2pm**. To participate in the lecture, please join us in Zoom. The {{ :didattica:magistrale:kebi:ay_1920:orario_2_semestre_19-20_-_kebi-2.pdf |schedule}} is updated. Best regards, Knut Hinkelmann\\ Holger Wache */ ---- ===== General Info ===== **Teachers**: * Knut Hinkelmann * Holger Wache **Schedule**: * {{:didattica:magistrale:kebi:ay_1920:orario_2_semestre_19-20_-_kebi-2.pdf |Knowledge Engineering and Business Intelligence}} **ESSE3 Link** * [[https://didattica.unicam.it/Guide/PaginaADErogata.do?ad_er_id=2018*N0*N0*S2*12329*8709&ANNO_ACCADEMICO=2019&mostra_percorsi=S|Knowledge Engineering and Business Intelligence - AY 2019/2020]] ---- ===== Course Objectives ===== == Supporting Knowledge-Intensive Processes == Knowledge-intensive processes are more unstructured processes with a lot of involvements of users with their experience. Supporting such processes at their levels requires modelling and enacting several different forms of knowledge. In general more explicit represented knowledge allows better support. But different forms of knowledge need different intuitive and adequate representations and inferences. After completion of this module, the participants will be able to assess which kind of knowledge representation and reasoning is adequate and are able to develop appropriate knowledge-based systems. They can value the advantages of knowledge-based systems with respect to their costs. Business Intelligence is concerned with supporting business decisions with facts. It supports business actors in turning data into knowledge that helps to make the right decisions.The module looks at different kinds of decisions (and hence requirements), at different kinds of data and different kinds of tools required to distill knowledge out of data. ---- ===== Course Contents ===== * Introduction: Knowledge in processes * Decision Tables * Rules * Textual represented rule (i.e. Horn clauses) * Forward and backward chaining * Data-driven and Goal-oriented * Negation-as-failure * Object-centred Systems * F-Logic/Objectlogic * Fuzzy Logic * Human-interpretation vs. machine-interpretation * Graphical modeling * Ontology-based modeling * Machine Learning: Learning Decision Trees * Case-Based Reasoning * Neuronal Networks * Business Intelligence * Business Performance Management * Data Warehouse * Reporting and Data Analysis ---- ===== Study material ===== **Course Material** * {{ :didattica:magistrale:kebi:ay_1920:ke-0-organization.pdf |Organisation}} * Lecture "Introduction" * Slides: {{ :didattica:magistrale:kebi:ay_1920:ke-1-introduction.pdf |Introduction}} * {{ :didattica:magistrale:kebi:ay_1920:davenport_2010_process_management_for_knowledge_work.pdf |Davenport, T. H. (2010). Process Management for Knowledge Work. In J. vom Brocke & M. Rosemann (Eds.), Handbook on Business Process Management 1 (pp. 17–36). Berlin, Heidelberg: Springer.}} * [[https://fhnw.zoom.us/rec/share/wfFff6r9p3JLX4nL-hjxfYkLJNS-aaa813IX8qEJmhyq_-EiTB7c7zNzmqTTaPJC | Recording]] (Password on request) * Homework: {{ :didattica:magistrale:kebi:ay_1920:exercise_knowledge_types_for_admissiondocx.pdf |Types of Knowledge}} * Lecture "Knowledge in Processes" * Slides: {{ :didattica:magistrale:kebi:ay_1920:ke-2_knowledge_and_processes.pdf |Decision-Aware Business Processes}} * Example: {{ :didattica:magistrale:kebi:ay_1920:example_decision-aware_process_modeling.pdf |Decision-Aware Business Process }} * Lecture "Decision Tables" * Slides: {{ :didattica:magistrale:kebi:ay_1920:ke-3-decisontables.pdf |Decision Tables - DMN}} * Reading: [[http://blog.maxconsilium.com/2014/09/introduction-to-decision-model-notation.html|Introduction into DMN]] * Exercise: {{ :didattica:magistrale:kebi:ay_1920:exercise_decision_table_reduction.pdf |Reduction of Decision Tables}}, {{ :didattica:magistrale:kebi:ay_1920:dmn_decision_table_reimbursement.xlsx |Sample Table}} * Exercise and Solution: {{ :didattica:magistrale:kebi:ay_1920:exercise_decision_modeling_admission_with_solution.pdf |Decision Modelling for Admission}}, {{ :didattica:magistrale:kebi:ay_1920:eligibility_decision_table.zip |DMN file of the decision table}} * Download: [[https://camunda.com/download/modeler/|Camunda Workflow and Decision Modeler]] * [[https://camunda.com/dmn/simulator/|Camunda Decision Simulator]] * [[https://fhnw.zoom.us/rec/share/tI8sErWt7UFOY7fm4WHzCrchOZ7ceaa80SQYrPAMxB5up0e7_MJjwTXua_Jfc9aB | Recording]] (Password on request) * Lecture “Rule-based Systems” * Whiteboard: [[https://drive.google.com/drive/folders/17Fg9Tvu0srPEFpPE3jbnf7xcSVakziGk?usp=sharing | Holger's Whiteboard]] * Slides: {{ :didattica:magistrale:kebi:ay_1920:ke-4-logic_programming.pdf |Rule-based Systems}} * Reasoning example: {{ :didattica:magistrale:kebi:ay_1920:ke-4-logic_programming-reasoningexample_ancestor.pdf |ancestor}} * Exercise: {{ :didattica:magistrale:kebi:ay_1920:ke-4-1-exercise_university.pdf |University}} and Solution * Exercise: {{ :didattica:magistrale:kebi:ay_1920:ke-4-2-exercise_family_rules.pdf |Family}} and {{ :didattica:magistrale:kebi:ay_1920:ke-4-2-exercise_family_rules_solution.pdf |Solution}} * Exercise: Further {{ :didattica:magistrale:kebi:ay_1920:ke-4-3-exercise_smallexamples.pdf |small examples}} and {{ :didattica:magistrale:kebi:ay_1920:ke-4-3-exercise_smallexamples_solution.pdf |Solution}} * Exercise: {{ :didattica:magistrale:kebi:ay_1920:ke-4-5-exercise_minisudoku.pdf |Mini Sudoku}} and {{ :didattica:magistrale:kebi:ay_1920:ke-4-5-exercise_minisudoku_solution.pdf |Solution}} * Exercise: {{ :didattica:magistrale:kebi:ay_1920:ke-4-7-exercise_friendship.pdf |Friendship}} and {{ :didattica:magistrale:kebi:ay_1920:ke-4-7-exercise_friendship_solution.pdf |Solution}} * {{ :didattica:magistrale:kebi:ay_1920:ke-4-homeexercise_masterdecisions.pdf |Home Work}} with {{ :didattica:magistrale:kebi:ay_1920:ke-4-homeexercise_masterdecisions_solution.pdf |Solution}} * Nice browser-based [[http://swish.swi-prolog.org|Prolog Engine]] * [[https://fhnw.zoom.us/rec/share/ue5SCJft7m5LUoWOx2CCfIgzGaLPT6a8gCdP-qIJzE_zgHCGo64xcU33DOcZoXdy | Recording first day]] (Password on request) * [[https://fhnw.zoom.us/rec/share/5e5MC5uv_FNOE4nQtV_Va6Q9JKHHaaa81HcYq_Vcyx6pHSNSg10WAaOC4oym8gIf | Recording second day]] (Password on request) * Lecture “Forward- and Backward Chaining” * Slides: {{ :didattica:magistrale:kebi:ay_1920:ke-5_fc_vs_bc.pdf |Forward- and Backward Chaining}} * Lecture “Knowledge Nets and RDF” * Whiteboard: [[https://drive.google.com/drive/folders/17Fg9Tvu0srPEFpPE3jbnf7xcSVakziGk?usp=sharing | Holger's Whiteboard]] * Slides: {{ :didattica:magistrale:kebi:ay_1920:ke-6-rdf_knowledgenets.pdf |Knowledge Nets and RDF}} * Exercise: {{ :didattica:magistrale:kebi:ay_1920:ke-6-1-exercise-rdf-graph.pdf |RDF Graphs}} and {{ :didattica:magistrale:kebi:ay_1920:ke-6-1-exercise-rdf-graph-solution.pdf |Solution}} * Exercise: {{ :didattica:magistrale:kebi:ay_1920:ke-6-2-exercise-rdf-schema.pdf |RDF Schema}} and {{ :didattica:magistrale:kebi:ay_1920:ke-6-2-exercise-rdf-schema-solution.pdf |Solution}} * Exercise: {{ :didattica:magistrale:kebi:ay_1920:ke-6-3-exercise-rdfs-inferences.pdf |RDF Schema Inferences}} and {{ :didattica:magistrale:kebi:ay_1920:ke-6-3-exercise-rdfs-inferences-solution.pdf |Solution}} * [[https://fhnw.zoom.us/rec/share/z9BTDKPRqD9Ie9aRq03eX7xxAr3-eaa81nca-_UMxVlv1rl8aSGKSQR9ICh2B2s | Recording 1]] (Password on request) * [[https://fhnw.zoom.us/rec/share/-f1HP7PvsTNOS6_JxBrhBJckObvlX6a82yga8vRexUlUNTDz59mEFgeKKDzLQoPW | Recording 2]] (Password on request) * Lecture “Fuzzy logic” * Whiteboard: [[https://drive.google.com/drive/folders/17Fg9Tvu0srPEFpPE3jbnf7xcSVakziGk?usp=sharing | Holger's Whiteboard]] * Slides: {{ :didattica:magistrale:kebi:ay_1920:ke-7-fuzzylogic.pdf |Fuzzy Logic}} * Exercise: {{ :didattica:magistrale:kebi:ay_1920:ke-7-1-exercise_define_fuzzy_set.pdf |Fuzzy Sets}} and {{ :didattica:magistrale:kebi:ay_1920:ke-7-1-exercise_define_fuzzy_set_solution.pdf |Solution}} * Exercise: {{ :didattica:magistrale:kebi:ay_1920:ke-7-2-exercise_fuzzy_set_operations.pdf |Fuzzy Set Operations}} and {{ :didattica:magistrale:kebi:ay_1920:ke-7-2-exercise_fuzzy_set_operations_solution.pdf |Solution}} * Exercise: {{ :didattica:magistrale:kebi:ay_1920:ke-7-3-credit_analysis.pdf |Credit Analysis}} * [[https://fhnw.zoom.us/rec/share/vslbbO7Ux11ORp3I1lDEQv87G8f5eaa81SQeqPUOyx2PoYG-nS2U2X9jEULsHTS7 | Recording]] (Password on request) * Lecture “Ontology Engineering” * Slides: {{ :didattica:magistrale:kebi:ay_1920:ke-8-1_ontology_engineering.pdf |Ontology Engineering}} * Exercise: {{ :didattica:magistrale:kebi:ay_1920:exercise_-_business_process_ontology.pdf |Business Process Ontology}} * {{ :didattica:magistrale:kebi:ay_1920:process_and_university_ontology.zip |University and Business Process Ontologies to open in Protege}} * Literature: Noy, N. F., & McGuinness, D. L. (2001). [[http://protege.stanford.edu/publications/ontology_development/ontology101.pdf | Ontology development 101: A guide to creating your first ontology.]] Stanford Knowledge Systems Laboratory Technical Report KSL-01-05. * Download: [[https://protege.stanford.edu/products.php |Protege: Desktop Version (Platform independent or Windows)]] * [[https://fhnw.zoom.us/rec/share/-osuAY3N32ROSIX95FmCQKILELj_eaa813MYrqcKmE7MK_ID2N7N1hk_ebGcAJ9e | Recording]] (Password on request) * Lecture “Modelling and Metamodelling” * Slides: {{ :didattica:magistrale:kebi:ay_1920:ke-9-1_modeling_and_metamodeling.pdf |Modelling and Metamodelling}} * Download: [[https://www.adoxx.org/live/download-guided |ADOxx Model Engineering Environment]] * Modeling Languages: {{ :didattica:magistrale:kebi:ay_1920:bpmn_and_kwd_library.zip |BPMN and KWD Libraries for import into ADOxx Development Tool}}; {{ :didattica:magistrale:kebi:ay_1920:graphrep.zip |graphrep for descretionary task}} * [[https://fhnw.zoom.us/rec/share/-v0uK-jepiRJYs_N506BdYR6E8PGT6a80yZL-vIJn0rc_nOOIt5-fNQoZlbRk_PX | Recording]] (Password on request) * Lecture “Ontology-based Metamodelling” * Slides: {{ :didattica:magistrale:kebi:ay_1920:ke-10-1_ontology-based_metamodeling.pdf |Ontology-based Metamodelling}} * Practice Session: {{ :didattica:magistrale:kebi:ay_1920:practice_session_-_ontology-based_enterprise_modeling_for_design.pdf |Agile Ontology-based Modelling for Design}} * Literature: [[https://docenti.unicam.it/ApriMat.aspx?id=12200 | Hinkelmann et al. (2016). A new paradigm for the continuous alignment of business and IT: Combining enterprise architecture modelling and enterprise ontologies]] * Literature: [[https://docenti.unicam.it/ApriMat.aspx?id=12248 | Hinkelmann et al. (2018). Ontology-based Metamodelling.]] * [[https://fhnw.zoom.us/rec/share/2N1eIJfgsUNORY3Us0bff7wtMIG-eaa813Qd_fdbxBtoBxSRE-pJe3jvJ18FAMs6 | Recording]] (Password on request) * Lecture "Symbolic Machine Learning" * Slides: {{ :didattica:magistrale:kebi:ay_1920:ke-11-1_machine_learning_idea.pdf |The Idea of Machine Learning}} * Slides: {{ :didattica:magistrale:kebi:ay_1920:ke-11-2_symbolic_learning_-_learning_decision_trees.pdf |Learning Rules}} * Reading Material: {{ :didattica:magistrale:kebi:ay_1718:decision_tree_learning_lecture.pdf |Decision Tree Learning}} * Exercise: {{ :didattica:magistrale:kebi:ay_1718:exercise_learning_carsales.pdf |Auto Traders}} * Exercise: {{ :didattica:magistrale:kebi:ay_1819:exercise_health_insurance_learning.pdf |Health Insurance: Learning Risk Assessment}} * Tool: {{ :didattica:magistrale:kebi:ay_1718:weka_introduction.pdf |WEKA Learning Environment}} * Data Sets: {{ :didattica:magistrale:kebi:ay_1718:datasets.zip |playing tennis, creditworthyness (CSV Files), car sales and Health Insurance (ARFF and Excel file)}} * [[https://fhnw.zoom.us/rec/share/4pRULKHg7CRLTZ3P5lHNS5N5QorEX6a8g3VN_voNzhuNpcU3eD7lXEVoBHCyR4vr | Recording]] (Password on request) * Lecture "Combining Machine Learning and Knowledge Engineering" * Slides: {{ :didattica:magistrale:kebi:ay_1920:ke-12-1_combining_machine_learning_and_knowledge_engineering.pdf |Combining Machine Learning and Knowledge Engineering}} * Example: {{ :didattica:magistrale:kebi:ay_1920:example_machine_learning_and_knowledge.pdf |Machine Learning and Knowledge}} /* Comment Start * Assignment: {{ :didattica:magistrale:kebi:ay_1819:assignment_health_insurance_knowledge.pdf |Health Insurance: Combining Learning with Knowledge Engineering}} Comment End */ * Assignment: {{ :didattica:magistrale:kebi:ay_1920:assignment_health_insurance_knowledge_with_solution.pdf |Health Insurance: Combining Learning with Knowledge Engineering (incl solution)}} * [[https://fhnw.zoom.us/rec/share/zJUkPrLu1khOSYGcwU_harEsRZr9T6a8gXIY_PJcmRsP1giTRCs0iUce7kGkx0OR | Recording]] (password on request) * Lecture “Neuronal Networks” * Whiteboard: [[https://drive.google.com/drive/folders/17Fg9Tvu0srPEFpPE3jbnf7xcSVakziGk?usp=sharing | Holger's Whiteboard]] * Slides: {{ :didattica:magistrale:kebi:ay_1920:ke-13-neuralnetworks.pdf |Neuronal Networks}} * Example for Backpropagation: {{ :didattica:magistrale:kebi:ay_1920:backpropagation.xlsx |Excel}} * Colab example: [[https://colab.research.google.com/drive/1fEmT2AoeGAvfm8_ZIYSEUBU6jsQ8TjSt?usp=sharing |Fraud detection of credit card usage]] * [[https://fhnw.zoom.us/rec/share/wPdHIZWvyUZOWIXS7UftVLAvAYrGeaa8h3dL8vpemUYYe8HrvWy-EtUQq-1DmTvD | Recording]] (Password on request) * Lecture “Case-Based Reasoning” * Slides: {{ :didattica:magistrale:kebi:ay_1920:ke-14-cbr.pdf |Case-Based Reasoning}} * Assignment and Solution: {{ :didattica:magistrale:kebi:ay_1920:assignment-solution_health_insurance_cbr.pdf |CBR for Health Insurance Applications}} /* * Assignment: {{ :didattica:magistrale:kebi:ay_1920:assignment_health_insurance_cbr.pdf |CBR for Health Insurance Applications}} */ * [[https://fhnw.zoom.us/rec/share/6_daf5Db0GFOXaPD0x7wGY0HWdnEX6a81igWqaJbnU9hF8O-FtImq3xRxdtMFwvT | Recording]] (Password on request) * Lecture "Business Intelligence" * {{ :didattica:magistrale:kebi:ay_1920:ke-15_business_intelligence_intro.pdf |Business Intelligence: Making Informed Decisions}} * Lecture: "Business Performance Management" * Slides: {{ :didattica:magistrale:kebi:ay_1920:ke-16_bpm_bsc.pdf |Business Performance Management and Balanced Scorecard}} * Exercise: {{ :didattica:magistrale:kebi:ay_1920:exercise_swissbikes_bsc.pdf |Balanced Scorecard for Swiss Bikes}} * Case: {{ :didattica:magistrale:kebi:ay_1819:swissbikes1-04_engl.pdf |Swiss Bikes}} * Lecture: "Data Warehousing" * Slides: {{ :didattica:magistrale:kebi:ay_1819:ke-12-bi_dwh.pdf |Data Warehousing}} * Book: [[ftp://nozdr.ru/biblio/kolxoz/Cs/CsDb/Kimball%20R.,%20Ross%20M.%20The%20data%20warehouse%20toolkit%20(2ed.,%20Wiley,%202002)(ISBN%200471200247)(449s)_CsDb_.pdf|Kimball, R and Ross, M. (2013). The Data Warehouse Toolkit, 3rd Edition, Wiley and Sons.]] * [[https://fhnw.zoom.us/rec/share/v8ZVJZTL631OTdb91V_YRfJ-Baj6T6a81nAcr_EKnhxv3YjuSBy5FOAE-GSz6VlS | Recording BI, Peformance Management and Data Warehouse]] (Password on request) * Lecture: "Reporting and Online Analytic Processing" * Slides: {{ :didattica:magistrale:kebi:ay_1920:ke-18_reporting_statistics.pdf |BI Tools - Frontend: Reporting and Dashboards}} * Slides: {{ :didattica:magistrale:kebi:ay_1920:ke-19_olap.pdf |BI Tools - Frontend: Online Analytic Processing}} * Poster: {{ :didattica:magistrale:kebi:ay_1819:better_reports_poster_by_ibcs.pdf |Better Reports}} * [[https://fhnw.zoom.us/rec/share/_-p8Fp7B9CRLGYnXz0TnfqoDO47aeaa80yQZ_PQMz0vdMSEJnc9CETm9Kv-yILgP | Recording]] (Password on request) * {{ :didattica:magistrale:kebi:ay_1920:ke-repetition.pdf |Repetition Session}} * [[https://fhnw.zoom.us/rec/share/psorKOHc6lpJfNbquU2GB7cvBYnveaa80CEYrKdexB2AG2LEdo7cypIVpjQVKdPS | Recording]] (Password on request) /* * Lecture: "Online Analytic Processing" */ ---- ===== Exams ===== **Exam Dates A.Y. 2019/2020** * 15th of June 2020 * 30th of June 2020 * 29th of July 2020 * 5th Of October 2020 * 2nd of November 2020 * [[https://docs.google.com/spreadsheets/d/1DAifL0KXWsyr-rwhFDISwb2RKcNn21TBptM1Kqz2Nlo/edit?usp=sharing | Please select an exam slot from the schedule]] **Exam rules**: