What's the easiest way to map a bunch of data?

I have city/state, sales $, and time spent on service.

I'd like to see if 1.) service time is in the areas where the $$ is and 2.) if service personnel are located where the need is.

I'd also like to add 3rd or 4th dimensions to scale sales (bubbles or dots of varying size) and color to split service and/or customers by type/catagory.

I don't have Map Point. I'm really hoping to find a free Excel add-on or something internet based.

 

Pivot Table in Excel?

 

What I want to do is take the data put it on map of the SE US. I want a visual of the concentration(s).

Right now it's just an Excel table. Not pivoted. I can manipulate/organize the data.

What I can't do (yet) is put that infomation on a map.

 

Well besides map point I don't know. There may be some program that adds a layer over google maps

 

I downloaded the 60-day Map Point trial. If it works out, maybe I'll just buy a copy.

 

Map Point looks like it'd work, but I have to slice & dice my data a bit more to get the other dimensions. Which is fine.

Too bad it retails for ~$300 .... .

 

Sign up for technet standard for $200 and get it for free. Though you'd technically be violating the EULA if using it for business.....

 

Well, I think I'm going to have to break down and buy a copy. Found some on ebay (non-academic) for ~$150 - $200.




Bubble size = $
Bubble color = type
Background = drive time map
etc.

Nice tool.

 

There are quite few free options... In the past I've done similar things with Google Charts:
https://developers.google.com/chart/...llery/geochart

Also, ManyEyes (but realize your viz will be public - you can obfuscate labels to get around privacy issues):
http://www-958.ibm.com/software/data...ounty_Map.html

A couple I've never used but have meant to look into are OpenHeatMap (http://www.openheatmap.com/) and GeoCommons (http://geocommons.com/)