DataRemixed Tableau Pills: Measures and Dimensions | InterWorks, Inc. This is the first in a three part series related to the four types of pills in Tableau. The four pill types are discrete dimension, continuous dimension, discrete measure, and continuous measure. Grasping these concepts is important to understanding Tableau and relational databases in general. This article will specifically focus on explaining the less intuitive concepts of non-numeric measures and numeric dimensions. For a more in-depth discussion of the basic properties of dimensions and measures, see the Tableau software online help. Measures Measures are the result of a business process event. Looking at the Superstore Subset Excel data included in Tableau, we see numeric (indicated by the # icon to the left of the variable name) data in both the Dimension and Measure section of the data window. Notice that the numeric measure variables such as Order Quantity, Profit, and Unit Price are all quantities that can be measured by observation. Dimensions Non-Numeric Measures
Drawing with Numbers | Thoughts on data visualization and Tableau The Information Lab - Tableau Software UK Gold Partner Understanding Table Calcs using Index() - The Information Lab I’ve been a Tableau user for two years now. Since joining The Information Lab a few weeks ago I decided it was about time I stopped being scared of table calculations and started understanding them more. One of the biggest hurdles of table calcs is understanding just what they are doing with your data and what the difference between using a Table (across), a Pane (across) or any of the other ‘compute using’ options is. How Tableau computes table calculations When we select a table calc, Tableau first queries our data source (whether that be a database connection, extract, or spreadsheet). Okay, so now we have a brief understanding of what Tableau is doing to create a table calc, let’s go ahead and connect to Superstore Sales in Tableau Desktop and start creating some table calcs. I’ve placed Year and Month of Order Date on the columns shelf, and Sum of Sales on rows. So, pretty straight forward here. Create a new calculated field with the following: Okay, let’s mix things up a bit
Jewel Loree » Pop Viz: America’s Regional Tastes December 17, 2013 When Allrecipes reached out to Tableau to create a dashboard about Thanksgiving recipe trends, I was salivating… not just because of all the appetizing recipes but because this is some deliciously juicy data! The Allrecipes data team (shout out to my man Bob, who is awesome!) provided me with data on page views for Thanksgiving recipes broken up by state (based on IP address) and category (turkey, stuffing, pie, etc.). Here’s the viz: It was a super fun viz to make and I learned some useful techniques via my own personal Tableau master and desk neighbor Dan Hom about the new 8.1 ranking feature. The Map Obviously, the main feature of this viz is the map. Write the calculations for Rank and for hiding everything but #1. The category selector I really like using icons as buttons for filters. I grabbed the icons from a set of food icons in Smashing Magazine. The Top Recipe box There are actually three sheets going into this section of the viz and an image. The Table
Tableau Love As a “Friday afternoon fun project” I decided to tinker around a little bit with Tableau on Amazon Web Services EC2. Then bad Russell arrived in my head and kept on asking questions. A weekend later, I find that I’ve stood up and banged on about 20 distinct EC2 instance configurations. In this two-parter, I’ll let you know what I found. The Goal Understand HOW Tableau behaves on EC2. Not the Goal Create prescriptive guidance on the instance type and storage subsystem you should stand up for various sizes of Tableau Server. What I did I decided that my “base” dashboard should be an interesting one. Viz One plots the trade price of a couple hundred equities across time (quarter) and trade sizeViz Two plots the trade price for two securities across time on a daily basis On my main workstation I see the following results: Cold Load: 17 secCached Load: 15.4 sec My Mac (jealous much?.. Cold Load: 24 secCached Load 11 sec Windows Running on Mac (Parallels): Cold Load: 16.25 secCached Load: 14.55 Ready?
Fonseca Data Science | Leigh Fonseca's Explorations in Data Embedding Google News Feeds into Tableau Dashboards | Ben Sullins | Data Geek I love the Google Finance dashboards to keep tabs on my favorite stock (NYSE: DATA) and while I have certainly copied this layout for many of my dashboards I was always jelous how they were able to embed that sexy news feed to the right of the trends. For years I have pondered just how one might accomplish such a monumental task. Well, today my friends, you are in luck as I have climbed the mountain and drank from the fountain and it is sweet. Lucky for you I am here to share with you my new found knowledge. Enjoy and stay thirsty (for data) my friends! How to embed a Google News feed into your Tableau Dashboards Setup a web server somewhere. Here is a Google News Feed embedded into a Tableau WorkbookFeel free to download the workbook and checkout the dashboard actions on how exactly I did this Here’s a step-by-step video on how to add Google News to your Tableau Dashboards
I’m now using #Tableau Public to manage my blog content! | 3danim8's Blog Introduction I think that writing a useful blog shouldn’t be too hard with the technologies we have. But it is. Not that writing about interesting topics is the primary challenge, but allowing others to find and use the information that you have written about is really hard to do. Sure, there are search boxes provided on blogs that allow you to find a key term. Figure 1 – My blog from today. I have come to realize that by their very nature, blogs are just one big list of serial topics over time. I have simply gotten tired of writing HTML links and tables, seeing mis-formatted tables and incorrect color renderings on different devices, and seeing garbled pages on this blog. The solution to the problem! The solution is called Tableau. Figure 2 – The Tableau-powered dashboard showing the content of 3danim8′s blog (click to go to live dashboard!). Figure 3 – Blog post total hits and hits per day stats (click to go to live dashboard!). Like this: Like Loading...