FIT5095 - Data warehousing
6 points, SCA Band 2, 0.125 EFTSL
Postgraduate Faculty of Information Technology
Leader(s): Dr Rob Meredith
Offered
Caulfield First semester 2009 (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:
- the knowledge of theories and principles of data warehousing;
- the potential benefits of data warehousing;
- the techniques and tools used to design a data warehouse;
- the theories and principles of data warehousing with regard to the practice of decision support;
- and be able to design multi-dimensional data structures;
- and appreciation of how to interact effectively with managers, consultants, and vendors in the development of a data warehouse.
Assessment
Examination (2 hours): 50%; Assignments: 50%
Contact hours
3 hrs/week
Prerequisites
Prohibitions
IMS5026