Handbook home
Data Warehousing (ISYS90086)
Graduate courseworkPoints: 12.5On Campus (Parkville)
About this subject
- Overview
- Eligibility and requirements
- Assessment
- Dates and times
- Further information
- Timetable(opens in new window)
Contact information
Summer Term
Overview
Availability | Summer Term |
---|---|
Fees | Look up fees |
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
INTENDED LEARNING OUTCOMES (ILOs)
Having completed this subject the student is expected to:
- Be familiar with data warehousing and its relationship to decision-making
- Understand the main concepts underlying data warehouse design and implementation, data quality and retrieval and analysis of data
- Be familiar with the role of data warehousing in customer relationship management systems
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
Last updated: 3 November 2022
Eligibility and requirements
Prerequisites
Code | Name | Teaching period | Credit Points |
---|---|---|---|
INFO90002 | Database Systems & Information Modelling |
Semester 2 (On Campus - Parkville)
Semester 1 (On Campus - Parkville)
|
12.5 |
Corequisites
None
Non-allowed subjects
SINF90004
Inherent requirements (core participation requirements)
The University of Melbourne is committed to providing students with reasonable adjustments to assessment and participation under the Disability Standards for Education (2005), and the Assessment and Results Policy (MPF1326). Students are expected to meet the core participation requirements for their course. These can be viewed under Entry and Participation Requirements for the course outlines in the Handbook.
Further details on how to seek academic adjustments can be found on the Student Equity and Disability Support website: http://services.unimelb.edu.au/student-equity/home
Last updated: 3 November 2022
Assessment
Additional details
- A two part group based assignment worth 50% overall with 2 group members:
- Part A: A data warehouse design case study paper (25%) of approximately 3000 words requiring approximately 32-37 hours of work per student. Due after the 4 th day of teaching (week 9). Intended Learning Outcome (ILO) 2 is addressed in this part of the assessment.
- Part B: A report outlining the ETL process to populate the data warehouse constructed in Part A (25%). This report will be about 2000 words requiring approximately 32-37 hours of work per student. Due after the 6 th day of teaching (week 12). ILOs 1 to 3 are addressed in this part of the assessment.
- One written 2 hour closed book end of semester examination (50%). ILOs 1-3 are addressed in the examination.
Hurdle requirements: 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
Last updated: 3 November 2022
Dates & times
- Summer Term
Principal coordinator Sean Maynard Mode of delivery On Campus (Parkville) Contact hours 36 Hours: 24 hours of seminars (6 days of 4 hours each), plus 12 hours of practical work (6 days of 2 hours each) Total time commitment 200 hours Teaching period 2 January 2019 to 11 February 2019 Last self-enrol date 10 January 2019 Census date 1 February 2019 Last date to withdraw without fail 8 February 2019 Assessment period ends 22 February 2019 Summer Term contact information
Time commitment details
200 hours
Last updated: 3 November 2022
Further information
- Texts
Prescribed texts
There are no specifically prescribed or recommended texts for this subject.
- Subject 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 Handbook entries
This subject contributes to the following:
Type Name Course Doctor of Philosophy - Engineering Course Master of Philosophy - Engineering Course Master of Data Science Course Ph.D.- Engineering Specialisation (formal) Spatial - Available through the Community Access Program
About the Community Access Program (CAP)
This subject is available through the Community Access Program (also called Single Subject Studies) which allows you to enrol in single subjects offered by the University of Melbourne, without the commitment required to complete a whole degree.
Entry requirements including prerequisites may apply. Please refer to the CAP applications page for further information.
Additional information for this subject
Subject coordinator approval required
- Available to Study Abroad and/or Study Exchange Students
This subject is available to students studying at the University from eligible overseas institutions on exchange and study abroad. Students are required to satisfy any listed requirements, such as pre- and co-requisites, for enrolment in the subject.
Last updated: 3 November 2022