Tableau
In our last blog post you saw how we can use the new Javascript API in Tableau Public 8.0 to play and pause a viz and automate some of the filtering. You can use the API to control any Tableau Public viz that you embed on your website, and you can use any interactive functionality you'd expect: filters, actions, mark selection, the list goes on. This lets you create seamless, integrated experiences that combine your viz with graphics, buttons and other text.
New in 8: Javascript API pt. II
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.
Self-Service BI Mapping with Layerscape
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
Deploying a WMS for use with Tableau
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.
Mapping Basics
Choropleth Maps with Tableau
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?)Polygon Files Structures - Solid Color Maps
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.
Tableau Polygons from Shapefiles
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.
Creating Polygon-Shaded Maps
Clearly and Simply: Choropleth Maps
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
Magic Quadrant for Business Intelligence Platforms
BI 101
(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”.
BI 102
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: