Data Warehousing

Subject ISYS90086 (2015)

Note: This is an archived Handbook entry from 2015.

Credit Points: 12.5
Level: 9 (Graduate/Postgraduate)
Dates & Locations:

This subject has the following teaching availabilities in 2015:

Semester 1, Parkville - Taught on campus.
Pre-teaching Period Start not applicable
Teaching Period 02-Mar-2015 to 31-May-2015
Assessment Period End 26-Jun-2015
Last date to Self-Enrol 13-Mar-2015
Census Date 31-Mar-2015
Last date to Withdraw without fail 08-May-2015


Timetable can be viewed here. For information about these dates, click here.
Time Commitment: Contact Hours: 36 hours over the semester.
Total Time Commitment:

200 hours

Prerequisites:

None

Corequisites:

None

Recommended Background Knowledge:

None

Non Allowed Subjects:
Subject
Core Participation Requirements:

For the purposes of considering request for Reasonable Adjustments under the Disability Standards for Education (Cwth 2005), and Student Support and Engagement Policy, academic requirements for this subject are articulated in the Subject Overview, Learning Outcomes, Assessment and Generic Skills sections of this entry.

It is University policy to take all reasonable steps to minimise the impact of disability upon academic study, and reasonable adjustments will be made to enhance a student's participation in the University's programs. Students who feel their disability may impact on meeting the requirements of this subject are encouraged to discuss this matter with a Faculty Student Adviser and Student Equity and Disability Support: http://services.unimelb.edu.au/disability

Coordinator

Dr Sean Maynard

Contact

email: sean.maynard@unimelb.edu.au

Subject Overview:

AIMS

Data warehouses are designed to provide organizations with an integrated set of high quality data to support decision-makers. They should support flexible and multi-dimensional retrieval and analysis of data. Topics covered include data warehousing and decision-making, data warehouse design, data warehouse implementation, data sourcing and data quality, on-line analytical processing (OLAP) and data mining, customer relationship management systems, and case studies of data warehousing practice. This subject is part of the Business Analytics stream within the Master of Information Systems.

INDICATIVE CONTENT

This subject introduces the compelling need for data warehousing, data warehouse architectures, decision making, data warehouse design, data warehouse modelling, data quality, data warehouse implementation - including the Extract Transform Load (ETL) process, and data warehouse use in supporting decision making – including decision making tools and OLAP. Readings are provided for all topics that introduce real world cases on data warehousing and related areas and include the use of data warehousing for competitive advantage, success and failure stories in Data Warehousing.

Learning Outcomes:

INTENDED LEARNING OUTCOMES (ILOs)

Having completed this subject the student is expected to:

  1. Be familiar with data warehousing and its relationship to decision-making
  2. Understand the main concepts underlying data warehouse design and implementation, data quality and retrieval and analysis of data
  3. Be familiar with the role of data warehousing in customer relationship management systems

Assessment:
  • A data warehouse design case study paper (about 3000 words), completed in groups of 2, due mid-semester (25%), requiring approximately 32-37 hours of work per student. Addresses Intended Learning Outcome (ILO) 2.
  • A written paper (essay) on a data warehousing topic (about 3000 words), completed in groups of 2, due anytime, at the students choosing, from week two to week twelve (25%), requiring approximately 32-37 hours of work per student. Addresses ILOs 1-3, depending on topic area selected.
  • A 2-hour written examination in the examination period (50%). Addresses ILOs 1-3.

Hurdle requirement: To pass the subject students must obtain at least:

  • 50% of the marks available for the non-examination based assessment
  • 50% of the marks available for the examination
Prescribed Texts: None
Breadth Options:

This subject is not available as a breadth subject.

Fees Information: Subject EFTSL, Level, Discipline & Census Date
Generic Skills:

On completion of this subject students should have the following skills:

  • Students should develop skills in literature search and analysis, critical thinking and independent learning.
Notes:

LEARNING AND TEACHING METHODS

The subject is delivered in 3 hour classes. Each class will be made up of a combination of lectures, discussions and tutorial type activities. Outside class students will study the various aspects of data warehousing through prescribed readings.

INDICATIVE KEY LEARNING RESOURCES

All required readings are available via the LMS.

CAREERS / INDUSTRY LINKS

This subject is relevant to careers in data warehousing, data analysis, data mining, and information management. A guest lecturer will present at least one week’s worth of materials about data warehousing in industry.

Related Course(s): Master of Information Systems
Master of Information Systems
Master of Information Systems
Master of Operations Research and Management Science
Master of Philosophy - Engineering
Master of Science (Information Systems)
Ph.D.- Engineering
Related Majors/Minors/Specialisations: MIS Professional Specialisation
MIS Research Specialisation
MIT Health Specialisation
MIT Spatial Specialisation

Download PDF version.