Bearcat94

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.

#1 STUNNA

Pivot Table in Excel?

Bearcat94

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.

#1 STUNNA

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

Bearcat94

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

Bearcat94

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 .... .

#1 STUNNA

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.....

Bearcat94

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.

einsatz

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/)