While there’s no arguing the fact that Excel and other spreadsheets are powerful tools that can be used to carry out various data analysis, there is only so much it can do when it comes to working with geographic data.
Our tools can help you to unlock the mystery and insights hiding deep behind geographic data that your spreadsheet might not scratch past the surface.
You can as well say our intelligent tool help you to make the connection or find the meaning in your location data.
Your spreadsheet comes with tons of functions and features that are quite useful to analyze data. And while it can help you come with various infographics to further explain your data and provide a little more insight than what you’d get from looking at a spreadsheet, it is quite limited to what it can help you achieve if you’re dealing with a geographic data.
Showmymap helps you easily discover and convert location fields within your data (zip codes, postal codes, addresses, city names) into coordinates, which is plotted onto a map for you to view and share with others to use.
Filter by Specific Groups of Data
While visualizing your data on a map can provide you with a lot of insights, our multi-level filtering feature makes it easy for you to go a level deeper to gain a much deeper and useful insight.
For example, check out this map which comprises the education and incarceration data from all of the states in the USA.
While clicking on each marker would give you access to more data via the marker box, there’s so much information you can get just by using our grouping feature. For example, selecting a specific range of high school graduation, say, the lowest rate – 79.982.1%, every other data outside this range becomes hidden from view. This can help you reduce noise drastically and make an otherwise subtle connection, clear.
You can use the filtering feature to create multiple levels of grouping. Using the same map above, you can use it to gain insight into the relationship between the influence of education and incarceration rate.
If you switch the prisoner’s rate to 100K in the lower left menu while keeping the 79.9 – 82.1% high school graduation rate selected, you will notice that the lowest rates of incarceration aren’t visible as they’re not available.
From this, you can deduce or fairly assume that fewer high school graduates correlate with higher incarceration rates. While this might or might not paint the full picture, you can see how easy it is for you to make various connection and deduction, which might open the way to more insight or research.
Display Dense Markers As Intelligent Clusters
Another method of visually understanding your data and gaining more insights is to use our map marker clustering feature which can also help you determine the number of points in a region.
When you enable the map marking clustering features, you get cluster circles that are displayed with a greater diameter with the presence of more markers. You can also view the frequency of a data within your current field (in the form of a pie chart) if you have additional data in your map.
Using a map of NASCAR that display areas of fatal crashes, you’ll notice the events are mostly situated around popular circuits where races occur. The pie chart beneath the clusters refers to the year ranges below. Change the field in the lower left section and the data in each cluster’s chart will also be updated. However, the count of events within the cluster remains the same.
Average and Sum in Areas
A commonly used and quite popular function in a spreadsheet is the “Average” and “Sum” functions. Showmymap also possesses a similar function, which it intelligently use in making your map for you. You can aggregate the values of a specific field and output it as a label for each cluster with the aid of the advanced clustering feature.
To illustrate this, here is an analysis carried out on median household income by United States counties. As you can see, regions are clustered together with counties averaged and as you zoom in (or click on a cluster), smaller clusters begin to appear, which shows how the smaller regions contribute to the overall average.
Determine The Distances Of Other Points From A Single Location
The Showmymap intelligent tool can help you determine the distances of various positions from a single point. Say, for example, you’d like to show the distance of your customers from your office.
In a situation like this, you will need to input your office location in the first row in your spreadsheet (after headers) while you input your customer data below your office location.
Copy the data from your spreadsheet and paste it into our mapping tool. In Advanced
Options, select “Calculate (straight line) distance from the first address.” Now your map will display markers according to the distance from the office location.
This example (map) uses the distance feature to display the major earthquakes in California relative to San Francisco. And as you can observe, you’ll see a handful of locations nearby where earthquakes occur. You’ll also see other areas in the uppernorth and southern California with a similar number of quakes.
Analyze Your Data Now
It’s time to take your spreadsheet and perform data analysis with the visualization tools provided by DivShare.