So I have been tasked to create a visual map of case volume shipped to each region from each of our warehouses. I think the most effective way to visualize this data is to create an intensity (bubble) map based on total shipped volume to each city. I know in my head of what I want to see but not sure what program is best to visualize this data. I have access to Microsoft Map Point 2006. I was thinking maybe Google Fusion Tables could also translate this but I have never used that tool.
Ideally, I was thinking if i can have a radio button that represents inbound (like stock transfer orders) /outbound orders (customer orders), then a drop down for the warehouse selection, and have a map automatically generate the intensity/bubble map, would be great.
I currently have my raw data in excel, I can pivot the data with the warehouse as a filter, and sum of cases by city & state. Does anyone have any suggestions or recommendations of free software that can be used? Thank you!