units

FIT3003

Faculty of Information Technology

18 September 2017 22 November 2024

print version

This unit entry is for students who completed this unit in 2016 only. For students planning to study the unit, please refer to the unit indexes in the the current edition of the Handbook. If you have any queries contact the managing faculty for your course or area of study.

Monash University

6 points, SCA Band 2, 0.125 EFTSL

Undergraduate - Unit

Refer to the specific census and withdrawal dates for the semester(s) in which this unit is offered.

Faculty

Information Technology

Offered

Clayton

  • Second semester 2016 (Day)

Malaysia

  • Second semester 2016 (Day)

Synopsis

Automation and the use of technological tools have resulted in the accumulation of vast volumes of data by modern business organisations. Data warehouses have been set up as repositories to store this data and improved techniques now result in the speedy collection and integration of such data. OLAP technology has resulted in the faster generation of reports and more flexible analysis based on the data repositories. This unit will explore the concepts of data warehousing and OLAP, covering the data processing technological requirements for data warehousing and OLAP and will provide hands on experience on designing data warehousing and OLAP systems.

Outcomes

At the completion of this unit, students should be able to:

  1. design multi-dimensional databases and data warehouses;
  2. use fact and dimensional modelling;
  3. implement online analytical processing (OLAP) queries;
  4. explain query optimisation and its impact on multi-dimensional design;
  5. create business intelligence reports using data warehouses and OLAP.

Assessment

Examination (3 hours): 60%; In-semester assessment: 40%

Workload requirements

Minimum total expected workload equals 12 hours per week comprising:

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

  • Two hours of lectures
  • One 2-hour laboratory

(b.) Additional requirements (all students):

  • A minimum of 2 hours of personal study per one hour of contact time in order to satisfy the reading and assignment expectations.

See also Unit timetable information

Chief examiner(s)

Associate Professor David Taniar

This unit applies to the following area(s) of study

Business analytics
Business information systems
Data science

Prerequisites

One of FIT1004 or FIT2094

Additional information on this unit is available from the faculty at:

http://www.infotech.monash.edu.au/units/