SylabUZ
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 2024/2025 |
Semester | 3 |
ECTS credits to win | 6 |
Course type | obligatory |
Teaching language | english |
Author of syllabus |
|
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 |
Familiarizing students with the concept of data warehouses and presenting the data lifecycle in a data warehouse. Developing students' skills in designing and implementing data warehouses. Learning methods of creating Business Intelligence type reports using descriptive and exploratory analytics. Developing skills in data visualization for reporting purposes
Databases
Data warehouse architectures. Data lifecycle in data warehouses. Relational and dimensional data models. Analytical queries in SQL. Data cubes. Row-based and column-based databases. Descriptive and exploratory analytics. Self-service Business Intelligence. Reporting using Business Intelligence methods. Management dashboards.
Lecture - conventional lecture using a video projector.
Laboratory - practical exercises in the computer laboratory.
Project - project implementation in a computer laboratory.
Outcome description | Outcome symbols | Methods of verification | The class form |
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%
Modified by dr hab. inż. Marek Kowal, prof. UZ (last modification: 23-04-2024 15:27)