Introduction to Business Intelligence

Course details

A Data Warehouse has become an essential tool in a company's strategic decision-making process. A warehouse is not simply a copy of a transactional database system; it has its own architecture and stores data in a specific format that allows for in depth analysis of data. This short course intends to provide students with the necessary skills and knowledge to be able to design, implement and maintain a data warehouse solution.

Program Benefits

This modular course includes the following topics:

• Introduction to Business Intelligence (SAP BIW)
• Conceptual Data Modelling
• SAP Meta Objects
• Info Cube Design
• ETL (Extraction, transfer and loading of data from the source systems)
• Reporting Best Practices
• Reporting Tools
• Dash boarding
• Data Mining
• Reporting Strategy
• Implementation
• Future of BI

Course Modules

Students will acquire the knowledge and skills needed to:

• Understand how data warehouse systems differ from operational information systems.
• Understand how the concepts of Business Intelligence can assist an organisation with its decision making processes.
• Analyse the requirements for such systems from a management perspective. Transform user requirements into a conceptual data model.
• Transfer the conceptual model into data warehouse system (SAP BIW).
• Extract, transform and load data from various data sources.
• Design and implement reports from within a data warehouse system.

Entry Requirements

Students must have a recognised Bachelor degree and IELTS 6.5. Students who have been taught at Bachelor level with English as medium of instruction may not need IELTS score.

• Students with Diploma level qualification and minimum 5 years of working experience may apply. Students with undergraduate qualification taught in English meets the English requirements for the course

Certificates Issued

Upon successful completion of this module students will be issued with following SOAs:

• IT-CIO-504S-1 Review reports and formulate action plan
• IT-DM-401S-1 Build Database
• SAP BI Alliance Certificate offered by Victoria University and SAP Australia

Education Pathway

Graduates who wish to pursue Masters of Business (ERP Systems) will get an exemption for 1 module.

Graduation Requirements

Students must successfully pass or deemed Competent (C) in assessments. Student upon failing will need to take the module again. An additional charge applies in such cases.