Data warehouses Field of study: Computer Science
Programme code: W4-S2INA19.2021

Module name: Data warehouses
Module code: W4-INA-S2-20-F-HDiAM
Programme code: W4-S2INA19.2021
Semester:
  • summer semester 2022/2023
  • winter semester 2022/2023
  • summer semester 2021/2022
Language of instruction: English
Form of verification: course work
ECTS credits: 4
Description:
The aim of the module is to familiarize students with issues related to architecture of data warehouses, data processing using OLAP technology and advanced reporting tools.
Prerequisites:
(no information given)
Key reading:
1. Jarke M., Lenzerini M., Vassiliou Y., Vassiliadis P.: Hurtownie danych. Podstawa organizacji i funkcjonowania, WSiP, Warszawa 2003. 2. Poe V., Klauer P., Brobst S.: Tworzenie hurtowni danych. WNT, Warszawa 2000. 3. Han J., Kamber M.: Data Mining Concepts and Techniques, Morgan Kaufmann, 2011 4. Todman C.: Projektowanie hurtowni danych. WNT, Warszawa 2003.
Learning outcome of the module Codes of the learning outcomes of the programme to which the learning outcome of the module is related [level of competence: scale 1-5]
The student knows analytical data processing. [M_001]
 K_W09 [4/5]
The student knows the architecture of data warehouses. [M_002]
 K_W02 [3/5]
The student can use tools to prepare data that will feed the warehouse and knows the ETL process. [M_003]
 K_W09 [3/5] K_U01 [4/5]
The student uses tools enabling to perform advanced data analysis, including OLAP. [M_004]
 K_W09 [3/5] K_U09 [4/5]
The student uses specialised tools enabling to create advanced data reports and visualisations. [M_005]
 K_U09 [3/5]
Type Description Codes of the learning outcomes of the module to which assessment is related
Test [W_001]
Knowledge verification is based on the content presented during lectures. It consists of questions regarding considered issues.
 M_001 M_002 M_004
Raport presentation for laboratory tasks [W_002]
Student prepare a presentation in specified deadline as a verification of skills acquired during implementation of laboratory tasks.
 M_001 M_003 M_004 M_005
Form of teaching Student's own work Assessment of the learning outcomes
Type Description (including teaching methods) Number of hours Description Number of hours
lecture [Z_001]
The lectures are presented in verbal form with the use of audiovisual media and other written educational aids. The students are encouraged by asking them questions and giving basic tasks regarding the considered topics.
 15
The students familiarise with the subject of lectures by investigating considered topics.
 5 Test [W_001]
laboratory classes [Z_002]
The classes prepare the students for completing laboratory tasks, emphasising the method and the sequence of operations.
 30
The students study for the laboratory tasks, complete them individually and prepare the reports.
 70 Raport presentation for laboratory tasks [W_002]
Attachments
Module description (PDF)
Information concerning module syllabuses might be changed during studies.
Syllabuses (USOSweb)
Semester Module Language of instruction
(no information given)