Business Intelligence

Course Description

Dimensional Model, Data Warehouse Architecture, Reporting and Visualization Tools from Data Warehouse, Real-Time Data Warehouses, OLAP, ETL.

Learning Outcomes

  1. define the basic concepts of Business Intelligence and Data Warehouses
  2. apply the princples of DW modelling
  3. employ the basic ETL procedures
  4. operate the basic OLAP technologies
  5. employ basic BI tools
  6. produce a BI tool prototype

Forms of Teaching

Lectures

Students are presented with theoretical foundations of selected topics intertwined with practical examples.

Partial e-learning

Students have access to one online tutorials which serves as a reminder and crash course for required previus knowledge in SQL.

Independent assignments

Students individually work on their project through six homework assignments

Laboratory

Students discuss their own solutions to project tasks with subject teachers.

Grading Method

Continuous Assessment Exam
Type Threshold Percent of Grade Threshold Percent of Grade
Seminar/Project 30 % 50 % 30 % 50 %
Mid Term Exam: Written 0 % 25 % 0 %
Final Exam: Written 30 % 25 %
Exam: Written 50 % 25 %
Exam: Oral 25 %

Week by Week Schedule

  1. Introduction, definitions, motivation
  2. Dimensional model
  3. Dimensional model, Data warehouse architecture, project
  4. Dimensional model, Data warehouse design, project
  5. Dimensional model, Data warehouse design, project
  6. Dimensional model, Data warehouse design, project
  7. Dimensional model, Data warehouse design
  8. Midterm exam
  9. Data visualization, project
  10. On-Line Analytical Processing, project
  11. ETL (Extract, transform and load)
  12. ETL (Extract, transform and load), project
  13. ETL (Extract, transform and load)
  14. Real-time Data Warehouses
  15. Final exam

Study Programmes

University graduate
Audio Technologies and Electroacoustics (profile)
Free Elective Courses (2. semester)
Communication and Space Technologies (profile)
Free Elective Courses (2. semester)
Computational Modelling in Engineering (profile)
Free Elective Courses (2. semester)
Computer Engineering (profile)
Elective Course of the profile (2. semester)
Computer Science (profile)
Free Elective Courses (2. semester)
Control Systems and Robotics (profile)
Free Elective Courses (2. semester)
Data Science (profile)
Elective Coursesof the Profile (2. semester)
Electrical Power Engineering (profile)
Free Elective Courses (2. semester)
Electric Machines, Drives and Automation (profile)
Free Elective Courses (2. semester)
Electronic and Computer Engineering (profile)
Free Elective Courses (2. semester)
Electronics (profile)
Free Elective Courses (2. semester)
Information and Communication Engineering (profile)
Free Elective Courses (2. semester)
Network Science (profile)
Free Elective Courses (2. semester)
Software Engineering and Information Systems (profile)
Elective Course of the profile (2. semester)

Literature

(.), Ralph Kimball, Margy Ross: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling,
(.), Christopher Adamson: Star Schema The Complete Reference,

For students

General

ID 222698
  Summer semester
5 ECTS
L3 English Level
L1 e-Learning
30 Lectures
15 Laboratory exercises

Grading System

87,5 Excellent
75 Very Good
62,5 Good
50 Acceptable