188.429 Business Intelligence
This course is in all assigned curricula part of the STEOP.
This course is in at least 1 assigned curriculum part of the STEOP.

2021W, VU, 4.0h, 6.0EC
TUWEL

Properties

  • Semester hours: 4.0
  • Credits: 6.0
  • Type: VU Lecture and Exercise
  • Format: Distance Learning

Learning outcomes

After successful completion of the course, students are able to...

  • apply analytic methods to extract business insights from vast amounts of data
  • systematically tackle business problems and questions with data
  • evaluate Data Warehousing and Big Data Technologies
  • compare and contrast the benefits and limitations of various data wareousing and big data architectures.
  • define solid processes to answer analytical questions
  • identify concrete business goals and data mining goals
  • perform solid analyses using both supervised as well as unsupervised machine learning techniques including the necessary preprocessing steps
  • critically reflect on results obtained and interpret them

Subject of course

  • Business Intelligence reference architecture
  • OLAP (multidimensionality)
  • Logical Modeling (STAR, SNOWFLAKE)
  • ETL Process
  • Closed-Loop Decision Making
  • Big Data technologies
  • Data Lakes
  • Data Mining - Knowledge Discovery in Databases
  • Patterns and taxonomies
  • Predictive and descriptive rules (classification, regression, association, clustering)
  • Business Intelligence applications

In the data warehousing part, students will learn to:

  • Define a data warehouse in terms of the characteristics that differentiate it from other information systems
  • Describe the benefits of data warehousing
  • Describe the structure of a data warehouse
  • List the features of different types of warehouse data
  • Define types of data models in data warehouses
  • Define the dimensional model and its components
  • Formulate OLAP queries
  • Identify types of schema (Star, Snowflake)
  • consider organisational aspects

In the Data Mining part, students will learn about

  • Definition von Data Mining, Data Mining Prozesse: CRISP-DM, ASUM-DM
  • Data Preprocessing
  • Unsupervised Techniques for Data Analysis, Clustering
  • Supervised Tech´niques for Data Analyses: Classification
  • Evaluation of data analysis processes and models

Teaching methods

  • Lectures: Live-Stream, connection information is provided in TUWEL
  • flipped Classroom
  • Assignments to be elaborated in small groups

Mode of examination

Written and oral

Additional information

  • All required information will be presented in the preliminary lecture (Vorbesprechung)
  • All teaching materials will be available on TUWEL.

 

Preliminary Lecture (Vorbesprechung) 

 

ECTS-Breakdown

18h   Lecture
90h   Exercises
38h   Reading and self-study
4h     Presence for oral and written assignments

150 Hours (= 6 ECTS)

Lecturers

Institute

Course dates

DayTimeDateLocationDescription
Thu12:00 - 14:0007.10.2021 - 27.01.2022 see TUWEL for detailsZoom Lecture (course online only!)
Business Intelligence - Single appointments
DayDateTimeLocationDescription
Thu07.10.202112:00 - 14:00 see TUWEL for detailsZoom Lecture (course online only!)
Thu14.10.202112:00 - 14:00 see TUWEL for detailsZoom Lecture (course online only!)
Thu21.10.202112:00 - 14:00 see TUWEL for detailsZoom Lecture (course online only!)
Thu28.10.202112:00 - 14:00 see TUWEL for detailsZoom Lecture (course online only!)
Thu04.11.202112:00 - 14:00 see TUWEL for detailsZoom Lecture (course online only!)
Thu11.11.202112:00 - 14:00 see TUWEL for detailsZoom Lecture (course online only!)
Thu18.11.202112:00 - 14:00 see TUWEL for detailsZoom Lecture (course online only!)
Thu25.11.202112:00 - 14:00 see TUWEL for detailsZoom Lecture (course online only!)
Thu02.12.202112:00 - 14:00 see TUWEL for detailsZoom Lecture (course online only!)
Thu09.12.202112:00 - 14:00 see TUWEL for detailsZoom Lecture (course online only!)
Thu16.12.202112:00 - 14:00 see TUWEL for detailsZoom Lecture (course online only!)
Thu13.01.202212:00 - 14:00 see TUWEL for detailsZoom Lecture (course online only!)
Thu20.01.202212:00 - 14:00 see TUWEL for detailsZoom Lecture (course online only!)
Thu27.01.202212:00 - 14:00 see TUWEL for detailsZoom Lecture (course online only!)

Examination modalities

  • written assignments and oral reviews of these assigments.
  • written assigment/exam (closed book) - most likely on-line via TUWeL. If the pandemic situation allows face-to-face exams at the scheduled time, we would switch to a face-to-face assignment. In case of low enrollment, this assigment can also be conducted orally (also depending on the development of the pademic situation, most likely on-line.

Exams

DayTimeDateRoomMode of examinationApplication timeApplication modeExam
Thu - 13.01.2022written13.12.2021 00:00 - 06.01.2022 23:55TISSAssignment 4 / Exam (Option 1)
Thu - 03.03.2022written14.01.2022 00:00 - 24.02.2022 23:55TISSAssignment 4 / Exam (Option 2)

Course registration

Begin End Deregistration end
01.10.2021 00:00 14.10.2021 23:55 14.10.2021 23:55

Registration modalities

Acceptance to the course will be by the lecturers. Priority is given to

  1. Students that have this course as a compulsory course (e.g. foundations, core modules) in their curriculum.
  2. Students that have this course as an elective course.
  3. ERASMUS students that have "Business Intelligence" in their learning agreement.
  4. Students that are currently in a bachelor programme of any of the studies mentioned in 1.), and are finishing their studies in the current semester. You will need to contact the lectureres and state your expected graduation, and which master programme you will continue.
  5. If there are still free places afterwards, they will be assigned according to the ranking on the waiting list

Curricula

Literature

No lecture notes are available.

Previous knowledge

Students should have a solid grasp on:

  1. Conceptual database design
  2. Relational database model
  3. Normalization
  4. DBMSs
  5. SQL
  6. Statistics

There will be an opportunity to recap that knowledge at the beginning of the exercises.

Accompanying courses

Continuative courses

Miscellaneous

Language

English