Data warehouses and reporting services - course description

General information

Course name	Data warehouses and reporting services
Course ID	11.3-WE-BizElP-DWandRS-Er
Faculty	Faculty of Computer Science, Electrical Engineering and Automatics
Field of study	E-business
Education profile	practical
Level of studies	First-cycle Erasmus programme
Beginning semester	winter term 2022/2023

Course information

Semester	3
ECTS credits to win	5
Course type	obligatory
Teaching language	english
Author of syllabus	dr hab. inż. Marek Kowal, prof. UZ

Classes forms

The class form	Hours per semester (full-time)	Hours per week (full-time)	Hours per semester (part-time)	Hours per week (part-time)	Form of assignment
Lecture	15	1	-	-	Credit with grade
Laboratory	30	2	-	-	Credit with grade
Project	15	1	-	-	Credit with grade

Aim of the course

Familiarizing students with the concept of a data warehouse and presenting the data life cycle in a data warehouse. Shaping students' skills in designing and implementing a data warehouse. Learning methods of creating Business Intelligence reports using complex analytical queries and multidimensional analysis. Developing data visualization skills for the needs of reports.

Prerequisites

Databases

Scope

Data warehouse architecture. Data life cycle in data warehouses. Dimensional data model. Data cubes. Row and column databases. Analytical queries. Multidimensional data analysis and reporting using Business Intelligence methods. Management dashboards.

Teaching methods

Lecture - conventional lecture using a video projector.
Laboratory - practical exercises in the computer laboratory.
Project - project implementation in a computer laboratory.

Learning outcomes and methods of theirs verification

Outcome description	Outcome symbols	Methods of verification	The class form

Assignment conditions

Lecture - the passing criteria is to obtain positive grades from tests carried out at least once in a semester.

Laboratory - the passing criterion is to obtain positive marks for laboratory exercises and tests.

Project - positive assessment of the project or projects realized during the semester

Final mark components = lecture: 30% + teaching laboratory: 40% + project: 30%

Notes

Modified by dr hab. inż. Marek Kowal, prof. UZ (last modification: 29-04-2022 19:38)

Generate PDF for this page