Moses - DW Data Warehousing and Business Intelligence

Display language

Diese Modulbeschreibung gilt nicht im aktuellen Semester.

Die Modulbeschreibung gilt nur für den Zeitraum SoSe 2022 - SoSe 2023. Die Version für das aktuelle Semester (SoSe 2024) finden Sie hier: Modulbeschreibung des SoSe 2024

Module / Version:
#40399 / #10

Validity:
SoSe 2022 - SoSe 2023

Default display language:
English

Module title:
DW Data Warehousing and Business Intelligence

Credits:
6

Responsible person:
Markl, Volker

Grading:
benotet

Type of exam:
Portfolioprüfung

Zugehörigkeit

Faculty:
Fakultät IV

Institute:
Institut für Softwaretechnik und Theoretische Informatik

Area of expertise:
34351500 FG Datenbanksysteme und Informationsmanagement (DIMA)

Prüfungsausschuss:
No information

Kontakt

Office:
EN 7

Contact person:
Soto, Juan

E-mail address:
sekr@dima.tu-berlin.de

Website:

https://www.tu.berlin/dima

Learning Outcomes

Data Warehouses (DWH) store big amounts of data in databases designed with a focus in data analysis. Business Intelligence is the process of extracting information from DWH with the purpose of enabling decision support. In this course students will learn about different DWH architectures and processes. They will be able to differentiate between "normal" databases and DWH. Students will learn basics of dimensional data modelling and gain practical MDX, OALP, and SQL coding experience in addition to understanding of ETL processes and selected methods for data analysis. Furthermore, students will have the opportunity to work with datasets in a data warehouse environment and apply learned skills in practice using tools such as IBM DB2, MYSQL, Pentaho Data Integration tool, and KNIME

Content

The comprehensive thematic of this course is organized in two blocks. In the first block, the development and management methods for DWH in relational databases are presented (e.g., architectures, multidimensional data model, ETL-process, OLAP operations, multidimensional queries, Bitmap-index, view materialization). In the second block, topics in knowledge discovery and data mining in DWH are presented (e.g., discovering frequent patterns, associations rules, clustering and classification, prediction). In addition, current research and recent trends in DWH are also addressed (with guest lecturers)

Module Components

Pflichtteil:

All Courses are mandatory.

Course Name	Type	Number	Cycle	Language	SWS	VZ
Data Warehousing und Business Intelligence	IV	0434 L 462	WiSe	English	4

Workload and Credit Points

Data Warehousing und Business Intelligence (IV):

Workload description	Multiplier	Hours	Total
Lecture Preparation	15.0	3.0h	45.0h
Reviews in Preparation of the written exam	1.0	15.0h	15.0h
Homework Assignments	1.0	60.0h	60.0h
(Weekly) Labs Exercises	15.0	1.0h	15.0h
Lecture	15.0	3.0h	45.0h
			180.0h(~6 LP)

The Workload of the module sums up to 180.0 Hours. Therefore the module contains 6 Credits.

Description of Teaching and Learning Methods

The theoretical part of the course will be covered in weekly lectures, together with practical exercises and tutorial sessions to strengthen the content. Homework exercises to improve the acquisition of theoretical concepts as well as practical experience with a DBMS. Both the text book and supplementary literature for this course are in English language.

Requirements for participation and examination

Desirable prerequisites for participation in the courses:

Students with interest in databases and information systems who have successfully completed ISDA (Informationssysteme und Datenanalyse) and DBPRA (Datenbankpraktikum) or their respective course equivalences. The course will be given in English language, thus fluency in English is required!

Mandatory requirements for the module test application:

This module has no requirements.

Module completion

Grading

graded

Type of exam

Portfolio examination

Type of portfolio examination

100 Punkte insgesamt

Language

English

Test elements

Name	Points	Categorie	Duration/Extent
(Deliverable Assessment) Homework Assignment	30	written	10 h per assignment (about 3 pages)
(Examination) Quiz 1: Datawarehouses	35	written	60 minutes
(Examination) Quiz 2: Data Analysis	35	written	60 minutes

Grading scale

Notenschlüssel »Notenschlüssel 2: Fak IV (2)«

Gesamtpunktzahl	1.0	1.3	1.7	2.0	2.3	2.7	3.0	3.3	3.7	4.0
100.0pt	95.0pt	90.0pt	85.0pt	80.0pt	75.0pt	70.0pt	65.0pt	60.0pt	55.0pt	50.0pt

Test description (Module completion)

The final grade according to § 68 (2) AllgStuPO will be calculated with the faculty grading table 2. (Die Gesamtnote gemäß § 68 (2) AllgStuPO wird nach dem Notenschlüssel 2 der Fakultät IV ermittelt.)

Duration of the Module

The following number of semesters is estimated for taking and completing the module:
1 Semester.

This module may be commenced in the following semesters:
Wintersemester.

Maximum Number of Participants

The maximum capacity of students is 30.

Registration Procedures

Students are required to register for the course in the official TUB examination system within six weeks after commencement of the first lecture or when the first graded assignment is due, whichever happens to be first

Recommended literature
[1] C. S. Jensen, T. B. Pedersen, C. Thomsen. Multidimensional Databases and Data Warehousing. Morgan and Claypool Publishers. 2010
[2] R. Kimball, et al.: The Data Warehouse Lifecycle Toolkit, Wiley, 1998.
[3] W. H. Inmon: Building the Data Warehouse. 4th Edition, Wiley, 2005.

Assigned Degree Programs

Semester:

Zeige auch ausgelaufene Studiengänge und StuPOs

This module is used in the following Degree Programs (new System):

	Studiengang / StuPO	StuPOs	Verwendungen	Erste Verwendung	Letzte Verwendung
This module is not used in any degree program.

Miscellaneous

No information

DW Data Warehousing and Business Intelligence