Course Title: Create a data warehouse

Part A: Course Overview

Program: C5148

Course Title: Create a data warehouse

Portfolio: BUS

Nominal Hours: 30.0

Regardless of the mode of delivery, represent a guide to the relative teaching time and student effort required to successfully achieve a particular competency/module. This may include not only scheduled classes or workplace visits but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non-classroom activities.

Course Code




Learning Mode

Teaching Period(s)


City Campus


650T TAFE Business

Face-to-Face or Internet

Course Contact: Nawal Shomali

Course Contact Phone: 03 9925 5826

Course Contact Email:

Course Description

This unit is about developing skills needed to develop a data warehouse within an organization. It aims to help students identify the concept of data warehouse and when it is needed, with up-to-date conceptual and practical knowledge on recent developments in database technology, specifically data warehousing. It will also help students set up a transfer system that collects and cleans the data and design the storage structure to obtain the best query performance when handling hundreds of rows of data. The knowledge gained also includes understanding the requirements of the client, identifying target environment in relation to client requirements, validation of data model and feeding back the recommendations into modelling process.

Pre-requisite Courses and Assumed Knowledge and Capabilities


National Competency Codes and Titles

National Element Code & Title:

ICAITB164A Create a data warehouse


Data warehouse is tested and implemented

Required data and sources are identified

Warehouse features are designed

Warehouse steps and processes are determined

Learning Outcomes

See details under elements of competency.

Overview of Assessment

Assessment methods have been designed to measure achievement of each competency in a flexible manner over a range of assessment tasks.
Assessment will incorporate a variety of methods including practical demonstrations, written tests and an examination. Students are advised that they are likely to be asked to personally demonstrate their assessment work to their teacher to ensure that the relevant standards are being met.