Apr
23
Mapping Iowa ... in Excel
I popped over to Iowa just before the causus in January to play with some data for one of the presidential candidates. One thing that has always irritated me is how difficult for most people to get access to a decent map of data.
We were looking forward to the causus and how it might turn out, based on campaign data and trends. We were interested in running some scenarios by precinct and looking at the results by county. A table is the usual way to do this, but it is 100 times easier to visualise and understand the data if it is laid out on a map.
Usually I would have used a GIS program, but I was using a laptop where I can't install programs and i had 24 hours in Iowa to visualise some data and leave a tool there for the campaign to use on election night.
Here's what I built ...
We were looking forward to the causus and how it might turn out, based on campaign data and trends. We were interested in running some scenarios by precinct and looking at the results by county. A table is the usual way to do this, but it is 100 times easier to visualise and understand the data if it is laid out on a map.
Usually I would have used a GIS program, but I was using a laptop where I can't install programs and i had 24 hours in Iowa to visualise some data and leave a tool there for the campaign to use on election night.
Here's what I built ...