Business Intelligence
Course Description
Dimensional Model, Data Warehouse Architecture, Reporting and Visualization Tools from Data Warehouse, Real-Time Data Warehouses, OLAP, ETL.
Learning Outcomes
- define the basic concepts of Business Intelligence and Data Warehouses
- apply the princples of DW modelling
- employ the basic ETL procedures
- operate the basic OLAP technologies
- employ basic BI tools
- produce a BI tool prototype
Forms of Teaching
Lectures
Students are presented with theoretical foundations of selected topics intertwined with practical examples.
Partial e-learningStudents have access to one online tutorials which serves as a reminder and crash course for required previus knowledge in SQL.
Independent assignmentsStudents individually work on their project through six homework assignments
LaboratoryStudents 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 % | 50 % |
Week by Week Schedule
- Introduction, definitions, motivation
- Dimensional model
- Dimensional model, Data warehouse architecture, project
- Dimensional model, Data warehouse design, project
- Dimensional model, Data warehouse design, project
- Dimensional model, Data warehouse design, project
- Dimensional model, Data warehouse design
- Midterm exam
- Data visualization, project
- On-Line Analytical Processing, project
- ETL (Extract, transform and load)
- ETL (Extract, transform and load), project
- ETL (Extract, transform and load)
- Real-time Data Warehouses
- Final exam
Study Programmes
University graduate
[FER3-HR] Audio Technologies and Electroacoustics - profile
Elective Courses
(2. semester)
[FER3-HR] Communication and Space Technologies - profile
Elective Courses
(2. semester)
[FER3-HR] Computational Modelling in Engineering - profile
Elective Courses
(2. semester)
[FER3-HR] Computer Engineering - profile
Elective Course of the profile
(2. semester)
Elective Courses
(2. semester)
[FER3-HR] Computer Science - profile
Elective Courses
(2. semester)
[FER3-HR] Control Systems and Robotics - profile
Elective Courses
(2. semester)
[FER3-HR] Data Science - profile
Elective Courses
(2. semester)
Elective Coursesof the Profile
(2. semester)
[FER3-HR] Electrical Power Engineering - profile
Elective Courses
(2. semester)
[FER3-HR] Electric Machines, Drives and Automation - profile
Elective Courses
(2. semester)
[FER3-HR] Electronic and Computer Engineering - profile
Elective Courses
(2. semester)
[FER3-HR] Electronics - profile
Elective Courses
(2. semester)
[FER3-HR] Information and Communication Engineering - profile
Elective Courses
(2. semester)
[FER3-HR] Network Science - profile
Elective Courses
(2. semester)
[FER3-HR] Software Engineering and Information Systems - profile
Elective Course of the profile
(2. semester)
Elective Courses
(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
L1 English Level
L1 e-Learning
30 Lectures
0 Seminar
0 Exercises
15 Laboratory exercises
0 Project laboratory
Grading System
87,5 Excellent
75 Very Good
62,5 Good
50 Acceptable