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

Module name: Data warehouses
Module code: W4-IN-N2-20-F-HDiAMP
Programme code: W4-N2IN19.2021
Semester:
  • winter semester 2023/2024
  • summer semester 2022/2023
  • winter semester 2022/2023
  • summer semester 2021/2022
Language of instruction: Polish
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]
Has knowledge of analytical data processing. [M_001]
 K_W09 [4/5]
Has knowledge about architecture of data warehouses. [M_002]
 K_W02 [3/5]
Is able to use appropriate tools to prepare data that will be used to feed the warehouse, knows the ETL process. [M_003]
 K_W09 [3/5] K_U01 [4/5] K_U09 [3/5]
Using appropriate tools is able to perform advanced data analysis, including OLAP. [M_004]
 K_W09 [3/5]
Using specialized tools is able to create advanced data reports and visualizations. [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 works [W_002]
Raport preparation and presentation in specified deadline, as a verification of skills acquired during implementation of laboratory works.
 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]
Forwarding knowledge in verbal form using audio-visual media and other written didactic aids. Activation of students by asking questions regarding the considered topics.
 15
Familiarize the subject of the lecture, investigation considered topics.
 5 Test [W_001]
laboratory classes [Z_002]
Preparation of students for solving laboratory tasks with an indication of the methodology and the order of performed activities.
 30
Preparation for the laboratory works, independent solution of laboratory tasks by students, preparation of reports.
 70 Raport presentation for laboratory works [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)