Thanks for the reply, It is much appreciated!
Essentially, II would like to create a choropleth map that visually describes the ‘reach’ of a program. i.e. the number of people that have participated in a program in geographic space. At the moment
I am scoping out how to go about doing this so your advice would be greatly appreciated.
The data to be represented will come from registration forms that participants will complete prior to undertaking a webinar. As part of this registration form they will include details of their postcodes.
Because there might not be enough participants to warrant so much granularity, I thought that it would be best to aggregate this postcode data to its corresponding LGA’s.
So far, I have been able to assign mock postcode data to its concomitant LGA but I have not managed to find a way to map it.
To concord the postcode data to its LGA equivalent I have:
Downloaded the ABS AGS2016 grid correspondences
Added a row with the mock postcode data
Used vlookup and sum if to show how many times a postcode appears in an LGA.
The end result is a two column excel sheet with 1) the LGA (and its ABS assigned number) and 2) the count of postcodes within each LGA.
I have also found on the ABS site the most recent shapefile of a map of Australia with the necessary LGA layer but I have not gone further. I tried to use ESRI online (free trial) to see if I can
load that layer and play around with it (I.e. link the excel file to the shapefile) but I could not even go through that initial step of loading the layer.
I was wondering if this is the approach that one should take given my stated goal. Also do you have any advice on how to go about the last step of mapping the data without having to spend money on
a mapping program? I have been reading up on QGIS for example. Would you recommend it?
Thanks in advance for your response.