| Offered at: | (B, X) |
|---|---|
| Credit point(s): | 1 |
| Offerings: | Trimester 1 |
| EFTSL value: | 0.125 |
| Unit chair: | J Lamp |
| Prerequisite: | Nil |
| Corequisite: | Nil |
| Incompatible with: | Nil |
| Contact hours: | 1 x 3 hour workshop per week. |
| Note: Online teaching methods require internet access. Please refer to the most current computer specifications. | |
Content
Organisations are increasingly relying on business analytics to get value from the very data they generate in their day to day operations. In order to gain maximum effective results from this data, it has to be reorganised to reflect this new use at the enterprise level rather than at the operational level. When data is reorganised to meet this need there is a real risk that the semantics of the data will be compromised and that data integrity can be violated. The reorganisation may also expose gaps in the operational data requiring an understanding of the impact such gaps may have and an evaluation of possible remedial measures. This unit will introduce students to these issues and techniques, such as sensitivity analysis, which can be used to address these problems. The Extract-Transform-Load process will be explored using features of the Oracle DBMS environment.
Assessment
Assignment 1 (2000 words, semantic issues) 33.3%*, assignment 2 (2000 words, ETL processing) 33.3%*, assignment 3 (2000 words, Enterprise Information Management in the organisation) 33.3%*
* Assessment includes an individual reflection worth half the marks allocated.
Unit Fee Information
| Student Contribution Rate* | Student Contribution Rate** | Fee rate - Domestic Students | Fee rate - International students |
| $1045 | $1045 | $2692 | $3008 |
* Rate for all CSP students, except for those who commenced Education and Nursing units pre 2010
** Rate for CSP students who commenced Education and Nursing units pre 2010
Please note: Unit fees listed do not apply to Deakin Prime students.