Community Needs Navigator

Project Info

Millennial Snowflakes thumbnail

Team Name


Millennial Snowflakes


Team Members


Michael , Ashleigh Latter

Project Description


People and businesses are struggling with the cost-of-living crisis – but how can we find them and support those in need?

Community Needs Navigator (CNN) is a tool to assist governments and charities allocate resources to the areas that need it the most.

CNN leverages ABS and Regional Data Hub data to segment the Australian population into 9 distinct groups which differ in terms of age, household income, socio-economic status, cultural background and more. These groups can be used to identify areas in need quickly and efficiently. In addition, the segments are combined with unemployment rate data and industry employment information for a comprehensive view of each area.

The tool includes tables and charts highlighting the differences between segments so that individuals can gain a detailed understanding of the characteristics of each group, and which segments are ones to focus attention on.

Once segments of interest are identified, the Suburb Identifier section can be used to find all relevant postcodes so that action can be taken. For example, if you are a charity operating in Victoria and Tasmania, you can select VIC and TAS from the state dropdown menu, and the population segments of interest in the segment dropdown menu. The table will then display all relevant postcodes and associated information so that action can be taken.

The CNN tool includes three components:

  1. Geographies: This section shows a colour-coded map of Australian postcodes, where each colour represents a different segment of society. By clicking on a particular area, you can drill down and retrieve location-specific information such as average rent payments, household income and most common industry of employment, as well as the area’s unemployment rate and number of businesses employing staff in each industry.

  2. Segment Analysis: Here you can build a more detailed understanding of each segment by exploring how they vary by variable and comparing them. For example, if you select segments 4 and 9 and view the Household Income tab, you can see that these segments are almost completely opposite in income – segment 4 primarily high incomes, and segment 9 generally has lower incomes.

  3. Suburb Identifier: Use this section to search for states and segments of interest to find all the relevant postcodes, and view information about those areas.


#costofliving #governmentsupport #localindustry #decisionmaking #socialgood

Data Story


We join location, demographic and industry information from the ABS and Regional Data Hub to create nine distinct segments using k-means clustering. Some data is only available at the Statistical Area Level 2 level, so data is joined to postcodes to provide information at the suburb level. ABS postal area shapefiles are used to show locations on a map, and data is joined to the shapefiles to display additional information interactively.


Evidence of Work

Video

Homepage

Project Image

Team DataSets

ABS - Counts of Australian Businesses, including Entries and Exits (Jun 2018 - Jun 2022)

Description of Use Matched to postcodes and used to plot the number of businesses employing staff in each industry when a specific suburb is clicked on the map

Data Set

Regional Data Hub - SALM Smoothed SA2 Datafiles (ASGS 2016) - March quarter 2023

Description of Use Used to plot unemployment rate by suburb, and unemployment changes over time are input into a machine learning model

Data Set

Postal Area, Indexes, SEIFA 2021

Description of Use Used in a machine learning model to segment the Australian population and display relative socio-economic scores to help allocation of government spending and charity activities.

Data Set

2021 Census of Population and Housing - Census TableBuilder Basic

Description of Use Used in a machine learning model to segment the Australian population. Also used to link Statistical Area Level 2 codes to Postcodes.

Data Set

Australian Postcodes

Description of Use Used to extract the suburb name(s) of each postcode for display, as well as identify the postcode centroids in latitude and longitude for the "search postcode" feature

Data Set

Postal Areas - 2021 - Shapefile

Description of Use Used to plot the boundaries of each area on a map

Data Set

Challenge Entries

Best Creative Use of Data in Response to ESG

How can you showcase data in a creative manner to respond to ESG challenges? How can we present and visualise data to stimulate conversation and promote change?

Go to Challenge | 33 teams have entered this challenge.

Finding potential donors to support families in need

How can we identify where families who might have second-hand baby and children's goods to donate live, and estimate the volume of goods that could be donated to families in need through organisations such as Roundabout?

Go to Challenge | 10 teams have entered this challenge.

Using open data to support Tasmanians

Rises in the cost of food, rent, and petrol have caused Tasmanians to draw on accumulated savings or term deposits to manage expenses. How can we use open data to identify areas where government support would be most impactful to support Tasmanians with the rising costs of living?

Go to Challenge | 4 teams have entered this challenge.

Exploring relationships between industry and population in regional Australia

Regional liveability is influenced by the diversity and stability of local industry. People need employment to stay and be attracted to move to regional Australia. Businesses and industry adjust with market interest but how does this affect the local population – do they adjust too?

Go to Challenge | 7 teams have entered this challenge.