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 MBO. 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 MBO 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.
Many of us break out into a cold sweat at the mention of those two words – Database Management. No worries. MBO’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 Business Online is a cloud-based business mapping software service. We do not categorize MBO 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 MBO’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 MBO sales territories. Pull in population or median income from MBO’s 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, MBO 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.
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 MBO map layers. Create data queries showing all ZIP codes per territory, add population or median income data and export for use outside of MBO.
I bet MapPoint never did that for you.
Calculated Data by Column
On occasion, MBO’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 MBO, 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 MBO 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 MBO. Your unique data calculation is available throughout the business mapping software.
Map Business Online database management options are advanced, simple and available for MBO 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 firstname.lastname@example.org or Jason Henderson email@example.com