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 2023/2024 |
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 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.
Databases
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.
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: 25-04-2023 16:15)