cse5dwd data warehouse concepts and design
DATA WAREHOUSE CONCEPTS AND DESIGN
CSE5DWD
2018
Credit points: 15
Subject outline
Data warehouse (DW) underpins most enterprise systems like enterprise resource planning, customer relationship management and supply chain management systems.A DW is designed to provide information from a variety of sources within and outside an organisation to the enterprise systems. This subject introduces students to evolution of data warehouse technology, data warehouse terms and concepts, data warehouse design, data sourcing, organisational issues involved with designing and implementing a data warehouse. Especially, the multidimensional modelling with various data warehouse design schemas such as star schema and snowflake schema are the foci of the subject. Furthermore,related important technologies of Extract-Transformation-Load (ETL) system including 34 subsystems are discussed and studied. The different Online Analytical Processing (OLAP) architectures and approaches are analysed,compared and evaluated in the subject. The research issues on the performance of data warehouse and OLAP techniques are discussed and investigated. Several real world case studies are used to explain and illustrate various aspects of this subject.
SchoolSchool Engineering&Mathematical Sciences
Credit points15
Subject Co-ordinatorJinli Cao
Available to Study Abroad StudentsYes
Subject year levelYear Level 5 - Masters
Exchange StudentsYes
Subject particulars
Subject rules
Prerequisites BUS5BID or CSE2DBF or CSE4DBF or students admitted in the Master of Business Analytics or Graduate Diploma of Business Analytics
Co-requisites For students admitted in Master of Business Analytics or Graduate Diploma of Business Analytics - BUS5WB Data Warehousing and Big Data
Incompatible subjects CSE4DWD
Equivalent subjectsN/A
Special conditionsN/A
Learning resources
Readings
| Resource Type | Title | Resource Requirement | Author and Year | Publisher |
|---|---|---|---|---|
| Readings | The Data Warehouse Toolkit | Prescribed | Kimball, R and Ross, M, 2013 | WILEY |
| Readings | The Data Warehouse Lifecycle Toolkit, 2nd ed | Recommended | Kimball, R, et al | WILEY, 2008 |
Graduate capabilities & intended learning outcomes
01. Explain the role of the data warehouse within an enterprise system
- Activities:
- Lecture, tutorial discussions
02. Analyse a given problem and design a suitable data warehouse solution using various dimensional modelling techniques
- Activities:
- Tutorials, assignment, exam
03. Appraise and compare different data warehouse modelling approaches for real world industry projects
- Activities:
- Tutorials, assignment, exam
04. Explain and recommend solutions for the issues involved with sourcing data for the data warehouse tool
- Activities:
- Tutorials, Lectures, exam
05. Analyse critically OLAP performance on different data warehouse architectures
- Activities:
- Tutorials, exam
06. Research and apply established theories to improve data warehouse design
- Activities:
- Tutorials, assignment, exam
07. Explain the principle involved in managing a data warehouse project
- Activities:
- Tutorials, assignment, exam
Subject options
Select to view your study options…
City Campus, 2018, Semester 1, Blended
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorJinli Cao
Class requirements
Scheduled Online ClassWeek: 10 - 22
One 3.0 hours scheduled online class per week on weekdays during the day from week 10 to week 22 and delivered via online.
Laboratory ClassWeek: 10 - 22
One 2.0 hours laboratory class per week on weekdays during the day from week 10 to week 22 and delivered via face-to-face.
LectureWeek: 10 - 22
One 1.0 hours lecture per week on weekdays during the day from week 10 to week 22 and delivered via online.
Assessments
| Assessment element | Comments | % | ILO* |
|---|---|---|---|
| 1x assignment - data warehouse design using dimensional modelling techniques (1800 words equivalent) | 30 | 01, 02, 03, 04, 06, 07 | |
| One 2-hour examination | 50 | 01, 02, 03, 04, 05, 06, 07 | |
| Weekly Quiz (10 total) & review questions online (1000 words equivalent) | 20 | 01, 02, 03, 04, 05, 06, 07 |
Melbourne, 2018, Semester 1, Blended
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorJinli Cao
Class requirements
Scheduled Online ClassWeek: 10 - 22
One 3.0 hours scheduled online class per week on weekdays during the day from week 10 to week 22 and delivered via online.
Laboratory ClassWeek: 10 - 22
One 2.0 hours laboratory class per week on weekdays during the day from week 10 to week 22 and delivered via face-to-face.
LectureWeek: 10 - 22
One 1.0 hours lecture per week on weekdays during the day from week 10 to week 22 and delivered via online.
Assessments
| Assessment element | Comments | % | ILO* |
|---|---|---|---|
| 1x assignment - data warehouse design using dimensional modelling techniques (1800 words equivalent) | 30 | 01, 02, 03, 04, 06, 07 | |
| One 2-hour examination | 50 | 01, 02, 03, 04, 05, 06, 07 | |
| Weekly Quiz (10 total) & review questions online (1000 words equivalent) | 20 | 01, 02, 03, 04, 05, 06, 07 |