Data Warehousing
This course will help you design and implement a special type of databases structured for data analysis, namely data warehouses.
In data warehousing, special attention is laid on performance and usability issues. Data warehousing is a part of Business Intelligence (BI), which is used to support organisations strategic decision-making.
This course is part of a programme and is not available for application as a stand-alone course.
-
Course structure
The course contains the following parts:
- Introduction to decision support systems and Business Intelligence
- History, state-of-the-art within data warehousing
- Rationale and patterns for multi-dimensional modeling
- The ETL process (Extract-Transform-Load) and data integration
- The Data Warehouse Lifecycle (DW development and maintenance process)
- OLAP (Online Analytical Processing) and a multi-dimensional query language for data cubes
- Trends within data warehousing and current research
Teaching format
The teaching consists of lectures, laboratory sessions and supervision.
Assessment
The course is examined as follows:
- written examination
- written assignments
Examiner
-
Schedule
The schedule will be available no later than one month before the start of the course. We do not recommend print-outs as changes can occur. At the start of the course, your department will advise where you can find your schedule during the course. -
Course literature
Note that the course literature can be changed up to two months before the start of the course.
-
Contact
This course is part of a programme, course package or incoming exchange studies and is not available for application as a stand-alone course.
Find more information about Master’s programmes here
Study counsellors - master- Visiting address
Nod Buildning, Borgarfjordsgatan 12, Kista
- Office hours
Please contact us via email if you want to book a meeting. We are available on Campus in Kista and via Zoom.
- Phone hours
Thursday 12.30–2 pm
- Irregular office hours
Last phone hours for VT24 on May 30.
First phone hours for HT24 on August 15.
Extra phone hours on Monday, August 26, 12.30 to 2pm
One additional drop-in reception on level 1 (the balcony) on Tuesday 27 August 10am to 11am.
No phone hours on August 29.