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
Prerequisite
Prohibition
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