Overview

This unit is intended to provide students with a framework for understanding business intelligence systems as well as the provision of high quality, integrated data for decision support through data warehousing. The unit has a particular focus on the evolutionary process of developing data warehousing using relational database management systems, … For more content click the Read More button below.

Requisites

Learning outcomes

On successful completion of this unit, you should be able to:
1.

describe the scope and application of data warehousing

2.

design data warehousing systems

3.

design multidimensional data models using star schemas

4.

implement data warehousing in relational databases

5.

use OLAP in SQL

6.

explain the need for data warehousing architecture

7.

explain query optimisation and its impact on multi-dimensional design

Assessment summary

Examination (2 hours and 10 minutes): 60%; In-semester assessment: 40%

This unit contains hurdle requirements which you must achieve to be able to pass the unit. The consequence of not achieving a hurdle requirement is a fail grade (NH) and a maximum mark of 45 for the unit.

Workload requirements

Workload