Reposted from Chris Webb's blog with the author's permission. Sometimes you find a tool that is so cool, you can’t believe no-one else has picked up on it before. This is one of those times: a few month or so ago I came across a new tool called Layerscape ( http://www.layerscape.org ) from Microsoft Research which allows you to overlay data from Excel onto maps in Microsoft WorldWide Telescope ( http://www.worldwidetelescope.org ). “What is WorldWide Telescope?” I hear you ask – well, it’s basically Microsoft Research’s answer to Google Earth, although it’s not limited to the Earth in that it also contains images of the universe from a wide range of ground and space-based telescopes. It’s a pretty cool toy in its own right, but Layerscape – which seems to be aimed at academics, despite the obvious business uses – turns it into a pretty amazing BI visualisation tool.
Step 1 Select Start > All Programs Geoserver 2.0.2 > Start GeoServer . A command window opens and runs setup procedures, ending with ConfigurationLoader completed . Step 2 Start Tableau Desktop. Step 3
You can assign Geographic Roles to fields that contain geographic data such as country/region names, state names, zip codes, and so on. Fields with a Geographic Role will automatically generate longitude and latitude coordinates for display on a map view. Tableau automatically assigns Geographic Roles to fields with common location names such as State, County, etc. Geographic Roles can also be manually assigned to fields that are not automatically recognized. Step 1 To start, open Tableau and connect using the included Example - Superstore Sales (Excel) connection.
3 different workarounds to create choropleth maps with Tableau With Tableau Software it is really easy to overlay your data on a dynamic map even without having latitudes and longitudes in the underlying data. However, Tableau does not (yet?)
Hi guys, I was just about to ask this question, and realized there is a good dicussion going on. I am a complete newbie to Tableau, but have mapped data in Arcview. What do I have to fill in polygons here in Tableau - right now, I just want to fil in states. I know you gave a great example, I just need to be explained the process. Essentially, what data files do I need to bring over from Arcview and how do I attach the data in Tableau?
Step 1 Open the .DBF of the output shapefile into a program such as Excel. At a minimum, the file must contain the following fields for correct import into Tableau: [ID] or [ET_ID] - either of these two fields can be used for the Level of Detail shelf [ET_X] - this field corresponds to the longitude coordinate of the record [EY_Y] - this field corresponds to the latitude coordinate of the record [ET_ORDER] - this field contains the draw order of the points and is used in the Path shelf for the polygon Please note that you can change the header names here to be more informative to the Tableau user. When ready, save the updated file to a data source supported in Tableau such as an Excel or Access format.
Step 1 In the Measures pane double-click LONGITUDE and then double-click LATITUDE . Tableau adds Longitude to the Columns shelf and Latitude to the Rows shelf.
A step-by-step guide to Richard Leeke’s TabGeoHack for creating your own filled maps in Tableau Software Way back in 2009, we had a beautiful guest post by Giedre Aleknonyte describing a workaround to generate Choropleth Maps with Tableau (using version 5.0 by the way). Those days are over. One of the major new features of Tableau 7 is Filled Maps (or Choropleth Maps as we used to call them in all blog posts here). Did I say those days are over? Well, not quite.
6 February 2012 ID:G00225500 Analyst(s): John Hagerty , Rita L. Sallam , James Richardson
(perhaps this should be called Business Intelligence – the first steps) Business Intelligence (or Business Analytics) is the process of analyzing data generated in the process of running a business. That analysis will, hopefully, result in information (“information” is data that is useful) that we can use to make better business decisions. I have a Seller’s Account on amazon.com, and over the past 3 years, I have sold 167 items.
This posting will show, and discuss, amazon.com sales data using Tableau for business intelligence analytics. Working from the same amazon.com sales data set discussed yesterday, I constructed a spreadsheet with seven columns: id, Date, Weekday, Time (Pacific), buyer time zone, buyer time, and cd/book: I saved the file as amazon_detail.xlsx , quit Excel, opened Tableau 7.0, and connected to the spreadsheet (because the data set is not large, I imported all of it into Tableau, instead of “connecting live”). Tableau makes each non-numeric column a “Dimension”, and each numeric column a “Measure”.
I am curious about the geographic distribution of my sales, so I added two columns to my original spreadsheet: ZIP and state . After populating them (in Excel) and saving, I refreshed the file link in Tableau, and the two new columns were successfully brought in as new Dimensions: If you drag the ZIP dimension over onto the lower-right “Drop field here” box, the program will automatically calculate the correct latitude and longitude. The results are displayed on a map:
Hi, I’m Craig Wiles, Senior Consultant at Public Sector Consultants in Lansing, Michigan. I provide research and evaluation services for clients in health and human services, education and the environment. I am sharing a tip on how to use Tableau as part of a data exploration process with a group of stakeholders. To begin, I did the heavy statistical lifting outside of Tableau, so this would not lapse into a data-mining exercise. In this case, I worked with a state-level stakeholder group to identify data sources, research priorities, and statistically significant correlations in the data. Once we had our short list of correlated variables to explore in more detail, we convened a series of two hour, interactive data exploration sessions.