-
1. Re: London-based BI consultant and Tableau developer
austin.ramos Sep 4, 2012 7:36 AM (in response to Robin Kennedy)Robin,
Good to meet you. I'd be interested in learning more about your capabilities. Specifically, I'm looking to map the migration of sales over a geography within a time frame. That is, I have data for sales by customer, including their address, and I'd like to create a dynamic map that shows, over time, there the sales were made. The goal is to see any trend in where the sales have been generated over time (if the same communities have been purchasing, or if the sales people have had to move from community to community to continue to sell). Please let me know if this is possible via Tableau and, if so, your background. Also, feel free to reach me directly at aramos (at) topspinlbo.com
Thanks for your time.
Best,
Austin
-
2. Re: London-based BI consultant and Tableau developer
Robin Kennedy Sep 4, 2012 9:19 AM (in response to austin.ramos)Hi Austin,
Thanks for your message. On the face of it, your requirement sounds very possible in Tableau and there are a couple of options I can think of to visualise that information and best way will depend on the sensitivity of your dimensions
Tableau's inbuilt geocoding should be able to generate a map for your customer addresses, and providing your data is in the right format, you can aggregate into state/county/zip, and then colour code or create sized dots for the total sale amounts. With maps, the time dimension best comes into play using 'Pages' and you will be able to flick through the days/weeks/months (or whatever granularity you are interested in) and see how the map colours or dots change through animation.
However, using a map like this might not show up the subtle differences you want to see if sales are moving slowly from one area to the next and a more traditional approach using time-series bar charts or trend lines might be better in showing these differences between regions. Perhaps a combination of the map and the charts in an interactive dashboard is an ideal solution.
My background is in data analysis, but not in any one particular industry. I have worked with CRM data, Health insurance data, IT/server generated data, financial data and others.
Regards,
Robin.