The Powerful “Choose Columns” Button

The MapBusinessOnline 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 Choose Columns button. This button is a gem of a business mapping tool

Choose Columns could be the most powerful function available in MapBusinessOnline.  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 Choose Columns opens up an easy-to-use database management tool that allows the MapBusinessOnline user to add or remove data layers to the datasheet view.  Choose Columns is especially useful for Sales Territory Mapping.

Clicking Choose Columns 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 and for any MapBusinessOnline map layer such as ZIP codes.

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

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

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 Choose Columns button, in MapBusinessOnline’s Data Window, is the tool that opens up options around the merging of these symbiotic data layers. With Choose Columns 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, MapBusinessOnline 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 MapBusinessOnline map layers. Create data queries showing all ZIP codes per territory, add population or median income data and export for use outside of MapBusinessOnline.

I bet MapPoint never did that for you. (Stuck at MapPoint 2010? Take the free trial.)

Calculated Data by Column

On occasion, MapBusinessOnline’s Choose Columns 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 Choose Columns 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 MapBusinessOnline 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.

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

We recommend users access MapBusinessOnline via the downloadable Map App.

The Map App install is fast and easy. The Map App is a cloud-based service, once you’ve logged in you’ll have access to all of your previously saved maps and data. The Map App is a better user experience and provides access to more features than the Web App. The Flash-based Web App link will remain available until December 15, 2020.

The Map App includes the new Map Viewer app for free non-subscriber map sharing.

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