|
Lecturer(s)
|
|
|
|
Course content
|
Content: - Objectives of Information management and Business intelligence - Data management and data governance - Data quality, Metadata - Data and Information integration, - Master Data Management, - Architecture of DWH - ETL - Data models and Database model patterns - Data models related to DWH, dimensional modeling - Review od DWH technologies, OLAP, Column based databases - BI platforms, Reporting, Advance analyses - Processes related to DWH development and operation
|
|
Learning activities and teaching methods
|
Monologic (reading, lecture, briefing)
- Class attendance
- 30 hours per semester
- Preparation for credit
- 30 hours per semester
- Preparation for classes
- 15 hours per semester
|
|
Learning outcomes
|
The lecture covers functions of Data warehouse and Business Intelligence and theirs relations to enterprise information management. It concerns technology aspects and design, implementation and maintenance processes, too.
Data warehouse architecture, way of building reporting for organizations, Star scheme and its applications.
|
|
Prerequisites
|
unspecified
|
|
Assessment methods and criteria
|
Oral examination, Test
Credit based on test.
|
|
Recommended literature
|
-
Building the Data Warehouse, W.H. Inmon (Wiley, 1996).
-
Data Warehouse Design Solutions, Christopher Adamson, Michael Venerable (Wiley, 1999).
-
MS OLAP Solutions, Erik Thomsen, Geroge Spofford, Dick Chase (Wiley, 1999).
-
Rdb/Vms : Developing the Data Warehouse W.H. Inmon, Chuck Kelley.
-
The Data Warehouse Toolkit, Ralph Kimball (Wiley, 1996).
-
www.dama.org.
-
www.tdwi.org.
|