ICTDBS503 - Create a data warehouse

Unit code:ICTDBS503Study level:TAFE

Nominal hours

Location

Footscray Nicholson

Prerequisites

(Or equivalent to be determined by unit coordinator)
Co-requisites
(Corequisite units must be studied concurrently with this unit)

Overview

This unit describes the skills and knowledge required to design, develop and implement a data warehouse within an organisation.
It applies to individuals who are senior database staff required to provide data warehouse functionality for their organisation.No licensing, legislative or certification requirements apply to this unit at the time of publication.

Assessment

For Melbourne campuses

Assessment tasks will be designed to reinforce & extend knowledge and skill competence within set & controlled parameters in accordance with each unit’s learning outcomes & performance criteria requirements, including the setting of work based practical application tasks designed to provide evidence of competence outcomes, within periodic and scheduled timelines.

Students will be expected to demonstrate the following required skills:
• prepare the specifications for a data warehouse, from a range of organisational information
• design a data warehouse system that reflects the current, and future, business specifications, and also the business’s knowledge management strategy
• test the data warehouse system
• implement the data warehouse design.

Students will also be expected to demonstrate the following knowledge:
• explain the functions and features of:

data warehousing and data mining
dimension tables and fact tables
various steps and processes, including transformer steps, program steps, structured query language (SQL) steps, and user-defined program steps
subject areas, warehouse sources and warehouse targets
warehouse agents and agent sites
• outline the business operating systems related to the data sources
• describe the decision support systems related to the knowledge management strategies
• define the parameters for a security plan
• outline the system’s configuration parameters
• describe the key features of "Big Data" including:
data access speeds and processing
the information handled by large corporations
distribution, via the cloud, across the database servers.

Required reading

The qualified trainer and assessor will provide teaching and learning materials as required in the form of workbooks produced by the Victoria University and/or via the Victoria University e-learning system.