Mapping your excel spreadsheet transforms your location-based sales data into live, interactive maps which you can share with your team. Reporting on sales performance can be gruelling, especially when you’re looking at local, regional, and national figures. In addition to reporting on the final figures, you need to compare performance of over 100 sales reps across 50 states by analyzing 300,000 sales records. This results in multiple worksheets with thousands of records that you need to wade through in order...

Last week we talked about the reasons your business should use mapping software and how mapping for business can lead to success. This week, we’ll talk about the type of data that you can map and how best to prepare it for mapping software. With mapping software like ours, you can upload any type of data so long as it contains location information. You might be thinking that a lot of your data might not be suited for maps, but you...

Bubble maps are one of the best ways to communicate proportional location-based data in a clear and concise way. Like Heat Maps, Bubble Maps summarize your data by regions, different circle sizes represent different value ranges; the large the circle the higher the aggregate value for that region. For Example, to quickly identify and analyze the volume of sales, or customers in each state or sales territory, analyze performance over regions, and gap analysis. Bubble maps are great for attaching...

This article was last updated September 2014 Data plotting errors usually occur in eSpatial for one of two reasons. Both types of errors are easily corrected. The two types of data plotting errors 1. The Excel file you are trying to upload is not a .xls, .xlsx or .csv file. This results in this type of message: 2. The data within the eSpatial file contains errors in a location element column (address, zip code, state, etc.). Correcting these type of...

This article was last updated June 2015 If you have an eSpatial Team or Enterprise license, you can avail of the Groups & Users functionality, for collaborative mapping. This allows complete control over who sees your Excel datasets and maps - and who can edit them. Step 1: Add a Group Open the map you want to share. Click on the shaded dropdown username button (top right of screen) and select Manage Group & Users. On the next screen, you...

This article may quote data or refer to features or workflows no longer applicable to the current version of eSpatial, which is updated every 6-8 weeks. Please refer to our help section for more up to date information The map we created for St. Patrick's Day is a great example of what eSpatial can do - quickly and effectively. Here's a step-by-step guide on how it was done. 1. Get the data you want to put on a map In...

A powerful feature of eSpatial is its data filtering capability. It allows you to narrow your focus to get to the data you really want to look at. In eSpatial you can filter your table of data in the same way you would in excel. Filtering your data while it is already plotted on a map allows you to create multiple views of the same data that you can share with various colleagues and team members depending on what they...