How to Build a Dot Density Map

A dot density map is a classic business data visualization exercise. Business data visualization is probably the most common and straight forward way to apply business mapping software to your business.

Many companies ask how to import and view customer data in a way that helps them understand more about their business. The dot density map is one of the easiest and most helpful maps to create for visualizing business data.


Let’s take a for instance. An MBO user has an Excel Spreadsheet with thousands of customer names and addresses from which she would like to discern where most of their business takes place.


Many companies have only a few hundred customers to locate.  But it’s not unusual to run across customer datasets of five to fifty thousand customers, or even more for large enterprises. Without the benefit of a business map, marketing managers are forced to filter their Excel spreadsheets to compile segmented customer lists for action. Spreadsheet lists do not display patterns the way maps do.


A business map ingests your customer lists and then distributes them across the coverage area of your business based on address. Map layers are turned on to enhance your customer list against a variety of background layers:

§  An accurate street map view lets you view major roads, rivers and mountain chains impacting customer access

§  Satellite and aerial background views can add building views and landscape details like tree canopy

§  A ZIP code layer allows your map analysis to compile customers by ZIP code or create territories

§  Counties and states provide similar but larger area designations for coverages and territories

§  ZIP, county, Census Tract & State layer enable the inclusion of demographic data, at times critical to an understanding of your market and the development of an optimum customer type

Regardless of which background map layers you choose to work with, a Density Map view offers a true visualization of where your company is doing business.

The Dot Density Map Solution

Import your address database of customers and apply a small dark symbol to all the customer locations. Tweak the size and color to your liking and sit back and view your dot density map.


How to Create a Dot Density Map

1.       Gather an address data base or Excel spreadsheet of your customer locations. Arrange separate columns with headers for location data: Name, Address, City, State, and ZIP code.

2.       In the Map Business Online master toolbar click the Plot Data on Map button    Browse to your data and click next. Verify location columns are accurately matching the map applications address buckets and adjust as necessary. Click Next.

3.       Choose Company Name or a similar assignment for the name column. Assign columns of your choice to the five label flex field options. Process the imported locations points to the map by clicking Plot.

4.       After importing MBO opens the Data Window, with your imported data selected. In the Symbol Selector Drop Down located on the left of the Data Window toolbar, choose a small black dot for your location point on the map. Increase its size to 80% – more or less, to your liking

5.       Sit back and view your customer data on a USA, Canada, or UK base map and think about the results.

Viewing a dot density map exposes areas of concentration – data dots build up in some spots and don’t exist in others. Typically, these areas of concentration are populated, urban areas. But that really depends on your data. In your particular case, data may be concentrated in rural areas – dairy farms, deer fields, and snow mobile repair businesses may tend toward rural placement.

View your data with an open mind and an eye for patterns. Business maps are trying to tell you something.

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

Contact: Geoffrey Ives geoffives@spatialteq.com or Jason Henderson jhenderson@spatialteq.com (800) 425-9035

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

Please read customer reviews or review us at Capterra, or at the Salesforce.com AppExchange.

 

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

Leave a Reply