Data Warehousing (ISCG6425)

Level: 
6
Credits: 
15 (0.125 EFTS)
Compulsory: 
No
Aim: 
To introduce students to concepts of data warehousing and decision-making, data warehouse design and implementation, data sourcing and data quality, Extract-Transform-Load (ETL) procedure, and on-line analytical processing (OLAP). Students will gain hands-on experience using Microsoft SQL server for implementing data warehouses.
Pre-requisites / Co-requisites: 
Students must be admitted to the Bachelor of Computing Systems programme or the Graduate Diploma in Computing programme or the Diploma in Information Technology Support programme to enrol in this course. Pre-requisite: For BCS & DITS: ISCG5423.
Topics include: 

Data warehouse architecture and schema, Introduction to SQL server for Data Warehouse, Dimentional Modelling, ETL, data integration, and data quality, Data Sourcing, OLAP and Data cubes, SQL in data warehouse, Data Warehouse and Business Intelligence,
Timetable: 
Choose your class for this course from the option(s) below. You will need to attend all the sessions in that class to complete the course. Where more than one class number is shown, choose one of them and attend all sessions within that class number. (Note: If a class is held in different locations at the same time, you only need to attend all the sessions in one of the locations.)
There are no classes on public holidays.

Class: 2381

You need to attend all sessions of this class as listed below.

From – ToSessionDayTimeCampus (Room)
27 Feb 18 - 10 Apr 18 LabTuesday08:30 - 11:30 Mt Albert (183-2104)
1 May 18 - 26 Jun 18 LabTuesday08:30 - 11:30 Mt Albert (183-2104)

Class: 6063

You need to attend all sessions of this class as listed below.

From – ToSessionDayTimeCampus (Room)
28 Jul 17 - 29 Sep 17 LabFriday17:30 - 20:30 Mt Albert (183-2104)
20 Oct 17 - 10 Nov 17 LabFriday17:30 - 20:30 Mt Albert (183-2104)

Class: 6135

You need to attend all sessions of this class as listed below.

From – ToSessionDayTimeCampus (Room)
24 Jul 18 - 25 Sep 18 LabTuesday17:30 - 20:30 Mt Albert (183-1001)
Tuesday17:30 - 20:30 Mt Albert (183-1002)
16 Oct 18 - 20 Nov 18 LabTuesday17:30 - 20:30 Mt Albert (183-1001)
Tuesday17:30 - 20:30 Mt Albert (183-1002)
Note: This course is offered as part of Bachelor of Computing Systems, Diploma in Information Technology Support, Graduate Diploma in Computing.

Share on