Video Segment 6: How to Access Data for Multiple Regions - Text Transcript

Welcome to the National Regional Profile screen show.

Segment 6 of the show is titled 'How to Access Data for Multiple Regions - SuperTABLE Data Cube'.

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 Segments 2, 3 and 4 in this series.

To access the SuperTABLE data cube from the Map Entry Page, click on the 'Compare Regions' button at the top of the Map Entry page.

If you don't currently have access to SuperTABLE, you can download it free from the Space-Time Research website. Click on the 'What are data cubes?' link. This link takes you to helpful information on how to install and use SuperTABLE.

Once you have SuperTABLE installed, click on the 'here' link at the top of the page.

In this edition of the National Regional Profile there is one data cube containing data for all regions including Local Government Areas, Statistical Local Areas and other higher geographies.

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 the 'Summation Options'. You now have the full list of data items to choose from.

For this example we will select a group of Building Approvals and Motor Vehicle Census data items from the list.

Click on 'Singly' and then 'OK'.

Now 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 'Calendar 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 down the control key while clicking on 2005 and 2006.

Then click 'Singly' and 'OK.'

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

Finally click on the 'Geography' field and then the 'Recode' button.

You will notice that there are two 'Total Australia' headings. When you open the 'twistie' next to each heading, you will see different region types.

The first 'Total Australia' heading opens to show States and Territories, Local Government Areas and Statistical Local Areas.

The second 'Total Australia' heading opens to show States and Territories again, plus Statistical Divisions, Statistical Subdivisions and Statistical Local Areas.

For our example, lets open the first 'Total Australia' heading, and then all Local Government Areas within the State of New South Wales.

Highlight the first four Local Government Areas and select 'Singly' and then 'OK.'

Click on the 'Geography' 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 calendar year and the geography in your table to access valid data.

You can now compare Building Approvals and Motor Vehicle Census data for the four selected Local Government Areas in New South Wales.

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 'Geography', 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.

If you require further information remember you can access the help available from the 'what are data cubes' link on the 'Compare Regions' page.

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

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