ICTICT812
Develop a business intelligence framework


Application

This unit describes the skills and knowledge to evaluate the business intelligence (BI) requirements of an organisation, and to select the correct methodologies to develop a BI solution.

It applies to individuals who work in high-level management positions and lead the analysis, implementation and management of emerging, and converging, information and communications technology (ICT) as they are integrated into the business process, to support the organisational strategic goals of medium to large organisations.

No licensing, legislative or certification requirements apply to this unit at the time of publication.


Elements and Performance Criteria

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Elicit the business intelligence requirements

1.1 Articulate the benefits of business intelligence

1.2 Select the appropriate system development methodology, through the analysis of a range of options

1.3 Critically evaluate the impact of business intelligence on the enterprise

1.4 Select the appropriate business model for a data repository

1.5 Adopt a metadata standard for the enterprise

1.6 Establish the appropriate data analysis techniques

2. Direct the business intelligence data manipulation

2.1 Identify the data sources and scope

2.2 Evaluate and endorse the selected data-manipulation methods

2.3 Critically review, and commit to, the feasibility of the architecture design

2.4 Develop the acceptance criteria

2.5 Endorse the selected data-modelling techniques and processes

2.6 Endorse a load balancing algorithm for optimum processing

2.7 Sign off the design specifications

3. Endorse the business intelligence solution architecture

3.1 Ensure that the data-warehousing management techniques and processes are according to the specifications

3.2 Lead the scoping of logical data models

3.3 Supervise the selection of middleware tools

3.4 Critically review, and commit to, a searchable data repository solution

4. Finalise the testing and accept the framework

4.1 Finalise the physical data model

4.2 Complete testing of the overall model

4.3 Test the security

4.4 Test the integrity

4.5 Perform a user-acceptance test

Evidence of Performance

Evidence of the ability to:

research and critically analyse the business intelligence requirements

review, analyse and direct, business intelligence data manipulation

review, critically analyse and endorse, the proposed business intelligence solution architecture

initiate and contrast the tests required for the intelligence framework, for final acceptance.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.


Evidence of Knowledge

To complete the unit requirements safely and effectively, the individual must:

evaluate the application of system development methodologies and other technical considerations including:

managing and using metadata

data modelling

data warehousing/back-end software alternatives

business analytics

business intelligence tools

analyse the organisational policies and procedures, as they apply to the business intelligence frameworks

discuss behaviour theories as they apply to business intelligence, including:

responsibility and achievement

affiliation management

motivation

appraise and evaluate, the business intelligence (BI) procedures

interpret the workplace and industry environmental conditions, as they apply to business intelligence.


Assessment Conditions

Gather evidence to demonstrate consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, interruptions and time variances must be typical of those experienced in the general information and communications technology (ICT) industry, and include access to:

a business intelligence focus

relevant enterprise documentation, including human resource (HR) and quality management policies.

Assessors must satisfy NVR/AQTF assessor requirements.


Foundation Skills

This section describes language, literacy, numeracy and employment skills incorporated in the performance criteria that are required for competent performance.

Skill

Performance Criteria

Description

Reading

1.2, 1.3, 1.6, 2.1, 2.3, 2.5, 2.6, 2.7, 3.1, 3.2, 3.3, 3.4, 4.1

Organises, evaluates and critiques ideas, and information, from a wide range of complex texts

Draws on a broad range of strategies to build and maintain understanding throughout complex texts

Writing

1.1, 1.3, 1.6, 2.4, 2.7, 4.1, 4.5

Integrates information and ideas from a number of sources, utilising the appropriate BI software tools, specialised and cohesive language, and appropriate document structures, to meet the varied requirements of the organisation and the task

Oral Communication

1.1, 2.1, 2.2, 2.3, 2.5, 2.6, 3.2, 3.3, 3.4, 4.5

Elicits information and ideas using plain English, translating BI specific terminology when necessary, and using effective listening and questioning techniques

Uses specific and complex BI terminology, to liaise with team members, review and endorse methodology and monitor the project

Articulates the requirements and methodologies clearly, using the appropriate tone, style, body language and reflective responses

Numeracy

1.1, 1.3, 1.4, 1.6, 2.3, 2.4, 2.5, 2.6, 2.7, 3.2, 3.4, 4.1, 4.2, 4.5

Uses a range of complex statistical, mathematical and financial calculations, formulae and functions together with the appropriate BI software tools, in the development of a BI framework

Get the work done

1.1, 1.2, 1.3, 1.4, 1.5, 1.6, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.2, 3.3, 4.2, 4.3, 4.5

Demonstrates a sophisticated understanding of the principles, concepts, language and practices associated with the digital world, and uses these to develop a BI framework

Recognises the critical importance of clarifying, focusing and aligning goals, and expectations, using the process to build ownership of, and broad commitment to, achieving outcomes

Takes responsibility for high-impact decision in complex situations, involving many variables and constraints


Sectors

General ICT