Business intelligence

Repository

Repository is empty

Poll

No polls currently selected on this page!

Business intelligence

Code: 255133
ECTS: 5.0
Lecturers in charge: dr. sc. Ognjen Orel , v. pred.
Lecturers: dr. sc. Ognjen Orel , v. pred. - Exercises
Take exam: Studomat
Load:

1. komponenta

Lecture typeTotal
Lectures 30
Exercises 15
* Load is given in academic hour (1 academic hour = 45 minutes)
Description:
COURSE AIMS AND OBJECTIVES:

Enable students to:
- critically think about the value of data stored in information systems and informed data supported decision-making
- implement a data warehouse and use it as an analytical tool for knowledge extraction and decision-making


COURSE DESCRIPTION AND SYLLABUS:
1. Business intelligence basics. Informed decision-making. Data warehouses. OLAP and OLTP.
2. Logical design of a data warehouse. Data warehouse models. Facts and dimensions. The full process of logical data warehouse design. Data granulation.
3. Implementing the data warehouse. Technological architecture of a warehouse. The ETL (extract, transform, load) process. Data wrangling and manipulation.
4. Data quality. Data cleansing. Missing data. Missing events.
5. Data warehouse in production. Reporting systems and user interfaces. Maintenance of a production data warehouse.
Literature:
Prerequisit for:
Enrollment :
Passed : Database systems
3. semester
Izborni predmeti 4 i 5 - Regular study - Financial and Business Mathematics
Consultations schedule: