English   Danish

2010/2011  KAN-CMIT_VDAW  Data warehouses

English Title
Data warehouses

Course Information

Language English
Point 7,5 ECTS (225 SAT)
Type Elective
Level Full Degree Master
Duration One Semester
Course Period Pending schedule: Friday 13.30-16.05, week 36-41, 43-44
Time Table Please see course schedule at e-Campus
Study Board
Study Board for BSc/MSc in Business Administration and Information Systems
Course Coordinator
Lars Frank - lpf.inf@cbs.dkSecretary INF - reception.inf@cbs.dk
Main Category of the Course
  • Supply Chain Management and Logistics
  • Information Systems
  • Management of Information and Knowledge Management
  • Financial and management accounting

Taught under Open University-Taught under open university.
Last updated on 29 maj 2012
Learning Objectives
The course’s development of personal competences:
The course qualifies the students for occupation within Business Intelligence (BI)/decision support systems that is one of the fastest groing areas within IT.

A datawarehouse is a consistent set of data organized for decision making
The course focus on how to design, describe, and optimize datawarehouses for different line of businesses/organisations.
For each node in the value chain of any type of organization, the student should be able to design, describe, and implement a data mart for decision making.
As a datawarehouse normally evolves over time, the student should also be able to demonstrate how “conforming” the data warehouse can protect the investment against new unforeseen demands to the data warehouse.
In a given business decision making situation, the student should be able to select an appropriate BI tool to support the decision making.
SAS´s data warehouse produkt EIS will be demonstrated in order to make it possible for the students to implement a data warehouse. However, any datawarehouse product may be used. The company Affecto have offered free licenses to the participants in their free optional Business Object course.
The student should know how to read a simple SQL program.
Oral exam on the basis of a project, max. 15 pages.
Exam Period Winter Term
20 minutes oral exam based on a maxi-project which is max. 15 pages per student. The re-take takes place according to the same rules as the regular examination.
Prerequisites for Attending the Exam
Course Content

As an introduction to the course the basic data models for both operative databases/On Line Transactional Processing (OLTP) and data varehuse/On Line Analytical Processing (OLAP) are described.The focus of the course is how to design, describe, implement, and evaluate data warehouses for different line of businesses/organisations. From a business point of view the main problem in data warehouse design is that most companies/organizations have lots of data, but these data are not structured in order to give information for decision support.

The course will also give an overview of the different types of data mining from a user point of view. Therefore, data mining algorithms will not bedescribed.

Teaching Methods
The teaching is integrated with exercises and discussion of the solutions. It is expected that each student is responsible of a lecture that presents the theory from one of the chapters in the required readings. The student lectures may last up to 20 minutes and may also use exercises followed by discussions. Background theory that is only used indirectly in the maxi project is often self study. The teaching also consists of supervising the project groups and discussion of the solutions followed by student presentation of their work with the maxi project. Students with knowledge in other data warehouse products can substitute there theory lecture with a presentation of another data warehouse product.

A little more than 1000 pages are listed as there is some overlapping between Kimball’s two books.







Ralph Kimball, Laura Reeves, Margy Ross, Warren Thornthwaite

The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing, and Deploying Data

The hole book is required readings except chapters 12 and 16. That is 669 pages out of 771 pages.


ISBN: 0-471-25547-5, Paperback, August 1998.

2nd Edition from 2008 is not recommended



Ralph Kimball and Margy Ross

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 2nd Edition. The hole book is required readings except chapter 1. The digital issue is recommended.

Wiley. 2002



L. Frank, 2008

Databases and Applications with Relaxed ACID Properties.

Only chapters 8 and 10 with corresponding exercises are required readings and these chapters will be uploaded to Learn.

Copenhagen Business School