IV170V Data-warehousing for SQL-servers 7.5 credits

The course is composed of a number of lectures, projects and exams.

The three lectures bring up the contents which is included in the course: MS SQL Server Business Intelligence Development Studio 2005, MS SQL Server Integration Services 2005, MS SQL Analysis Services 2005, star schemas, data warehousing, ETL, OLAP, Business Intelligence and MDX.

The two projects bring up practical tasks within the contents of the course.

The three exams bring up theoretical tasks within the contents of the course split up into three parts.

The overall aim of the course is to provide an understanding of how data warehousing can be used to collect data from several separate information sources for uniform analysis in multidimensional cubes in MS SQL Server 2005.

To pass, the student shall be able to do the following after a completed course:

• Describe how a relational database works.
• Describe how a multidimensional database works.
• Describe the concepts dimension, fact table, surrogate key, attribute relation, hierarchy, ETL, Star Schema, MDX, OLAP and Business Intelligence.
• Describe the available tools in MS Business Intelligence Development Studio 2005.
• Use MS SQL Server Integration Services 2005 to read data from source databases, transform the data and write it down in a Star Schema modeled database.
• Use MS SQL Server Analysis Services 2005 to create a multidimensional database.
• Build up logic in MS SQL Server Analyis Services 2005 to manage calculated members and actions.
• Use MDX-code to analyze data in MS SQL Server Analysis Services 2005.

For a higher grade, the student shall be able to do the following after a completed course:

• Give a thorough description of how a multidimensional database works.
• Identify appropriate strategies for management of history in continuous ETL-processes.• Identify benefits and disadvantages in using OLAP instead of OLTP.

Completed and documented upper secondary education including Swedish B and English A or equivalent.

The course material consists of a course book (given at course start) and software from Microsoft.

• PRO2 - Project, 1.5 credits, grading scale: P, F
• PRO1 - Project, 1.5 credits, grading scale: P, F
• TEN3 - Examination, 1.5 credits, grading scale: A, B, C, D, E, FX, F
• TEN2 - Examination, 1.5 credits, grading scale: A, B, C, D, E, FX, F
• TEN1 - Examination, 1.5 credits, grading scale: P, F

Based on recommendation from KTH’s coordinator for disabilities, the examiner will decide how to adapt an examination for students with documented disability.

The examiner may apply another examination format when re-examining individual students.

If the course is discontinued, students may request to be examined during the following two academic years.

• Passed exam 1 (TEN1;1,5p) – grade P-F.
• Passed exam 2 (TEN2;1,5p) – grade A-F.
• Passed exam 3 (TEN3;1,5p) – grade A-F.
• Passed project 1 (PRO1;1,5p) – grade P-F.
• Passed project 2 (PRO2;1,5p) – grade P-F.

The final grade is given when TEN1, PRO1 and PRO2 are Passed (grade P) and when TEN2 and TEN3 have the lowest grade of E.

• All members of a group are responsible for the group's work.
• In any assessment, every student shall honestly disclose any help received and sources used.
• In an oral assessment, every student shall be able to present and answer questions about the entire assignment and solution.

ostlin@kth.se