NRP Video Segment 3: How to compare regions of interest - Text Transcript 2002-2006

Welcome to the National Regional Profile screen show.

Segment 3 of the show is titled 'Accessing Data for Multiple Regions - Supertable Data Cubes'.

This segment is relevant if you wish to compare a range of social and economic data for a number of different regions.

If you would like to access data for a specific region then you may wish to view segment 2 in this series titled 'How to access data for a region.'

To access the SuperTABLE Data Cubes, from the National Regional Profile Welcome Page, click on 'Select a data cube' under the 'Compare Regions' heading either from the left menu bar or from the main links on the Welcome Page.

This takes you to a listing of all of the data cubes.

If you don't currently have access to SuperTABLE, you can download it free from the Space-Time Research Website. For more information click on the 'SuperTABLE' link at the top of the downloads page. This link takes you to helpful information on how to install and use SuperTABLE

Once you have SuperTABLE installed, you have the option of viewing any one of 11 data cubes.

There are two main data cubes containing all the regions for Australia - one for all Local Government Areas and the other for all Statistical Local Areas and higher regions up to State/Territory and Australia level.

These Australia data cubes hold all of the data from the Excel spreadsheets that can be provided for every region in Australia.

There is at least one data cube for each of the States containing data that is only available for regions in that State.

This data is not available in the main Australia data cubes.

Let's now look at an example from the main Local Government Area data cube. To enter the data cube click on the .srd file icon.

Depending on individual computer settings, you may now have the option to either open the file or to save it to a folder on your PC. For the purpose of this example I have chosen to open the file.

You now have the chance to populate the blank table with the data items, time periods and regions that you are interested in.

Firstly to choose the data items that you are interested in, either click on 'Summation Options' and then the 'Recode' button or alternatively double click on 'Summation Options'. You now have the full list of data items to choose from.

For this example we will select Building Approvals and Motor Vehicle Sales data items from the list, Now click on 'Singly' and 'OK'.

Click again on 'Summation Options' and drag and drop the selected data items into the column heading of the table.

Now double click on the 'Year' field and select the years 2004, 2005 and 2006.

You can select all of these at once by clicking on 2004 and then holding the control key down while clicking on 2005 and 2006.

Then click 'Singly' and 'OK.'

Click again on the 'Year' field and drag and drop it into the row section of the table.

Finally click on the 'ASGC 2006 Local Government Area' field and then the 'Recode' button.

From the Australia level use the twisties to open all regions in New South Wales.

Highlight the first four regions and select 'Singly' and then 'OK.'

Click on the '2006 ASGC Local Government Area' field and drag and drop it also into the row section of the table.

It's important to note that you need to include all variables (that is, the summation options, the year and the ASGC) in your table to access valid data.

You can now compare Building Approvals and Motor Vehicle Sales data for the four selected New South Wales regions.

If you wish to add new regions to the table, or to change the time period or the data items this can be done by going back into the appropriate field and making the changes.

For example to add a further four regions double click on 'ASGC 2006', find the next four regions and add them via the 'Singly' button and 'OK.'

The extra four regions now appear in the table as shown.

You can also move any of the fields between the rows and columns to format the table in the most appropriate way.

For example click on the 'Years' field in the row section and drag it into the column section.

You have now changed the 3 year time series to appear across the table rather than down.

SuperTABLE also allows you to perform many other functions such as calculating averages and adding sub-totals.

The reports you create in SuperTABLE can be saved in file formats such as .xls, .wks, .txt or .csv.

For further information you can access the Supertable User Guide from the Help Menu.

That brings us to the end of this segment of the National Regional Profile screen show.

Please view the additional 3 segments in this series for detailed information on: The welcome Page, How to access data for a region, and Accessing the help pages and what data series are available for the product.

If you have any questions that haven't been answered by the screen show or the help pages provided in the product please contact us via email at