Data Warehousing

This subject has the following teaching availabilities in 2016:

200 hours

None

None

None

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

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.

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

• A group based data warehouse design case study paper (25%) with 2 group members of approximately 3000 words due mid-semester, requiring approximately 32-37 hours of work per student. Intended Learning Outcome (ILO) 2 is addressed in the case study paper.
• A group based essay on a data warehousing topic (25%) with 2 group members of approximately 3000 words due anytime in week 12, requiring approximately 32-37 hours of work per student. ILOs 1 to 3 are addressed in the essay, depending on topic area selected.
• One written 2 hour closed book end of semester examination (50%). ILOs 1-3 are addressed in the examination.

Hurdle requirement: To pass the subject, students must obtain:

• at least 50% of the marks available in the non-examination based assessment
• at least 50% of the marks available in the examination.

This subject is not available as a breadth subject.

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.

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.