(Gov) Affordability Planner

Project Info

Macquarian thumbnail

Team Name


Team Members

Mel , Garv , Suyash Pokharel , Proteek , Taylor Chu , jason

Project Description

This is a pilot for NSW, but the project can be scaled across different states in Australia.

Cost of living is a key issue effecting many NSW citizens.

Australia is currently facing high inflation, surging housing demand and increased interest rates. The topic of housing affordability is a 'real' issue that residents are dealing with as they plan for the future of the family. Many residents have recently experienced rental price hikes as NSW tackles the issue of housing availability and landlords struggle to make their repayments.

The NSW Department of Planning estimates that an additional 904,000 homes will be needed over the next 20 years to house its growing population. The majority of planned dwellings will be situated outside of the Sydney CBD, primarily in the Greater Sydney Region.

While there is rich information out there in the public domain, it is complex. When families are time poor and under financial stress, navigating this ocean of data to make an informed choice on their next move is not easy.

How will families decide where to move in the future?
How can families plan for their child's education future with entry into good schooling?

Phase One pilot of the Macquarian 'Affordability Planner' intends to help equip households with the information they require to make informed decisions on their next housing decision. It will provide users with insight into suburbs that are within their affordability range enriched with information on local schools and relative school quality.

Prototype (web UI)

Prototype (App)


UML Class Diagram

Future enhancements for family planning decision data may include a better indication of:
• Localised cost of living by relying on information such as fuel prices and greenslip registration.
• Insight into infrastructure pipeline for planned developments of new schools or care facilities.
• Job data to provide a view of job vacancies.
• Availability of social or affordable housing in the future.

Multi-State Scaleability - TAS, VIC, SA, NT, QLD, WA
This current pilot ingests data primarily focused on the NSW state. The societal problem of Housing Affordability is not unique to NSW alone.

Current schools data is available nationwide and can be easily scalable apply for other state-based data sets.

Sample website for Tasmania: https://proteek-dev.github.io/affordability-planner/tasmania.html

UML Class Diagram

#figma #tableau #data-visualization #education #affordability

Data Story

Macquarian has sourced public domain information from:
• NSW Data (data.nsw.gov.au)
• NSW Family & Community Services (facs.nsw.gov.au)
• Australian Curriculum, Assessment and Reporting Authority (acara.edu.au)

Detailed information on average rental prices, school location and school quality have been ingested into a Tableau dashboard to provide a geospatial heatmap of potential 'affordable' suburbs along with available schooling.

Users can expect to interact with the application via a Desktop and Mobile App, input their accommodation needs to have a visual overlay of their affordable areas in the NSW Region. They can then make informed decisions on potential locations taking into consideration convenience factors (e.g. distance from work) while having a list of schools available for their children's schooling needs.

UML Class Diagram

Pilot data constraints
Current school quality ranking is based on publicly available ICSEA score via ACARA.

ICSEA Definition: The Index of Community Socio-Educational Advantage score for the school. This score is derived from a number of variables including parental school and non-school education and occupation, the school’s geographical location and proportion of Indigenous students.

As a proof of concept ICSEA has been utilised for the purpose of assume a 'quality' for a given school that is not ideal. ACARA includes more detailed results of school outcomes (for example 'Average NAPLAN Score'). Due to the sensitivity of the data on individual school performance, the information is not immediately acessible, however accessible via a data request to ACARA. This enhanced data can be scrubbed to provide a generic suburb quality score to improve of the Affordability Checker output.

Evidence of Work



Project Image

Team DataSets

NSW Early Childhood Education and Care Program Locations

Description of Use Early Childhood and Care Program location data integrated into a geospatial map that is combined with average rental costs. Initial test case is NSW state geography.

Data Set

ACARA - School Location 2022

Description of Use School location data integrated into a geospatial map that is combined with average rental costs. Initial test case is NSW state geography.

Data Set

ACARA - School profile 2022

Description of Use School information and ICSEAS score was integrated into other data sets to provide a potential 'scoring' of quality of a school based on the ICSEAS ranking

Data Set

Rent Tables

Description of Use Rental information segmented by dwelling type and location integrated into a geospatial map. Outputs can be filtered by users to provide a heatmap of potential areas suitable for the rental income and linked with relevant school data.

Data Set

Challenge Entries

Cost of Living Pressure NSW

Cost of living is key issue effecting many NSW citizens. What can data such as the rental bonds and fuel price data tell us about the impact and possible solutions?

Go to Challenge | 4 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.