The Powerful “More Data” Button

The Map Business Online Data Window contains a powerful function available with every datasheet view.  From the master toolbar click the Data Window icon and select any of the data drop down options in the upper left.  Now, cast your beady eyes down to the lower right-hand corner of the Data Window where you will find the deceptively simple More Data button. This button is a gem of a business mapping tool

More Data could be the most powerful function available in Map Business Online.  It is no less than a geospatial database management tool.  No matter what data layer you happen to be viewing in the Data Window, clicking More Data opens up an easy-to-use database management tool that allows the Map Business Online user to add or remove data layers to the datasheet view.  More Data is especially useful for Sales Territory Mapping.

Clicking More Data opens a database selection panel listing additional data column options that you can add to your analysis. Additional data options are listed on the left side of the panel. Your existing data columns are shown on the right.  By selecting and moving the available columns, using the move arrows in the middle section, the user can change the data layers available for any business analysis.

The More Data Button – lower left

Many of us break out into a cold sweat at the mention of those two words – Database Management. No worries. Map Business Online’s more data is a simple tool you’ll be hard pressed to break.  You’ll find a variety of easy options for adding data to or removing data from your analysis.

Map-Based Analysis

Map Business Online is a cloud-based business mapping software service. We do not categorize Map Business Online as a Geographic Information System (GIS).  GIS is more sophisticated and can provide advanced and complex data analysis. That said, a simple tool like Map Business Online does offer some basic geographic analysis tools one of them being More Data.

Any business map is going to include a dataset of ZIP codes, Counties, States and perhaps other administrative district layers. These geo-databases are natural location-based data structures for visualizing demographic data, sales data, and marketing data. It just makes sense to view USA Census data against a data layer of ZIP codes or counties.

The More Data button, in Map Business Online’s Data Window, is the tool that opens up options around the merging of these symbiotic data layers. With more data you will be able to:

  • Add or remove associated data layers to sales territories. Pull in population or median income from included demographic data options.  Move imported data columns like monthly sales results or marketing response rates into your sales territory analysis.
  • Simplify map-based analysis by removing superfluous data layers. Imported data, Map Business Online default data, heavy datasets; they can all get really complicated. Make analysis easier on the eyes for your map viewers by removing data columns that do not add value to your project. Remember, in mapping less, is often more.
  • Add selected data layers and conduct filter queries. Find out how many territories contain accounts that purchased XYZ product last year. Import that data layer using More Data, then use the Data Window filter to determine which territories could stand to benefit from marketing support.

The More Data Database Management Panel

It’s All Exportable

Keep in mind, all of this database work is exportable. Simply click the rightmost button on the Data Window toolbar to export the results from your Data Window view to CSV file.

This means you can export compiled data from your project – perhaps your own data supplemented with demographic layers and Map Business Online map layers. Create data queries showing all ZIP codes per territory, add population or median income data and export for use outside of Map Business Online.

I bet MapPoint never did that for you.

Calculated Data by Column

On occasion, Map Business Online’s More Data functionality can be used to set-up even more interesting data operations. For example, a customer could import a dataset that includes a unique segment of the general population – owners of Toyota sedans by county.

Using the More Data button, the ZIP code layer could be selected, and that unique Toyota Sedan population could be added as a column to the ZIP code data layer. That data layer could be exported and reimported as a new data layer in the application, allowing the data to be accessed through ZIP code functions.

Now, with the data accessible, another powerful operation can be generated using the Toyota Sedan owners by ZIP code column. Within Map and Data, the ZIP Code layer is selected by clicking the Property Edits Gear. Each map layer has a function in Map & Data called Calculated Data Columns. It offers summation, multiply or divide operations to be associated with that geographic unit – in this case ZIP codes.

The Map Business Online user chooses to open Calculated Data Columns. Here the Toyota Sedan Owners data can be selected and applied as the Dividend in a division operation where the divisor is the Demographic Data Population, resulting in a ratio of Toyota Owners to the general population. Once created, Calculated Data Column data can be brought back into Data Window Analysis views or used to color code map layers or supplement data layer labels in Map Business Online. Your unique data calculation is available throughout the business mapping software.

Map Business Online database management options are advanced, simple and available for Map Business Online users to apply to their business challenges. Get creative and see what more you can derive from Map Business Online.

Win a $20 Gift Card! Refer a business associate to Map Business Online in exchange for a $20 Amazon Gift Card!

Find out why over 25,000 business users log into www.MapBusinessOnline.com for their business mapping software and advanced sales territory mapping solution. The best replacement for Microsoft MapPoint happens to be the most affordable.

Contact: Geoffrey Ives geoffives@spatialteq.com or Jason Henderson jhenderson@spatialteq.com

 

This entry was posted in Business Mapping Software blog post, How to instruction and tagged , , . Bookmark the permalink.

Leave a Reply