{"id":3397,"date":"2010-02-03T18:45:41","date_gmt":"2010-02-03T22:45:41","guid":{"rendered":"http:\/\/redmonk.com\/sogrady\/?p=3397"},"modified":"2010-02-03T18:45:41","modified_gmt":"2010-02-03T22:45:41","slug":"tableau-public","status":"publish","type":"post","link":"https:\/\/redmonk.com\/sogrady\/2010\/02\/03\/tableau-public\/","title":{"rendered":"Ubiquitous Analytics and Tableau Public"},"content":{"rendered":"<p><a href=\"http:\/\/www.flickr.com\/photos\/sog\/4328785626\/\" title=\"Tableau Public by sogrady, on Flickr\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/farm5.static.flickr.com\/4035\/4328785626_090270ab2c.jpg\" width=\"500\" height=\"295\" alt=\"Tableau Public\" \/><\/a><\/p>\n<p>Well, that didn&#8217;t take long. One of my <a href=\"http:\/\/redmonk.com\/sogrady\/2009\/11\/12\/2010-predictions\/\">2010 predictions<\/a> foretold ubiquitous analytics, and here we are not even two months in and that&#8217;s already about to happen in the form of Tableau Public. <\/p>\n<p>For those of you unfamiliar with the vendor, Tableau&#8217;s a bit of a midpoint product: more statistically and visualization oriented than Excel, more accessible in usage and cost than high end BI alternatives like Business Objects, Cognos or SAS. <\/p>\n<p>Where vendors like Data Applied, GoodData and so on are taking a SaaS approach to analytics and visualization, Tableau is primarily a rich client experience. Sadly for this Ubuntu using analyst, it&#8217;s Windows only, but apart from that I have few complaints. As you&#8217;d expect from a rich client vendor, there are the standard Desktop and Server product offerings. <\/p>\n<p>And then there&#8217;s Tableau Public. <\/p>\n<p>Still in beta, but slated for near term public availability, Tableau Public is essentially a desktop analytics experience coupled to a web back end that handles hosting of the dataset and display of the visualization. Tableau Public is a lot like their standard desktop client, except that you can handle only a hundred thousand rows of data and that you can save only &#8211; publicly &#8211; to the web. Hence the Tableau Public. <\/p>\n<p>If you&#8217;re familiar with IBM&#8217;s Many Eyes, Tableau Public is very similar except that it&#8217;s got a rich client editor and that the embeddable analytics don&#8217;t require a Java enabled browser. Which means that you can share your visualizations even with users of Chromium. <\/p>\n<p>The client you can see above. But what can Tableau Public actually do? A lot more than I can show, I&#8217;m sure, in part because I&#8217;m new to the whole visualization game, but more because I&#8217;ve only been using it for a few days. But note a few things as we run through some examples: <\/p>\n<ol>\n<li>The displays are rendered via Ajax. No Flash, no Java.<\/li>\n<li>You can view and\/or download the data visualized.<\/li>\n<li>You can interact with the data in context.<\/li>\n<\/ol>\n<p>First, a simple cross tab visualization of some Maine population data, which I obtained <a href=\"http:\/\/www.maine.gov\/cgi-bin\/data\/data_details.pl?data_id=54\">here<\/a>. <\/p>\n<p>Maine City, County, Town and State Population Census <br \/><a href=\"#\"><img decoding=\"async\" alt=\"Maine City, County, Town and State Population Census \" src=\"http:\/\/public.tableausoftware.com\/static\/images\/MaineData-MaineCityCountyTownandStatePopulationCensus_rss.png\" height=\"100%\" \/><\/a><\/p>\n<div style=\"width:504px;height:22px;padding:3px 10px 0px 0px;color:black;font:normal 8pt verdana,helvetica,arial,sans-serif\">\n<div style=\"padding-left: 388px\"><a href=\"http:\/\/www.tableausoftware.com\/public?ref=http:\/\/public.tableausoftware.com\/views\/MaineData\/MaineCityCountyTownandStatePopulationCensus\" target=\"_blank\">Powered by Tableau<\/a><\/div>\n<\/div>\n<p>Nothing fancy. Sure, it&#8217;s better than the comma separated value file served up by the State of Maine, but otherwise it just looks like a table. Which it is. But try clicking a row, then clicking the funnel icon at the bottom and selecting Keep-Only. The ability to work on data, or download it for offline manipulation, is potentially big. <\/p>\n<p>Next is one that&#8217;s hopefully slightly more interesting: a visualization of the moose related crashes from 2006-2008 (that one&#8217;s pulled from <a href=\"http:\/\/www.maine.gov\/cgi-bin\/data\/data_details.pl?data_id=4\">here<\/a>).<\/p>\n<p>Sheet 1 <br \/><a href=\"#\"><img decoding=\"async\" alt=\"Sheet 1 \" src=\"http:\/\/public.tableausoftware.com\/static\/images\/MooseCrashData-Sheet1_rss.png\" height=\"100%\" \/><\/a><\/p>\n<div style=\"width:504px;height:22px;padding:3px 10px 0px 0px;color:black;font:normal 8pt verdana,helvetica,arial,sans-serif\">\n<div style=\"padding-left: 388px\"><a href=\"http:\/\/www.tableausoftware.com\/public?ref=http:\/\/public.tableausoftware.com\/views\/MooseCrashData\/Sheet1\" target=\"_blank\">Powered by Tableau<\/a><\/div>\n<\/div>\n<p>This one&#8217;s significantly more valuable than a CSV datafile, unquestionably, because it&#8217;s been married to map data. At the suggestion of my better half, I layered in the streets and highways, so while they&#8217;re faint it&#8217;s easy to see the (expected) correlation between highway corridors and moose related accidents. You can also use the arrow in the bottom toolbar to pan and zoom, if you&#8217;re interested in a higher level of detail. <\/p>\n<p>Last we have a chart you&#8217;ve likely seen before, <a href=\"http:\/\/redmonk.com\/sogrady\/2010\/01\/15\/earthquake-data\/\">here<\/a>, which has the sad duty of depicting deaths from the most deadly earthquakes globally through 2008 (data can be found <a href=\"http:\/\/earthquake.usgs.gov\/earthquakes\/world\/world_deaths.php\">here<\/a>). <\/p>\n<p>Frequency of Deadly Earthquakes by Location <br \/><a href=\"#\"><img decoding=\"async\" alt=\"Frequency of Deadly Earthquakes by Location \" src=\"http:\/\/public.tableausoftware.com\/static\/images\/DeadlyEarthquakes-FrequencyofDeadlyEarthquakesbyLocation_rss.png\" height=\"100%\" \/><\/a><\/p>\n<div style=\"width:504px;height:22px;padding:3px 10px 0px 0px;color:black;font:normal 8pt verdana,helvetica,arial,sans-serif\">\n<div style=\"padding-left: 388px\"><a href=\"http:\/\/www.tableausoftware.com\/public?ref=http:\/\/public.tableausoftware.com\/views\/DeadlyEarthquakes\/FrequencyofDeadlyEarthquakesbyLocation\" target=\"_blank\">Powered by Tableau<\/a><\/div>\n<\/div>\n<p>The difference between the above and the images I wrote up last time is probably obvious: interactivity. A static image can only tell you so much: the embeds above will not only link you directly to the data I used, but give you the opportunity to ask questions of the visualization. How many have died in the US, for example? Malaysia? <\/p>\n<p>Clearly all of the above are but the most simplistic of visualizations; the NY Times &#8220;<a href=\"http:\/\/www.nytimes.com\/interactive\/2010\/01\/10\/nyregion\/20100110-netflix-map.html\">A Peek into NetFlix Queues<\/a>,&#8221; this is not. <\/p>\n<p>But that&#8217;s what&#8217;s excellent about public analytics: if you&#8217;re so inclined, you can pull down the datasets and better my primitive efforts. Which is how we&#8217;ll all learn. I look forward to a world where it&#8217;s as easy to share, comment on, and improve analytical visualizations as it is YouTube Video. <\/p>\n<p>And Tableau Public clearly is helping advance that cause. <\/p>\n<p>A few issues, apart from the Windows only nature: <\/p>\n<ul>\n<li>Tableau can be intimidating to new users. Templates and other &#8220;Getting Started&#8221; features would help a lot.<\/li>\n<li>Logging in and posting \/ retrieving data is a bit cumbersome, because I need to login in for each dataset I&#8217;m working off of, rather than once.<\/li>\n<li>It can be extremely picky with data, and it&#8217;s not always obvious which data&#8217;s causing the problem. It took me a couple of cycles through to learn that Tableau expects the countryname &#8220;Russian Federation&#8221; in spite of the fact that the map background says Russia.<\/li>\n<li>I haven&#8217;t seen &#8211; yet &#8211; the public back end, so it&#8217;s not clear how easy it will be to find new visualizations and collaborate with others on improvements.<\/li>\n<li>If there&#8217;s a way to annotate the visualization with notes, thoughts, original sources for the data, I haven&#8217;t found it yet.<\/ul>\n<p>But overall, it&#8217;s a very nice &#8211; and very interesting tool: one that I expect we&#8217;ll be using quite a bit of around here at RedMonk HQ. I&#8217;m heading down the R route as well, but Tableau is significantly more accessible than everyone&#8217;s favorite statistics language. <\/p>\n<p><b>Disclosure<\/b>: Tableau is not a RedMonk client, but granted me early access to the beta and a trial license for the desktop product. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Well, that didn&#8217;t take long. One of my 2010 predictions foretold ubiquitous analytics, and here we are not even two months in and that&#8217;s already about to happen in the form of Tableau Public. For those of you unfamiliar with the vendor, Tableau&#8217;s a bit of a midpoint product: more statistically and visualization oriented than<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false},"categories":[4],"tags":[],"class_list":["post-3397","post","type-post","status-publish","format-standard","hentry","category-analytics"],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/redmonk.com\/sogrady\/wp-json\/wp\/v2\/posts\/3397","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/redmonk.com\/sogrady\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/redmonk.com\/sogrady\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/redmonk.com\/sogrady\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/redmonk.com\/sogrady\/wp-json\/wp\/v2\/comments?post=3397"}],"version-history":[{"count":0,"href":"https:\/\/redmonk.com\/sogrady\/wp-json\/wp\/v2\/posts\/3397\/revisions"}],"wp:attachment":[{"href":"https:\/\/redmonk.com\/sogrady\/wp-json\/wp\/v2\/media?parent=3397"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/redmonk.com\/sogrady\/wp-json\/wp\/v2\/categories?post=3397"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/redmonk.com\/sogrady\/wp-json\/wp\/v2\/tags?post=3397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}