Summarize Your Data by Zip Code, County or State Map Layer


New to our blog? Each week we try to talk about Map Business Online features or real world applications of our business mapping software. Occasionally we might touch on a subject outside of business mapping software. We try to keep it light and quick. You should find a video or map samples to help explain things. Some times we get silly – apologies for that.

We view Map Business Online as an affordable business mapping solution helping basic business users to access the power of location-based or geographic views of their business data. The tool is used for sales territory creation and management, business analysis, strategic and operation planning. These map data visualizations are most often accessed by simply importing an Excel spreadsheet of your business data. The tool includes demographic data, a variety of geographic map layers like zip codes and Census tracts, and comprehensive help documentation with links to our growing YouTube video library.

A few weeks back MapBusinessOnline.com experienced one of our regular quarterly updates. One of the new features was the ability to summarize data by County, State or Zip code.

Summary data is nice to include in reports or business presentations. Summarizing both visually and using a numeric table gives you a couple off different approaches for communicating information to your business map audience.
SummarizePic
This capability to summarize data was inserted into the first page of the Color Code by Point, Color Code by Circle, and Color Code by Chart dialogs. This new option confused a few people, who were used to starting with the select data column option. If you want to use the Color Code by Point option in your usual way just click Next at the summarize page and carry on as usual.

However, if you’d like to summarize sales dollars by state and data count by county, for instance, choose county as you pass through your summarize by geography option. By doing so, all of the points associated with a county will be consolidated into one point for each county. You could then choose to color code by map layer for the state layer and summarize numeric values by state as well. In this way you could summarize dollars by county and total count by state or some other really cool combinations. See the video for a demonstration.

Summarizing your data by geographic districts means the color coding process will consolidate your imported data by district and place one point in the middle of that district instead of a group of points, like the address points in your data. So, if you summarized 1000 address points of sales data you’ve imported for New England by state, then all your records would be summarized for the six New England states by placing six different colored points across New England.

There’s an additional Map Business Online Summary option you can choose, that’s also new. If you are viewing imported data or a territory in the Data Window, you’ll notice a Summary button on the lower right. Look for the Sum button – Summary in the lower right. Upon opening the Summary function in the data window you will be presented with the opportunity to import data from our demographic library or from data that you may have imported. Add these to your summary column as required and then export. This is another great tool for generating reports that sum up data columns based on the geography you have defined in the data window via query results.

The next time you fire up Map Business Online be sure to explore summary options for syMap Business Onlinelization and for summary reporting. They are both nice tools to have in your bag of business map tricks.

Find out why over 25,000 business users log into MapBusinessOnline.com

Contact: Geoffrey Ives geoffives@spatialteq.com (800) 425-9035, (207) 939-6866

MapPoint users – please consider www.MapBusinessOnline.com as your MapPoint Replacement.

Please read customer reviews or review us at Capterra, or g2crowd

This entry was posted in Uncategorized and tagged , , , , , , , , , . Bookmark the permalink.

Leave a Reply