Thursday, September 27, 2012

Are the Data Analytics programs, reports and spreadsheets overwhelming you?

After all the data analytics are completed and the reports submitted, is the impact of what is happening in your market clear? If the answer is no, then maybe you should “look” at the data in a different way. Use the location component of the data to create a picture that everyone can understand.

The simplest way to create a picture is to put the data on a map. Now you can see where your customers are located. More detailed data analysis is possible when this information is combined with a layer that shows population trends, distribution of income and any other attributes that are applicable. Viewing and sharing the map is easy. Google Earth is an excellent platform for displaying data and distributing it to everyone in your organization.

Most of the data needed to create this type of display is probably already available in a customer information spreadsheet or database file. The first step is to clean the file of duplicates and geo-code the entries. Other sources of information or attributes can then combined with the file. The next step is to create KML files that are compatible with the Google platform. Finally, display the information and distribute it.


Data analytics from customer files produce information that is invaluable. In order to reap its full benefits, the information must be presented in a format that is assessable to all the stakeholders. The choice is clear, a report and a chart, or a map that displays the information.

Send us your data and we will transform it into information.