CloseHelpPrint
Kies de Nederlandse taal
Course module: 201300108
201300108
Business Intelligence and Information Technology
Course infoSchedule
Course module201300108
Credits (ECTS)15
Course typeModule
Language of instructionEnglish
Contact persondr. C. Amrit
E-mailc.amrit@utwente.nl
Lecturer(s)
PreviousNext 4
Lecturer
dr. C. Amrit
Contactperson for the course
dr. C. Amrit
Lecturer
dr.ir. T.A. van den Broek
Lecturer
dr. J.M.G. Heerkens
Examinator
prof.dr. M.E. Iacob
Academic year2016
Starting block
2A
Application procedureYou apply via OSIRIS Student
Registration using OSIRISYes
Learning goals
This can be refined in the following sub-goals corresponding to the three module components, as follows:
1.       Students can design a simple data base, populate it with data and query it in order to retrieve data. These goals are important since the core of any enterprise information system is the database.
2.       Students can analyze information generated by information systems, and stored in data warehouses, and can use it to monitor and evaluate business performance and determine/shape an organization’s business strategy (i.e., the so-called business intelligence).
3.       Students can design and develop/implement enterprise information systems, which facilitate, support and/or automate the execution and analysis/monitoring of business processes.
Considering these three main directions (i.e., module components), the learning objectives can be further refined for each module component as follows:        

Database systems: The student
  • Can design data models, database schemas, and SQL queries.
  • Understands and can apply data management and web related technologies (e.g., MySQL).
  • Has hands-on knowledge on how to design, access and use a database for Web based applications ·        
Business intelligence: The student
  • Can explain the need for computerized support of managerial decision making (Level: 2)
  • o   Can explain the business intelligence (BI) methodology and concepts and can relate them to decision support systems (DSS)
  • o   Can apply the basic definitions and concepts of data warehouses
  • o   Can evaluate and compare the different types of data warehousing architectures  
  • o   Can explain the process of developing and managing data warehouses and collecting data for business intelligence applications
  • o   Can analyse the all-encompassing nature of performance management (BPM) and apply some of the best practices in planning and management reporting
  • o   Can evaluate the objectives and benefits of business analytics and data mining, recognize the wide range of applications of data mining, and apply some of these techniques in relatively simple concrete problems
  • o   Can apply, compare and evaluate the theoretical knowledge of BI in designing and implementing BI applications. ·        
Enterprise modelling: The student
  • Can explain and relate concepts, modelling languages, methods, techniques, and tools related to enterprise architecture, business processes and workflow management
  • Can explain the design/architecture, functionality and usage of process-aware information systems
  • Can apply the above mentioned concepts in solving relatively simple business problems
  • Can design and automate a process model starting from an informal description of a business problem.
  • Can analyse an enterprise architecture/workflow/process (validation, verification, and performance analysis).
Content
This module lies at the border between Business and IT. More exactly, all topics included in the module reveal yet another aspect related to the usage of IT in organizations. Another core idea behind this module is that students learn how to design information systems that provide solutions for a business problem. To this end, the idea we promote is that systems must be designed to serve the business and its needs, as opposed to the idea that organizations must use information systems. To summarize, for the TBK program this is the IT module of the program. This is where students learn what information systems are and how they can be designed and used to increase business performance and in particular operational process performance. Here they hear for the first time about specific technologies (e.g., BI, business process automation, data mining, or DBMS), specification languages, how systems “are made” and what are they good for. They learn how to build a data base, a web application and a business intelligence dashboard. They learn how to analyse a business problem and look for possible solutions in IT.
The BIIT module aims to cover the following topics:
• Data bases: Relational databases, SQL, ER model; Foreign key; primary key, understanding the database design process
• Business Intelligence & Business Analytics:  Introduction, definition, relation with automated decision support systems, BI architectures, evolution of BI, Major BI vendors & BI implementation
• Data warehousing: data marts, DW architectures,  ETL, DW design, multidimensional modelling, OLAP, slice, dice, etc., DW implementation (do’s & don’ts)
• Business performance management: Performance monitoring, Performance measurement, Balance Scorecard and performance, e.g. performance of processes (the process perspective in BSC), Lean, Six Sigma
• Data mining: process, techniques, tools
• Business intelligence tools (Tableau, Weka)
• Text mining, Web mining, Social media, Big data and other trends process, techniques, tools
• Business process modelling: Motivation and definitions
• Business process modelling notation (BPMN) and other modelling languages
• Business process lifecycle (Total Quality Management (Six Sigma, Lean), Business process redesign)
• Workflow/process patterns
• Workflow systems and workflow analysis, Activity diagrams, petri nets
• Process-aware information systems
• Process choreographies and orchestrations
• Enterprise architecture: Motivation and definitions, modelling foundation, enterprise architecture framework and lifecycle (Zachman. TOGAF, etc.)
Assumed previous knowledge
Gewenst: Module 1, Module 2
Required materials
Course material
ER Diagrams: •The original paper introducing the Entity Relation Model is available at http://www.csc.lsu.edu/news/erd.pdf •A short description is also accessible in Wikipedia including a comparison of the different graphical notations.
Course material
SQL: •A good tutorial available at http://www.w3schools.com/sql/ •The content of the tutorial explains other parts of SQL which I will introduce later on. •Here another one http://www.sqlcourse.com/select.html
Course material
SQL: •The original paper introducing the Entity Relation Model is available at http://www.csc.lsu.edu/news/erd.pdf •A short description is also accessible in Wikipedia including a comparison of the different graphical notations.
Course material
Normalisation: •More information about normalization theory is accessible on the web at the following links http://databases.about.com/od/specificproducts/a/normalization.htm http://support.microsoft.com/kb/283878
Course material
E. Turban et al., Business Intelligence A managerial Approach, 3rd edition, Pearson education, ISBN-13: 9780133051056
Course material
S. Chaudhuri, U. Dayal,and V. Narasayy, An Overview of Business Intelligence Technology, communications of the acm, august 2011, vol. 54, no. 8, p. 88-98. (available via Blackboard; pdf file)
Course material
Business Process Management: •Mathias Weske , Business Process Management: Concepts, Languages, Architectures, Springer, 2007, ISBN10 3540735216, ISBN13 9783540735212. •Stephen A. White, Introduction to BPMN, White paper IBM Corporation
Book
Hans Heerkens, Arnold van Winden; Geen probleem: Een aanpak voor alle bedrijfskundige vragen en mysteries, ISBN 9789081838306
Book
Business Research Methods, by Donald Cooper & Pamela Schindler. A few selected articles about research strategies, ISBN 9780071289221
Reader
Kansrekening Dictaat (also used in M1)
Reader
Statistiek Dictaat (nieuw)
Book
D. Boddy, Management. An introduction 978-0-273-73896-1
Recommended materials
Book
Michael J. Hicks, Problem Solving and Decision Making 2e, ISBN-13: 9781861526175 / ISBN-10: 1861526172
Instructional modes
Lecture
Presence dutyYes

Practical
Presence dutyYes

Project
Presence dutyYes

Self study with assistance

Self study without assistance

Tutorial
Presence dutyYes

Tests
Statistics & Probability

Remark
One MC written test

Research Methodology

Remark
One MC written test

Databases & Business Intelligence

Remark
One MC written test

Bus. Process Mngt & Enterp. Architecture

Remark
One MC written test

Project and Skills

Remark
Assignments graded separately. Final grade is an average of assignment grades.

Skills

CloseHelpPrint
Kies de Nederlandse taal