In a few past posts I explored the data on London Fire Brigade incidents, and given the wealth of interesting informtation it contains (more for identifying anecdotes for the pub than anything else) I may return to the theme again.
However, what really got me thinking was the number of ways that you can present data to try and get a message across. Very often a table is the easiest, albeit least sexy way of doing this. However, when there's a geographic dimension, I think a map can be very power if done well, but one's ability to do this may be constricted by available software. However, with a little time and patience, and using what you do have available, you can start developing ideas.
Read more »
Showing posts with label conditional formatting. Show all posts
Showing posts with label conditional formatting. Show all posts
Creating maps in Excel pivot tables
When I can't be bothered doing something because it's too much hassle, I like to find a work around and data analysis is no different. When I was looking to plot fire brigage data onto a map, I faced having to convert 23,000 coordinates from the Ordnance Survey National Grid into the cartographic map projection used by google maps if I would be able to plot them without buying some fancy pants GIS software. Using my knowledge of MS Excel, I was able to achieve exactly what I wanted to in less than five minutes.
Read more »
Subscribe to:
Posts (Atom)
