We bet you have lots of lists hiding in every corner of your workflow. Everything from excel lists to big databases, even lists that are copied into word. They do their job to the best of their ability. But what if you want more out of them? Free your data up to see the underlying story that it really wants to tell you. Mapping Your List
It’s one of our most popular requests. We get lists all the time containing everything from employee locations, buildings, competitors and many others. Overall everyone just wants to know the WHERE. It’s the most important thing and we think so too. See that hidden dimension that is hiding in plain site in your lists. Map is out and see where it leads you.
Mapping Your List
So where do you start now that you have that list in hand and you want a map? Let’s start with a format. Easiest and fastest to translate to geographic data is an excel file. Be sure you are using excel as a database and not for printing. Individual data pieces per column are even better. This way the data structure is setup beforehand. Whatever you see in your table you see in the resulting map. Bonus area is any column in the excel file can be used to sort, color, size or label to mention a few. It’s called data driven maps.
The more structure you have in your list the more useful it can be when making a map with it. You can also tell a better story from the data. For example would your list of real estate comps be more useful as dots on a map? Or would it be better to see the dots sized by value and labeled with the date?
We would take the latter. It tells a better story overall. What story can we help you tell by mapping your list?