Although based on two pre-existing units (FIT5093 and FIT5095), this new unit forms part of the core of the new Master of Business Information Systems.

Previous change - This unit has been updated as part of a 2009 review and comparison of data with current Handbook, Syllabus + and Callista data.

21 May, 2013 - This unit is a merger of the former FIT5095 Data Warehousing and FIT5093 Business Intelligence Applications units. The unit will first be offered in Semester 1, 2014.

17/7/13 Amended teaching mode, prerequisites and prohibitions. Effective Semester 1 2014.

12/8/13- Updated objectives to learning outcomes for consistency with AQF requirements.

22/10/2014 - Amended prerequisite requirements by adding 2015, FIT9xxx version of 2014, FIT5xxx foundation units. Approved at GPC 4/14 (Item 6.2).

12/12/2016 - Changed the exam time from three hours + ten minutes reading time to two hours + 30 minutes reading and noting time in accordance with new University exams policy restricting exams to two hours duration. Change to take effect from Semester 1, 2017.

12/06/2017: Admin - updating location of offering to reflect actual campus offerings at the ADE's request.

28/06/2018: Admin - updating assessment removing the 30 minutes reading and noting time on behalf of the CE.

26/11/2018: updating the unit objectives as well as the assessment breakdown.

14/02/2019: Removed incorrect prohibition (FIT5137)

24/9/2019: Admin - adding 10 minutes reading time to the overall exam duration as per University requirements.

11/11/2019: Removing disestablished prerequisites. Effective 2020.

4/5/2020: As the MSA course 4307 Bachelor of Computer and Information Sciences is in teach-out, the MSA offering of this unit has been re-coded to FZA195 effective Semester 2, 2020. These units will be managed by South Africa and therefore no separate Monatar entries will be made.

21/09/2020 - Admin: Update to include new assessment and teaching approach fields as per Handbook requirements.

17/02/2021: Admin - updating 'Reasons for Change' on behalf of CE - amended in-semester assessment to change break-down. Old breakdown: Take home test 10%; Assignment 25%; FLUX participation 5%

This unit is one of the core units in the Business Information Systems specialization in the MBIS degree; one of the core units in the Data Science stream in the MDS degree, as well as one of the core units in the MIT degree.

On successful completion of this unit, students should be able to:

020307

This unit is intended to provide students with a framework for understanding business intelligence systems as well as the provision of high quality, integrated data for decision support through data warehousing. The unit has a particular focus on the evolutionary process of developing data warehousing using relational database management systems, and multi-dimensional modelling for structuring business intelligence data. The unit also presents students with coverage of several important aspects of data warehousing, including architecture, design, implementation, and optimisation. The unit will present this material using relevant research, case studies and practical exercises. Students will develop data warehouse modelling and OLAP using relational database management systems.

Technological requirements

Windows or Mac OS computer able to run Oracle DBMS. Software will be available in student computer labs as well as for download and installation on personal devices.

On-campus and off-campus.

Scheduled Final Assessment (2 hours and 10 minutes): 60%; In-semester assessment: 40%

1. Take Home Test - 5% - ULO : 2, 3, 4
2. Major Assignment - 20% - ULO: 1, 2, 3, 4, 6
3. Moodle Quiz - 5% - ULO: 5, 7
4. Advanced DW Video Presentation - 5% - ULO: 1, 6, 7
5. Flux Participation (online quizzes) - 5% - ULO: 1, 2, 3, 4, 5, 6, 7
6. Scheduled Final Assessment - 60% - ULO: 1, 2, 3, 4, 5, 6, 7

6

Minimum total expected workload equals 12 hours per week comprising:

(a.) Contact hours for on-campus students:

(b.) Study schedule for off-campus students:

(c.) Additional requirements (all students):

FIT

Callista prerequisites: No prerequisites for MBIS (Professional) (3341.2), MBIS (Honours) (3343) or MIT (Professional) (2402.6).

Callista & Handbook prerequisite: FIT9132 or equivalent