Making Dashboards Relevant

2018-05-07T08:20:31+00:00 March 11th, 2014|Tableau, Tableau Basic|

Recently I've seen a lot of sexy dashboards created in Tableau, doing some very cool things. It got me thinking, these look great but actually they're useless, the report users would look at them once, think "wow", and then never use them again as they're not providing any useful information. If you're building reports remember [...]

Tableau Dimensions as Columns in a Table

2018-05-07T18:41:00+00:00 December 18th, 2012|Tableau, Tableau Basic|

If you have created tables in Tableau you might have noticed once you get to a six dimension columns  in the table the left hand columns begin to merge into one column. This only happens when using dimensions as column headers, not measures as when displaying multiple measures in a table this can be achieved [...]

Tableau Show or Remove ALL from Autofilter

2018-05-22T19:24:15+00:00 June 6th, 2012|Tableau, Tableau Basic|

To remove the All option from a Tableau quick filter is possible by following these simple steps: 1. Click the small down arrow in the quick filter heading 2. Scroll down to Customize 3. Uncheck where it says 'Show "All" Value' so there's no longer a tick mark against it. To show the All option [...]

Tableau Hide Values From a Quick Filter

2018-05-07T19:15:42+00:00 April 26th, 2012|Tableau, Tableau Basic|

I’ve had some questions recently about hiding Nulls in a filter in Tableau. This is quite straightforward and the same technique can be used to hide any value from a filter. NOTE – if using this technique it actually removed what you’ve hidden from the filter from the worksheet. All you need to do is [...]

Basic Maps in Tableau

2018-05-08T19:31:35+00:00 December 23rd, 2011|Tableau, Tableau Basic|

I’ve been meaning to write about the maps in Tableau for some time now as I’m really impressed with how they look, how easy they are to use and how powerful they are as a visual geographic reporting tool. If you have geographic data, preferably with a longitude and latitude, you can display mapped data [...]

Create a chart in seconds using Show Me in Tableau

2011-10-08T16:04:42+00:00 October 8th, 2011|Tableau Basic|

One of the most powerful features of Tableau to a newcomer and those who aren't sure how to display their data is the Show Me! button. Even as an experienced user I often use the Show Me in Tableau when I'm seeking inspiration as to the best ways to display the information in the dashboard. [...]

Tableau Display Measures in a Table

2018-05-07T18:42:09+00:00 September 19th, 2011|Tableau, Tableau Basic|

Displaying measures in a table in Tableau is something that should be straightforward but for some reason I always struggle with it hence I’m writing this blog post. In the Tableau screen at the bottom of the Dimensions section there’s a field called Measure Names and in the Measures section there’s a field called Measure [...]

Tableau Hide Null Values

2018-05-07T19:11:41+00:00 September 14th, 2011|Tableau, Tableau Basic|

Depending on the circumstances there are 2 general ways to hide Null values in Tableau. 1. Format the pill and hide the null values Hide Nulls in Tableau Select Hide in the Special Values section of the pane. For further explanation I have written about this previously. 2. Drag the pill into the [...]

Tableau Connecting to Data

2011-09-05T19:08:43+00:00 September 5th, 2011|Tableau, Tableau Basic|

Tableau is very flexible when it comes to connecting to data. Using the full paid for product it’s possible to connect to any data source accessible by an ODBC connection, cubes (both SSAS and Orcale Essbase), text files, spreadsheets and a number of different databases. It’s possible to connect to the live data [...]