Unit of competency Outline

Date retreived
23/07/2026 12:22 AM AWST

Whilst all efforts are made to provide accurate and timely information from the relevant source/documentation, please be aware that the information supplied may not be the most current version. The accuracy of the detail has not been confirmed by the Department and therefore should not be relied upon without first confirming the contents.

Build data warehouses

Build data warehouses

Unit of competency
National Code
ICTDBS604
State Code
OBU86
TGA Status
Current
DTWD Status
Approved
Current Release Number
1.00
Current Release Date
21/07/2020
View on TGA
State Implementation and Classification
Approved Date
15/01/2021
Field of Education
020305 - Systems Analysis And Design
Original Release Date
15/01/2021
Nominal Hours
80
Description
This unit describes the skills and knowledge required to design, develop and implement a data warehouse within an organisation.It applies to those who manage knowledge management teams or work in a team based senior role and has line management responsibility, looking after data warehouses.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Notes
Elements and Performance Criteria
1. Establish database design requirements
  • 1.1 Review organisational database design document, data structures, queries, reports and user interface
  • 1.2 Review organisation business security plan and determine level of alignment to organisational requirements
  • 1.3 Identify big data applications
  • 1.4 Determine database technical specifications
  • 1.5 Design and document database according to technical specifications and organisational requirements
2. Identify data and sources
  • 2.1 Identify enterprise’s knowledge management strategy data requirements
  • 2.2 Identify subject areas for business processes and data requirements
  • 2.3 Analyse and document operational data and define warehouse sources
  • 2.4 Develop warehouse source specifications with reference to existing data tables and files
3. Manage warehouse operational steps and processes
  • 3.1 Develop warehouse targets and align to business processes and data requirements
  • 3.2 Identify system configuration warehouse agents
  • 3.3 Determine and document warehouse steps and processes according to organisational requirements
4. Design and develop warehouse features
  • 4.1 Determine and document warehouse user interface
  • 4.2 Develop and implement warehouse security strategy according to organisational security plan
  • 4.3 Identify dimension tables and fact tables
  • 4.4 Determine technology costs for the implementation of warehouse security strategy
  • 4.5 Develop and document warehouse information catalogue according to organisational requirements
5. Test and implement data warehouse
  • 5.1 Test data warehouse against business and align to organisational requirements
  • 5.2 Recommend changes to business processes, according to compatibility with the data warehouse and the knowledge management strategy
  • 5.3 Implement data warehouse according to organisational requirements
  • 5.4 Benchmark and document performance level of data warehouse
  • 5.5 Develop and document maintenance schedule according to organisational requirements
  • 5.6 Submit all documentation to required personnel
No information
No information
Replaces
State Code National Code Title Type
AUP44 ICTDBS601 Build a data warehouse Unit of competency