Student Profiling in the Data Warehouse

Target Audience

This course is suitable for staff who provide support for decision-making processes, often dealing with complicated questions requiring a large amount of data from various sources to be combined and analysed to provide an answer.

Overview

Oracle Discoverer is a web-based application that allows users to access the data warehouse and retrieve University-wide information. This information can then be summarised, sorted and graphed. It can also be explored, analysed and managed in an intuitive and free-form fashion without the need to learn complicated report writing techniques.

Prerequisite and Co-requisite Courses

This training requires that you have completed the course Introduction to the Data Warehouse.

It consists of two parts:

• Student Profiling in the Data Warehouse 1 - Course Enrolments
• Student Profiling in the Data Warehouse 2 - Award Progress

Both parts must be completed before access will be granted to the student profiling data.

Course Duration

3.5 hours for each part.

Competencies

At the completion of the Student Profiling in the Data Warehouse 1 - Course Enrolments course, attendees will be able to:

1. Understand and use key performance measures related to students' course enrolments
2. Understand LOAD versus Dropped LOAD
3. Use conditions
4. Create a graph from a report
5. Create a condition for DEST reporting
6. Create a CASE condition
7. Create a complex condition

At the completion of the Student Profiling in the Data Warehouse 2 - Award Progress course, attendees will be able to:

1. Understand and use key performance measures related to students' award progress.
2. Select filtered data items.
3. Use CASE and trap Divide By Zero errors.
4. Create a percentage.
5. Create calculations and use them in a condition.
6. Add a second dimension to a report.

For further details about courses go to the schedule of courses at the ITS training site.