|Page tools: Print Page Print All|
Specific information regarding Building Approvals SuperTABLE Data Cubes
SuperTABLE Data Cubes contain a number of classifications from which different tailored tables can be created to suit your needs by manipulating the classifications.
Building Approvals Data Cubes for small area data are available in two formats: SuperTABLE and Excel spreadsheet. The Excel spreadsheets contain data available from the SuperTABLE data cubes but with less detail e.g. SuperTABLE data cubes include data for each individual month whereas the Excel spreadsheets contain data for the total year.
Building Approvals data are subject to revision. Data cubes are re-released each month including data for the latest month and revisions to data for previous months.
Validation Table for use with SuperTABLE data cubes
The validation table attached below is an Excel spreadsheet containing state level data for checking purposes when using SuperTABLE datasets. It is VERY IMPORTANT to check totals from tables created against the validation table to ensure you have extracted correct data. This is due to overcounting that will occur in the table if you make no selection for some classifications:
1. For Type of Work and Type of Building, you MUST select the categories you require for these classifications, and drag the classification into the table.If you do not do this, records will be counted more than once because sub-totals and totals are included in these classifications, and all levels will be added together. Even if these classifications are not required in your table, overcounting will occur unless you select only the total category and drag this into the table. For definitions of which categories comprise the various sub-totals and totals for Type of Work and Type of Building, see the attached document 'Definitions of Totals'.
2. Reference Month should be brought into the table. Without this, all time periods will be added together.
3. The Statistical Local Area data cubes contain a hierarchical classification for Area, which means that the classification can have a number of levels e.g. State, Statistical Local Area. If nothing from this classification is included in the table, all levels will be added together. Make sure you at least include a total from this classification.
Best practice is to make sure all fields are selected and put into the table.
For technical queries relating to data cubes, please refer to the contact details in SuperTABLE Help. For any queries about the Buildings data in the cubes, please contact Louise Wilton on (08) 8237 7629.
Explanatory Information (these attachments are free):
Specific information regarding Building Approvals Excel Data Cubes
Explanatory Information (this attachment is free):
General information regarding Data Cubes
Volatility of Statistical Local Area data
Note that the estimates for small areas vary from month to month and caution should be used in drawing conclusions from monthly movements.
REVISIONS THIS MONTH
Revisions to Total Dwellings in this issue are: