Unearthing the rough diamonds of Census data

1. Unearthing the rough diamonds of Census data

2. Census data structure Dwellings • Internet, number of bedrooms Families • Family type, family income Persons • Age, birthplace, marital status DWELLINGS FAMILIES Persons PERSONS

4. Relationship between levels Dwelling Number of bedrooms, Tenure type, Internet, Dwelling structure, etc. Family 1 Couple family with children Family 2 Lone parent family Peter 37 Frank 40 April 8 Mary 38 Jack 12 Luke 6

5. User defined fields • Creating new variables by tailoring and combining existing variables

6. Example 1

7. Example 1

8. Example 2

9. Example 2

10. Example 2

11. Example 3 Housing Utilisation The Canadian National Occupancy Standard (CNOS) • no more than two persons per bedroom • children less than 5 years of age and of different sexes may reasonably share a bedroom • children less than 18 years of age and of the same sex may reasonably share a bedroom • single household members aged 18 years and over should have a separate bedroom, as should parents or couples • a lone person household may reasonably occupy a bed sitter Dwellings where this standard cannot be met are considered to be overcrowded.

12. Example 3

13. Example 3

14. Mining the Census diamonds • Do it yourself - Census TableBuilder • Basic (free) • Pro $ • Ask ABS to do it - Information Consultancy Service $ • Build it yourself - Census Datapacks (free download)

15. Questions ? Come and meet us in the Connect space.