Data Warehouses and OLAP

Course title

Code

F18L3S157

Study programme

—

Organizer of the study programme (unit, institute, department)

Faculty of Computer Science and Engineering

Degree level (first, second, third cycle)

First cycle

Academic year / semester

8 / Summer

Number of ECTS credits

Teacher

—

Prerequisites for enrolling in the course

Бази на податоци

10.

Course objectives (competences)

Introduction to the organization and manipulation of data stored in data warehouses, as well as the basic operations and algorithms for working with data warehouses. The student will be able to model data warehouses, organize and manipulate data stored in data warehouses, and prepare analytical reports based on that data.

11.

Course content

Basic concepts of data warehouses; Data warehouse architecture; Data flow in data warehouses; Data warehouse modeling; Organization of data in a star schema data warehouse; Data organization in a data warehouse snowflake schema; Hypercubes and multidimensional databases; Technologies for data analysis (OLAP); Extensions to the SQL standard for OLAP needs; The relationship between operational databases and data warehouses; Automatic data updating in data warehouses, data cleansing and aggregation (ETL processes); Organization of distributed data warehouses; Analysis of very large datasets; The practical implementation will cover an examination of leading data warehousing tools and technologies.

12.

Learning methods

lectures, classroom exercises, laboratory exercises, project assignments, homework

13.

Total available time

6 ECTS x 30 hours = 180 hours

14.

Distribution of the available time

30 + 45 + 15 + 15 + 75 = 180 hours

15.

Forms of teaching activities

15.1.	Lectures – theoretical teaching	30 hours
15.2.	Exercises (laboratory, auditory), seminars, team work	45 hours

16.

Other forms of activities

16.1.	Project assignments	15 hours
16.2.	Individual assignments	15 hours
16.3.	Home study	75 hours

17.

Grading

17.1.	Tests	10 points
17.2.	Seminar paper / project (presentation: written and oral)	15 points
17.3.	Activity and participation	10 points
17.4.	Final exam	70 points

18.

Grading criteria (points / grade)

up to 50 points	5 (five) (F)
from 51 to 60 points	6 (six) (E)
from 61 to 70 points	7 (seven) (D)
from 71 to 80 points	8 (eight) (C)
from 81 to 90 points	9 (nine) (B)
from 91 to 100 points	10 (ten) (A)

19.

Requirements for signature and taking the final exam

Completed activities 15, 16

20.

Language of instruction

Macedonian and English

21.

Method of monitoring teaching quality

internal evaluation and survey mechanism

22.

Literature

22.1.	Required literature No. Author Title Publisher Year
22.2.	Additional literature No. Author Title Publisher Year