FIT5095 - Data warehousing

Leader: Rob Meredith

Offered

Caulfield First semester 2008 (Evening)

Synopsis

Managerial decision-makers often require information held in various organisational information systems to make improved strategic decisions. A data warehouse is designed to provide high quality data from a number of sources both inside and outside the organisation an is an example of a large-scale decision system. This unit presents students with coverage of several important aspects of data warehousing. These include the purpose of data warehouse, data warehouse design, data warehouse architecture, data sourcing, implementing the data warehouse, organisational issues involved with designing and implementing a data warehouse governance and case studies of data warehousing practice.

Objectives

At the completion of this unit students will have a theoretical and conceptual understanding of:

1. the knowledge of theories and principles of data warehousing;
2. the potential benefits of data warehousing;
3. the techniques and tools used to design a data warehouse;
4. the theories and principles of data warehousing with regard to the practice of decision support;
5. and be able to design multi-dimensional data structures;
6. and appreciation of how to interact effectively with managers, consultants, and vendors in the development of a data warehouse.

Assessment

Examination (3 hours): 50%
Assignment 1: 30%
Assignment 2: 20%

Contact hours

4 x contact hrs/week

Prerequisites

FIT9003

Prohibitions

IMS5026