2 Replies Latest reply on Oct 8, 2013 1:23 PM by Allan Walker

    clarification reg. maps please ..

    jagam jaga win

      clarification reg. maps please ..

       

      tableau can geocode upto MSA level and not street level.
      However if the geocode is provided then yes upto street level
      Correct ?

       

      tableau does not reveal geocodes. so we can't compute distances
      so only option left is procure geocodes externally and import them
      Correct ?

       

      I am using Mappoint for Geo targeting on spreadsheet

      Is mappoint ( Microsoft) more reliable than tableau maps.

       

      I need to drill down from country>state>city>zipcode on a map
      without creating multiple maps for each hierarchy. possible?

       

      Can I show time trends on the map.. from 2005 till date monthwise for one category

       

      forecasting
      Can you please suggest useful links for creating forecast

        • 1. Re: clarification reg. maps please ..
          Shawn Wallwork

          Hi jagam, I'll answer some of these, but it's really a lot of question for a single post...

           

          post.user_wrote.label:

           

          clarification reg. maps please ..

           

          tableau can geocode upto MSA level and not street level.
          However if the geocode is provided then yes upto street level
          Correct ?

           

          If you provide the lats/longs for your locations T will map them.

           

          tableau does not reveal geocodes. so we can't compute distances
          so only option left is procure geocodes externally and import them
          Correct ?

           

          You can't use Tableau's generated lats/longs in a calculated field, but you can export them to an Excel spread sheet and them bring them back in and use those to calculate distances.

           

          I am using Mappoint for Geo targeting on spreadsheet

          Is mappoint ( Microsoft) more reliable than tableau maps.

           

          Pass, (expect to say Urban Mapping does an excellent job providing Tableau's maps, their servers are hardly ever down. And best of all they are native to Tableau).

           

          I need to drill down from country>state>city>zipcode on a map
          without creating multiple maps for each hierarchy. possible?

           

          In Tableau you can drill-down country>state>county>city. Or you can drill-down country>zip. This is because ZIP Codes don't respect the other geo borders (zips cross county/state lines)

           

          Can I show time trends on the map.. from 2005 till date monthwise for one category

           

          Yes. You use the page shelf to do this.

           

           

          --Shawn

          • 2. Re: clarification reg. maps please ..
            Allan Walker

            jagam jaga win wrote:

             

            1.  tableau can geocode upto MSA level and not street level.
            However if the geocode is provided then yes upto street level
            Correct ?

             

            2.  tableau does not reveal geocodes. so we can't compute distances
            so only option left is procure geocodes externally and import them
            Correct ?

             

            3.  I am using Mappoint for Geo targeting on spreadsheet

            Is mappoint ( Microsoft) more reliable than tableau maps.

             

            4.  I need to drill down from country>state>city>zipcode on a map
            without creating multiple maps for each hierarchy. possible?

             

            5.  Can I show time trends on the map.. from 2005 till date monthwise for one category

             

            6.  forecasting
            Can you please suggest useful links for creating forecast

             

            1. You can geocode anything you want.  You can choose to use Tableau's built in geocode, or use custom geocode, or pre-process.  I use ESRI instead for this. Just remember to use the same datum as the background map provider.
            2. Use =ACOS(COS(RADIANS(90-Lat1)) *COS(RADIANS(90-Lat2)) +SIN(RADIANS(90-Lat1)) *SIN(RADIANS(90-Lat2)) *COS(RADIANS(Long1-Long2))) *6371, pre-process is optimal
            3. Whatever floats your boat.  I'm not going to bite about reliability, depends what you mean
            4. Yes it is possible, but not with built in hierarchies or filled map mark type.  Only with dummy hierarchies and pre-processed shapefiles
            5. Yes, that's what Tableau does well, and the whole point of combining GIS and BI
            6. Built into Tableau is an expediential smoothing model.  Personally I tend to pre-process using CAGR.  I would however like to forecast Cartesian co-ordinates...now that would be special...