I have a database of 599 different customers purchase postcodes, located around the north of England. Some customers have purchased 1 item, others have purchased more.
We need this database condensing. It is currently arranged by postcode - so one city can have many different postcodes, but we only care about the total amount of sales in each particular city or town.
We want to be able to look at an overview of England with totals of number of items sold in each geographical town / city. With this data we will be able to see where best to concentrate out advertising.
Please see attached an example of current data and an example of how we would like it to look.
26 freelancers are bidding on average $348 for this job
Hello, I'm a specialist in mapping and geographic data. Your project sounds quite interesting for me. More details in a private message. Thanks, Alex.
Proffesional GIS data and mapmaking specialists at your service. More info in PM. There is no example of how you would like it to look (missing second example).