Stockholm university
Gå till denna sida på svenska webben

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
    Margrét Håkansson and Mitra Wijkman
    master@dsv.su.se
    08-16 16 86
    • 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 of autumn semester 2024: 12 December

      First phone hours of spring semester 2025: 9 January

Selected reading

Three students outdoors in front of a computer.

Step-by-step guide

Here we explain all the different steps you need to go through when applying to a course or programme. Please read the instructions carefully.

Two happy students looking at a mobile phone.

Meet us online and around the world

Stockholm University arranges regular webinars and participates in educational fairs and events virtually and around the world to meet students and inform them about our study programmes. Meet us and ask what it's like to study with us!

Students of Stockholm University

Every year Stockholm University welcomes thousands of international students from all over the world. Each bringing their own backpack full of experiences, expectations and dreams. Each with their own story.

Photo montage of close-ups of researchers.

Our researchers. Your teachers

As a student at Stockholm University, you will have direct contact with leading researchers in your field and access to the most recent scientific findings. Our researchers. Your teachers. Meet a few of them here.

Mikaela Sörman

Hear from our alumni

Are you wondering what former students thought about your programme? Are you curious about what your education can lead to after graduation? Hear from our alumni!

Show more