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 Engineering and Technical Sciences
Field of study	e-business
Education profile	practical
Level of studies	First-cycle Erasmus programme
Beginning semester	winter term 2023/2024

Course information

Semester	3
ECTS credits to win	6
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 life cycle of data in a data warehouse. Developing students' skills in designing and implementing a data warehouse. Learning methods of creating Business Intelligence reports using complex analytical queries and dimensional analysis. Developing data visualization skills for reports.

Prerequisites

Databases

Scope

Data warehouse architecture. Data life cycle in data warehouses. Dimensional data model. Data cubes. Row and column databases. Analytical queries. Dimensional 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: 25-04-2023 16:15)

Generate PDF for this page