Australian Government Department of EducationuCube 

Transcript of uCube Tutorial 1 – basic

Slide 1:

The data cube called uCube allows custom tables to be generated by the client user via a browser application. The cube data is based on selected higher education micro data collected through the Higher Education Statistics Collection.

Slide 2:

Custom tables cannot be saved in the browser application. Please save tabular results by exporting to Excel and saving as an Excel file.

Slide 3:

The server will cancel client browser sessions after 20 minutes if idle. Please ensure that custom tables are exported to Excel.

Slide 4:

The data cube allows customised tables to be produced with cells containing very small counts. Therefore, to avoid any risk of disseminating identifiable data, a disclosure control technique called input perturbation has been applied to the data, whereby small random adjustments are made to cell counts. These adjustments (otherwise known as noise) allow for a greater amount of detailed data to be released, and, as they are small, do not impair the utility of the tabular data.

Slide 5:

In this demonstration we will build a table that consists of: student course completions, by initial registration as nurses, in New South Wales, at the University of Sydney, who are full-time and study internally.

Slide 6:

The measure is completions, and the dimensions are: Special Course, State - Institution, Type Of Attendance and Mode Of Attendance.

Slide 7:

To select the measure, click the selected cube drop-down menu button.

Slide 8:

Select the completions cube.

Slide 9:

As the default row dimension Citizenship Category is not required,

Slide 10:

it is removed by dragging and dropping the dimension from the rows pane to the measures and dimensions pane.

Slide 11:

This will result in no tabular data and the table heading will change to: No Data Available.

Slide 12:

Drag and drop the State - Institution dimension from the measures and dimensions pane to the rows pane.

Slide 13:

Click the down arrow next to the State - Institution dimension in the rows pane.

Slide 14:

Click the unselect all members icon button. This clears all the ticks.

Slide 15:

Click the plus symbol next to New South Wales to expand the sub-tree.

Slide 16:

Select The University of Sydney.

Slide 17:

Click the OK button.

Slide 18:

Next, we will select the column dimensions of interest.

Slide 19:

Drag and drop the Mode Of Attendance from the measures and dimensions pane to the columns pane.

Slide 20:

Similarly,

Slide 21:

drag and drop the Type Of Attendance from the measures and dimensions pane to the columns pane.

Slide 22:

Click the down arrow next to Mode Of Attendance.

Slide 23:

Click the unselect all members icon button.

Slide 24:

Select Internal.

Slide 25:

Click the OK button.

Slide 26:

Click the down arrow next to Type Of Attendance.

Slide 27:

Click the unselect all members icon button.

Slide 28:

Select Full time.

Slide 29:

Click the OK button.

Slide 30:

Slide 31:

Drag and drop the Special Course dimension from the measures and dimensions pane to the filters pane.

Slide 32:

Click the down arrow next to Special Course.

Slide 33:

Click the plus symbol next to All to expand the sub tree.

Slide 34:

Select Students undertaking courses for initial registration as nurses.

Slide 35:

Click the OK button. To export the custom table,

Slide 36:

click the Export to Excel icon button.

Slide 37:

The File download window opens.

Slide 38:

Click the Open button.

Slide 39:

This completes the basic tutorial.