Subscribe to Tableau Bites

Final Tablue Bites Logo

Get this email packed with useful links for people interested in improving their Tableau knowledge and skills.

Every week, I read blogs and articles written by more than 525 Tableau experts and updates from 14,466 enthusiasts.
Sign up and I’ll send you links to the best posts (100% free).

You will receive 4 articles every week, in one newsletter, in your inbox.

Filtered for the best articles only, to save you time searching and to provide inspiration and tips and tricks on how to Tableau better and quicker.

See below for articles from previous editions.

The newsletter you’ll be waiting for.

Every week I read articles from news sites, blogs and new Tableau articles. I also look through new posts on Tableau Public, Twitter, LinkedIn, Tableau partner websites and in the Tableau Community, looking for the best and most useful pieces of content about Tableau and data visualisation practices. You’ll get the best ones, for free.

Here are some articles that have been included in recent editions of Tableau Bites:

Header Image 2

THE KEY TO DYNAMIC PARAMETERS & SOME GOOD USE CASES

With the release of Tableau 2020.1. Dynamic Parameters are now available in Tableau. Zen Master Kevin Flerlage takes you through the keys to using Dynamic Parameters and it's use cases.

Dynamic Parameters allow you to update your chosen field values from a data source when opening a workbook, as well as automatically setting a parameter to a value you have selected. The use cases Kevin demonstrates with the feature are date range and dynamically pulling different tables from a database.

buffer header

BUFFER SPATIAL CALCULATIONS

If Dynamic Parameters was not enough to whet your appetite, another new feature that has emerged in Tableau 2020.1 is the introduction of the Buffer Spatial Calculation for mapping.

Zen Master Marc Reid shows you how to use the Buffer spatial calculation by explaining the various use cases, including looking at areas a company would look at for trading opportunities. There are endless use cases for using Buffer spatial calculations in your maps in Tableau.

6f8867e2 d6a3 431b 84d3 40d9c76ac0a8

THE DASHBOARD REQUIREMENTS WORST- CASE SURVIVAL HANDBOOK

Mark Bradbourne has a dashboard requirements worst-case survival handbook to help you navigate through the challenges dashboard designers are likely to face when creating company and client dashboards.

Some of the usual challenges Mark explains are centred around exporting dashboards to Excel, using a pie chart and stop light dashboards. For Tableau analysts, they are likely to face these challenges on a regular basis so this handbook may help you get out of a stressful dashboard building process

Variance to 2017

DESELECT MARKS WITH A HIGHLIGHT ACTION

Andy Kriebel is back with another useful Tableau tip up his sleeve as he shows you how to deselect marks on a worksheet with a Highlight Action.

For this tip, Andy combines the Highlight Action with Set Actions for two use cases, focusing on deselecting the quarter selected in the quarterly sales worksheet and deselecting a part of the stacked bar chart selected for a Region. There are many use cases for using this tip in your dashboards.

3cb9f704 29bf 4583 aef2 3c6b27501582

FILTER BETWEEN BLENDED DATA SOURCES IN TABLEAU USING SET ACTIONS

Andrew Lehm from The Information Lab demonstrates how to filter between blended data sources in Tableau using Set Actions. This is a great workaround when it comes to filtering particular types of charts (i.e. Quadrant Charts) that would be filtered by a quadrant or segment within a secondary data source.

117 2

GROUPING OPTIONS IN TABLEAU

Eric Parker explains the three methods for creating group options in Tableau. The three grouping options include header grouping, visual grouping and geographic grouping.

Header grouping focuses on allowing users to combine header values, which is particularly useful with bar charts. With visual grouping, the user can select data points to a group (e.g. Quadrant charts) whereas geographic grouping (e.g. Maps) is focused on the user selecting geographic entities in a group.

unnamed

SIMPLE SYNCHRONIZED SCROLLING IN TABLEAU

The first Tableau Zen Master to feature in this edition is Steve Wexler, who shows you a different approach to the scroll bars we have come to expect in our Tableau dashboards.

Steve highlights a different approach to synchronized scrolling by creating a big ass dashboard (BAD). This means creating a dashboard so tall that you do not see individual scroll bars in the view. Instead, you have one scroll bar on the right-hand side of the dashboard instead of several scroll bars in the view.

unnamed

USE FILTER ACTION FIELDS TO UPDATE SHEET TITLES

Seffana Mohamed-Ajaz from The Information Lab explains how you can use filter actions to update sheet titles on your dashboards.

This tip is a great way of filtering the information you want to see in the dashboard while creating a dynamic title that updates itself. Seffana demonstrates the use of filter actions to update sheet titles by using the Superstore dataset.

unnamed 1

BUILD A VORONOI TREEMAP IN TABLEAU WITH TWO STEPS

Zen Master Tristan Guillevin demonstrates how you can build a Voronoi Treemap in Tableau with two simple steps. This involves generating the Voronoi data as a text file and visualising it in Tableau using the Extract Data function. I hope you can find some use cases for using a Voronoi treemap in your work?

unnamed 2

BUILDING A CUSTOM COLOUR PALETTE FOR TABLEAU

Luke Stanke from Tessellation demonstrates how you can build custom colour palettes for your real-world dashboards in Tableau.

The Zen Master highlights some tips to consider when building custom colour palettes for Tableau dashboards, including obtaining access to official brand standards documents, colour blindness and testing the colour palette with basic visualisations to make your dashboards accessible to everyone.

unnamed 3

4 TIPS FOR ORGANIZING YOUR TABLEAU WORKBOOKS

Spencer Bauke has four tips that will help make organizing your Tableau workbooks more easier for dashboard designers.

He explains that by using comments, folders, as well as annotating calculations and default formatting, it will streamline the process for dashboard designers who are creating and designing dashboards in Tableau for clients and organisations.

unnamed 4

DYNAMICALLY CONTROL FORMATTING USING MULTIPLE CALCS

Last, but not least is new Zen Master Kevin Flerlage, from the Flerlage Twins who shows you how to dynamically control the formatting of various elements in Tableau by using multiple calculations to do this.

Kevin demonstrates this through a couple of simple use cases where he uses multiple calculations to change colour within the tooltip to swapping measures with parameters. There's plenty of ways that you can use multiple calculations to dynamically control the formatting of your dashboards.

animated example 1

ANIMATIONS VS TRANSITIONS: WHAT'S THE DIFFERENCE?

One of the most talked about features in Tableau 2020.1 is the introduction of animations in Tableau, but you're wondering what's the difference between animations and transitions?

Tim Ngwena highlights the differences between animations and transitions by demonstrating the feature with a use case of the running total of profit and sales over four years. Tim argues that animations should be called "transitions" but I will leave it you to decide if you want to call it animations or transitions?

Screen Shot 2019 12 30 at 9.58.06 PM

RETHINKING SLIDER PARAMETER FORMATTING IN TABLEAU

Zen Master Luke Stanke rethinks how you should format the Parameter slider in Tableau by using a separate sheet to replicate Tableau's default Parameter slider. This is a great workaround for giving a different look and feel to the usual Parameter slider we're familiar with in our worksheets and dashboards.

Simple Upset Plot

CREATING UPSET PLOTS IN TABLEAU

Zen Master Chris Love shows you how to build UpSet Plots, which is an alternative chart type to building venn diagrams, which are difficult to build in Tableau.

UpSet Plots allows you to bring more insights into your data in a much smaller space, compared with a venn diagram. Chris uses the Week 2 dataset for Makeover Monday on approved pesticide use in four regions to build the UpSet Plot. I hope you can find a use case for using UpSet Plots in your dashboard?

The6MonthBlues11

THE 6 MONTH BLUES

Jeffrey Shaffer highlights a common issue dashboard designers in organisations face when gaining user adoption and changing culture in which Jeffrey plays "The 6 Month Blues" with one of his Makeover Monday dashboards on London Bus Safety.

Jeffrey explains that change should be introduced slowly when organisations design dashboards that they should gradually steer away from using the standard red and green colours in a dashboard, particularly for users who are colourblind.

volume dial 03

TABLEAU QT: VOLUME DIAL CHART IN TABLEAU

The Tableau Magic continues to spread from Toan Hoang as he shows you how to create a volume dial chart in Tableau. Volume dial charts are great for showing which regions have generated the most percent of sales or healthcare providers are reaching their goals over a set period of time.

Annotation 2019 08 21 163844

UNIT BAR CHARTS THAT AREN'T

Adolfo Hernandez demonstrates how to create unit bar charts that don't look like bar charts. Adolfo uses Parameters and calculations to create a unit bar chart which shows which US states are progressing in terms of hitting the $500,000 sales goal.

unnamed 1 1

HIDING SELECTION BORDERS IN TABLEAUHIDING SELECTION BORDERS IN TABLEAU

From the Zen Master Hall of Fame, Jonathan Drummey shows you how to hide Selection Borders in Tableau, using both Parameter and Highlight Actions. This tip is great for allowing the user to select the insights they want to see in the dashboard while ensuring that the selected border is hidden from the view.

unnamed 1

HOW TO: ROW AND COLUMN HIGHLIGHTER USING SET ACTIONS WITH TABLEAU

The Zen Masters keep coming in this edition of Tableau Bites as Matt Chambers demonstrates how to create a row and column highlighter using Set Actions in Tableau.

Adding a row and column highlighter to a crosstab is a great way of highlighting which regions are generating the most sales for a retailer or which hospitals are providing a good level healthcare within their respective dashboards.

unnamed 1 1 1

GROUPING DATA INTO CUSTOM TIME BINS

Advanced Tableau users! Marc Reid has you covered as he explains how you can group timed data using Custom Time Bins. Working with timed data can be challenging in Tableau but Marc's approach enables you to group timed data into custom bins by using Parameter Actions and Calculations to do this.

unnamed 2 1

COLOR ME SHOCKED: 5 SECRETS TO IMPROVE COLOR USE IN YOUR TABLEAU DASHBOARDS

It's not often we have three Zen Masters in one edition of Tableau Bites, but we do and Bridget Cogley has five secrets to share with you on improving colour usage in your Tableau dashboards.

Colour is one of the most challenging things to get right in a dashboard. Bridget explains a few things that dashboard designers should do with colouring dashboards, including using a monochrome design as well as building the dashboard before adding colour in.

unnamed 1 1

TABLEAU TIP: THE INDEX TRICK

Hanna Nykowska from The Information Lab has a Tableau tip up her sleeve in the form of the INDEX trick, which is using the INDEX() function as a filter.

This tip has some incredibly useful use cases. It includes making hidden values visible, instead of hiding them from the dashboard view while also combining the INDEX() function with other Table Calculations to get rid of repeated values in the dashboard itself.

unnamed 3 1

HOW TO LABEL BOTH ENDS OF THE % OF TOTAL BARS

Lorna Eden demonstrates how you can label both end of the % of total bars in a bar chart.

Labelling both ends of the total bars using a % of total by using a Parameter is a great way of showing which product categories in certain regions are selling well or whether employees are hitting their allotted sales targets compared with the company average.

ddfd92ef 52c9 4127 843e 4061eaafd6ce

HOW TO MAKE A SPAN CHART IN TABLEAU

Kicking off the first Tableau Bites of the new decade is Christopher Marland from The Information Lab's Data School as he demonstrates how to make a span chart in Tableau.

A span chart can be used to display data across a minimum and maximum range. Whether if it's looking at company department productivity or annual employee wages, a span chart is great for Tableau dashboard designers working in the human resources industry.

9d8a9482 8daa 4151 8c37 0cb118674773

HOW TO CREATE A SUBTITLE IN TABLEAU THAT HIGHLIGHTS WHICH FIELDS HAVE BEEN FILTERED

OneNumber's Eric Parker explains how to create a subtitle in Tableau that highlights which fields have been filtered in your dashboard.

This is useful if you have created a dashboard in Tableau that has a lot going on, which makes it difficult to find which filters are being used. Eric's approach by creating a subtitle below the main title makes it clear what filters are being used in the dashboard itself.

a7ed184f 90c5 4ec6 ae8f 8d10448a0ad1

CUSTOM DROPDOWN WITH PARAMETER ACTIONS & SHOW/HIDE CONTAINER

For the advanced Tableau user, 2019 IronViz runner-up participant Lindsey Poulter focuses on how you can create a custom dropdown in Tableau that uses both Parameter Actions and Show/Hide Container. This is great for looking at how various product departments are performing over the year.

eabc6e5a 82cf 445e b370 58a72783dfc2

TEXT ALIGNMENT ON DASHBOARDS

Zen Master Jeffrey Shaffer highlights some best practices for text alignment on your Tableau dashboards. Jeffrey explains how text alignment in Tableau can be used appropriately while identifying different scenarios of using left-aligning, centre-aligning and right-aligning text in a dashboard.

I hope you can find a use case for this in your real-world dashboard?

3369d88b 9220 40dd acf9 f9f68923b1fc

USING DISTRIBUTION LINES TO PROVIDE SPACE FOR LABELS

The second of two Zen Masters to feature in the first Tableau Bites of 2020 is Andy Kriebel, who has another Tableau Tip up his sleeve with using distribution lines to create space for labels in a dashboard.

Andy shows you how you can use distribution lines to provide space for labels in your dashboard. If you have a sales dashboard that already has a filter for your audience to use, using distribution lines is a great way of creating space for labels in the dashboard while reducing the visual clutter in your dashboard.

4f640a94 f765 498a 8e51 740d60d02dc9

AN INTRO TO BASIC STRING CALCULATIONS: LEFT, MID AND RIGHT FUNCTIONS

Ross Easton from The Information Lab's Data School gives you a basic introduction into string calculations in Tableau. Ross focuses on the left, mid and right functions of string calculations, which allows you to separate merged bits of information in your dataset into separate columns.

This is useful if you have data that has been merged together in certain cells and you need to separate the information into individual columns.

09b40ecf 5597 4f32 b4cc 9c58664963c7

HOW TO BUILD A CANDLESTICK CHART IN TABLEAU

Starting off the final Tableau Bites of 2019 is Anna Prosvetova from The Information Lab's Data School, who shows you how to build a candlestick chart in Tableau.

A candlestick chart is great for showing the fluctuating price changes in stocks and currency data, showing which days or months have shown a rise or decrease in prices. This is particularly useful for Tableau dashboard designers who work in the banking and stock market industries.

488de2aa 71c9 446c b531 af463d995629

DEALING WITH COMMON SCATTER PLOT ISSUES IN TABLEAU

Dorian Banutoiu from Canonicalized highlights the most common issues that you are likely to deal with when using a scatter plot in Tableau. A scatter plot is great for showing which employees are generating the most sales within their department or how many customers are visiting your store.

It is worth taking into consideration when using this chart type in Tableau that you are going to deal with common issues, which includes dealing with NULL values or synchronised axes. Dorian explains some approaches to dealing with these common scatter plot issues in Tableau.

3715c8ee 09a0 4c3b 9973 ad733ecfdf84

USING PARAMETER ACTIONS TO COMPARE TIME PERIODS

If you are an advanced Tableau user, Tessellation's Spencer Bauke shows you how to use Parameter Actions to compare time periods. This is a very useful tip to use if you are working with data relating to time periods and need to select which time period on your dashboard to look at, whether that's product sales or employee retention.

79d59f40 d394 4987 a570 8c3d89451929

HOW TO TRACK THE USAGE OF TABLEAU DASHBOARDS VIA URL ACTIONS

Rodrigo Calloni explains how you can track the usage of dashboards created in Tableau through URL actions. This simple tip could be useful for dashboard creators and designers who want to track the user behaviour of interacting and engaging with the dashboard they have created in Tableau.

ceee5b02 5b46 4579 9781 f4e1c7ab4075

HOW TO CREATE A PRINTABLE TABLE WITH MULTIPLE PAGES

Gwilym Lockwood from The Information Lab has a tip up his sleeve for creating a printable table with multiple pages in Tableau. Gwilym uses a Parameter and running total calculation to create a table that can be printed across multiple pages.

bf3ae130 4cec 4d17 9488 988bb66b707e

ZOOMABLE CHARTS IN TABLEAU

We've saved the best for last as Zen Master Ken Flerlage shows you how to use Zoomable Charts in Tableau. This sort of chart is useful for zooming into a particular area within the chart you want to look at whether if it's the increase or decrease in medical sales or product sales over a certain time period.

a913859f 66e7 4dd9 a2f4 37037b31c6f1.gif

HOW TO: SHEET SELECTOR USING SET ACTIONS IN TABLEAU

Zen Master Matt Chambers shows you how to utilise the power of Set Actions to create a sheet selector in Tableau.

Matt walks you through step-by-step on creating the sheet selector using Set Actions, which is designed to create user interactions that can change the visualisations shown on a dashboard.

68c87cc7 b11a 4cd9 84d3 d85e1dd96363

5 CATEGORIES OF TABLEAU DELIVERABLES

Toan Hoang spreads his Tableau Magic once more, highlighting the flexibility and output the tool can bring to analytics and business intelligence professionals using Tableau in five categories.

The five categories Toan highlights are centred around presentation and print, interactive dashboards, infographics, data extracts and embedded analytics. Depending on how you use Tableau, it's important to know how you can use the platform to it's full potential to benefit your analytics department or consultancy.

95e0855b 54a2 49a8 95b2 052cb78df25e

USING LODS TO COMPARE MAX/MIN YEAR VALUES

For the more advanced Tableau user, Lindsay Betzendahl has a tip up her sleeve using level of detail (LOD) expressions to compare max/min year values. The LOD expression for max/min year values is great if there are missing values in the dataset that affect the quality of the dashboard or visualisation and need to be filled in.

0109f08b 4a9b 42fd b8dc b7b108e4fe2f

VISUALIZING P&L STATEMENTS

Klaus Schulte explains how you can visualise one of the most important documents for an accountant, a profit and loss statement. The Zen Master mentions using the scorecard approach to creating a P&L statement in Tableau while using different approaches to bring context for your statements.

3b514f75 ff0a 41d9 ba52 dd869205971d

PARAMETER ACTIONS

Expedia's David Pires provides six different user cases for using Parameter Actions in Tableau, which was released in Tableau 2019.2 earlier on in 2019. It includes using Parameter Actions for running total start date, sort it with 1 click, combined scroll, drill-down, sync references and before and after.

Maybe you can find one that is useful for your product sales or employee engagement dashboard? There are many different use cases...

6ae55364 e6dd 46ee 8cb5 918bf3b9e16b 1

HOW TO DYNAMICALLY COLOUR TOOLTIP TEXT IN TABLEAU

Slalom's Sarah Bartlett shows you how to dynamically colour your tooltip text in Tableau. This is a great way of turning an ordinary-looking tooltip into something that enhances and improves the user experience for users and managers who are interacting with the visualisation or dashboard.

2dea9761 ccb1 44df ae46 40fa70d550b9.gif

CASES FOR COLLAPSIBLE CONTAINERS

Kevin Flerlage highlights one of the less-promoted features when Tableau 2019.2 was released in May 2019, collapsible containers.

Collapsible containers can be utilised in several ways on a dashboard. Whether if it's to show and hide filters or parameters, sheet swapping, creating stackable charts or modifying the background colour of a visualisation, you'll find a way of applying a collapsible container in your own work! Kevin walks you through step-by-step on 12 different use cases.

5c5c4bf4 4591 4fcf bdd0 6047410019c0

REMOVING VALUES FROM QUICK FILTERS USING TABLEAU’S ORDER OF OPERATIONS

Nick Jastrzebski from The Information Lab shows you how to level up your dashboards with an overview of removing values from quick filters by using Tableau's Order of Operations.

There are three ways of doing this through the Order of Operations. The first approach includes duplicating a field that you are using and then excluding it. The second approach uses a set filter to filter out unwanted values and the last approach combines both approaches to remove values from quick filters.

c7e7f2ed a19e 4fde aae6 c725799a9f71

HOW TO MAKE RANGED DOT PLOTS IN TABLEAU

The Principal of Playfair Data is back with another excellent how to article. Ryan Sleeper guides you through how to make ranged dot plots in Tableau. A ranged dot plot is great for identifying which regions have generated more sales within your business over a 12-month window.

a94bf417 bc31 42a6 b008 13f164931cab

STYLE YOUR KPIS – DISPLAYING POSITIVE OR NEGATIVE CHANGE

Want to make your KPIs stand out? The Data School's Joe Stokes demonstrates how to style your KPIs in Tableau to display positive or negative change. This can be incredibly useful for businesses who want to look at if the number of sales or orders has increased or decreased year-on-year.

9d9bc81d 6933 414b ab8a 6c384669db0c

DESIGNING TABLEAU DASHBOARDS IN THE AGE OF DIGITAL DISTRACTION

In this age of digital distraction, designing accessible dashboards in Tableau that does its job for your department manager or business is essential. Bridget Cogley mentions why its important to create calm spaces for users to engage in your company sales or healthcare dashboard.

1fee5018 05d5 4d91 8ef2 ffe085d0c46a

DIFFERENCE FROM AVERAGE SET ACTION

If one Data School post was not enough, let's make it two! Georgie Grgec explains how to use a Set Action to show the difference from the average by using a difference in average chart to show which states are performing above the average state in the Sample Superstore dataset.

633c50a5 2205 4c9e ad8f 7f8c95ce9fb4

TABLEAU QT: THERMOMETER CHART

Toan Hoang is back with another of his Tableau Quick Tips as he shows you how to build a thermometer chart in Tableau in five minutes or less. A thermometer chart is great for showing the progress of where certain markets have performed better than others or different department performances within a company.

3fc20595 637d 49b4 8654 ceb909285ac8

HOW TO COLOUR SCALE A MAP USING SET ACTIONS!

Figuring out where to start with Set Actions in Tableau? Viz Queen Louise Le from The Information Lab has a lovely little tip on changing the selection that impacts the colour scaling on a map using Set Actions.

The tip can be used if you're looking into what regions are providing the highest number of product sales within a company to identify which products are popular within a certain region.

c5457446 bbef 487e 841b 829c72a42a64

HOW TO MAKE HUB AND SPOKE MAPS IN TABLEAU

Ryan Sleeper shows you how to make hub and spoke maps in Tableau by using the MakePoint and MakeLine functions to show the location path between Ryan's 10 favourite barbecue restaurants and the Playfair Data offices in Kansas City, Missouri! I am sure you can come up with some more useful use cases?

585ff043 1bf2 42f8 badc 0dfa1cff09b9

ADVANCE WITH ASSIST: NESTED IF CALCULATIONS IN TABLEAU

Interworks' Dustin Wyers shows you how to use nested IF calculations in Tableau. Dustin uses this approach by using a nested IF calculation to identify which Segments and Ship Modes have been flagged or not flagged in the Sample Superstore dataset.

26d3bcef a5dd 4b8b 9802 907c3e7217b7

USING MEASURE NAMES TO UPDATE A PARAMETER

Andy Kriebel has another Tableau Tip up his sleeve as he delves into his handy tips and tricks toolbox to show you how to create a dynamic scatterplot and dynamic line chart which uses Parameter Actions to pass the Measure Names field to a parameter, and a calculation to achieve the result. This approach overcomes the fact that you cannot refer to "Measure Names" in a calculated field.

b79b0cda c453 4f40 b939 f0d28280b4cb

TABBED NAVIGATION WITH PARAMETER ACTIONS

Trying to create a dashboard that looks like a webpage for a client? Rodrigo Calloni replicates this approach by using Parameter Actions to create a tabbed navigation-style menu in Tableau.

This approach can be useful if you're looking to create a dashboard that looks and feels like a webpage in terms of identifying certain performance fields (i.e. healthcare and sales targets).

71510799 19f0 4e63 b6a3 b1bcec37f3b7

TABLEAU QT: CALENDAR TABLE

Toan Hoang has spread some of his Tableau Magic again as he shows you how to build a Calendar Table in Tableau that will take as much time as making a cup of tea or coffee.

This is great for showing what months and days have performed well for product sales or department performance and displaying it in a Calendar Table.

33292f0f 38fd 412a 8895 8d18ce6640c1

TABLEAU 2019.3: EXPLAIN DATA, TABLEAU CATALOG AND TABLEAU SERVER MANAGEMENT ADD-ON

Tableau has brought out Tableau 2019.3, releasing a raft of new features to data professionals. Ryan McShane, Senior Manager, Product Marketing highlights the three main features in the update, including the AI-powered Explain Data, Tableau Catalog and the Tableau Server Management add-on.

12a80544 4116 4f7e b0b6 f15c708f9db1

TABLEAU TIP: HOW TO DO BETTER SHEET SWAPPING

Ryan Sleeper has yet another how-to as he shows you how to make Sheet Swapping better in Tableau by using layout containers. The Principal of Playfair Data demonstrates this approach to sheet swapping by giving the user a chance to go back and forth between the scatter plot and bar chart.

a082da86 7310 4a28 9a9b 7726653cb2b9

ENCODING CHANGE IN TABLEAU LINE CHARTS

Zen Master Klaus Schulte highlights two ways of encoding change in Tableau-created line charts.

Klaus uses the Step Line Type approach where he builds his line chart manually in Tableau and creates a dual axis to encode change in the chart. He also mentions that you can use this approach with a Regular Line Type by using Parameters to achieve this result.

844d5021 68f5 45cf ac74 1f53a6376cbe

MAP MARKER CLUSTERING USING PARAMETER ACTIONS

Figuring out how to make your maps look more clearer to read? Jeffrey Shaffer has a way of doing this clustering the marks together in your map by using Parameter Actions.

It's useful if you're working with incident data to find out which areas in a region or city have the most incidents within a specific geographic area.

d958de6f b559 47bc 9114 4e8993352499

DONUT CHARTS AND DYNAMIC REFERENCE BANDING

Donuts! Gwilym Lockwood shows you how to create dynamic reference banding in your donut charts in Tableau.

These donut charts could show the percentage of support tickets being answered by your team or whether your analytics department has under or over performed for monthly sales or healthcare performance.

3f1700fb 6a91 4dc9 be5c 16cd0131b78d

DYNAMIC NUMBER FORMATTING

Zen Master Rody Zakovich starts off the 20th edition of Tableau Bites with a simple, but effective tip using basic maths to do dynamic number formatting in Tableau.

This is useful for labels and tooltips when using a parameter to select from a list of measures with different magnitudes, for example.

a58a855d fd37 4ea0 9006 6761d83aae94

DESIGNING A GREAT DASHBOARD EXTENSION

Want to build and design a dashboard extension in Tableau? Tableau's User Experience Designer Jen Wong explains why its important to not only create a dashboard extension that works, but offers the user a great experience with the extension on offer.

bba9272a 8db7 49de 8b4d 255a8006b6e1

INTRODUCING LEAPFROG CHARTS

Tableau Bites would not be the newsletter it is without having one of Ryan Sleeper's excellent how-to articles. Ryan introduces a new chart in Tableau, the leapfrog chart, which are a variation of a minimalist dot plot that allows the user to focus on the performance of one element in a dimension against the others and the overall average.

5debc142 ff15 4ddf a923 19ce00f0fdf7

5 QUESTIONS TO ASK WHEN DESIGNING A MOBILE DASHBOARD

Tableau's Technical Evangelist Andy Cotgreave highlights the five questions that you should be asking as an analyst when designing a mobile dashboard. Andy explains that you should be building your dashboard for mobile in the same way that you would build it for desktop.

ba664be6 f151 42b4 a719 0a575c3bf35b

DRILL DOWN OF DATE WITH PARAMETER ACTIONS

The third and final Zen Master to be included in the 20th edition is Rosario Gauna as she shows you how to drill down of a date while utilising Tableau's recent new feature, Parameter Actions.

This technique allows you to drill into a single member in any chart or table - which has been a much-missed feature in Tableau.

64b45144 3097 44e5 8fbe 7bc4dcad9459

HOW TO MAKE CONNECTED SCATTER PLOTS IN TABLEAU

While one article was not enough, we have a second how-to from Playfair Data's Ryan Sleeper. Ryan shows you how to make the connected scatter plot by connecting the marks by year to the dots in Tableau.

523b19e2 c47d 4d4b a637 116e8220b4fe

MAP ZOOM WITH RADIAL DISTANCE AND INCREASING MARK SIZE IN TABLEAU

Zen Master Jeffrey Shaffer demonstrates how to create a map that can zoom in, filter, control, show and increase the radial distance, as well as increasing the mark size of the map as it zooms in utilising a mixture of Set, Worksheet and Dashboard Actions.

d3821f2d 050d 481c 87af a6068f1052ea

HOW TO SWITCH METRICS (OR DIMENSIONS) USING SET ACTIONS

Tableau's Queen of Set Actions, Lindsey Poulter shows you how to use Set Actions to switch either metrics or dimensions in your dashboard using the tried and trusted Superstore dataset.

c7ab8867 56bc 4d09 af3b aa3e55e023bb

HOW TO MAKE BETTER RELATIVE DATE FILTERS

The Zen Masters keep coming as Ryan Sleeper has yet another clever tip up his sleeve towards creating better relative date filters over 7, 30 and 90 days in Tableau. This tip can be used in all sorts of ways for the user to select the relative date range they want from the data.

5099abaa a654 45c3 a3ba 346d624adc5d

TIDYING UP TABLEAU CHART LABELS WITH SECRET REFERENCE LINES

Points of Viz' Mark Edwards shows you how to tidy up your Tableau chart labels with secret reference lines. Mark demonstrates how to create space for your labels in your visualisation without having to fix an axis, giving your labels inside your viz the space they need to be readable to your users.

54766cf3 d68a 407e b70b e50c529f4e35

ACCELERATING UNDERSTANDING WITH THE EXECUTIVE KPI DASHBOARD STARTER KIT

Tableau has released an Executive KPI Dashboard Starter Kit for healthcare professionals. Derek Cyr explains how the starter kit can help hospitals deploy a solution to see and understand the hospital's most critical performance indicators.

3602be16 f2a4 4255 83ea 100b4c0c125c

TABLEAU TIP: HIGHLIGHT TABLE WITH INFO ICONS

Hanna Nyskowska from The Information Lab has a way to give your tables some added colour by demonstrating how to do this in Tableau, as well as adding information icons to highlight the section you want to hover over on the table.

7ce61fe5 f058 4b2e 9c7f 3cbabc522c78

VISUALLY ANALYSING THE ANSWERS TO WHY?

Colin Wojtowycz visually analyses the questions to 'why', by using Tableau's new dedicated dashboard buttons. Colin explains how having different views enables the audience to see different insights from the same data, which enables them to be able to ask and answer business questions quickly.

93c2af4f 9778 4f3d acc0 c0b73289e2ae

TABLEAU QT: CONNECTED BAR CHARTS

Tableau Magic's Toan Hoang has a quick tip that will show you how to build a connected bar chart in Tableau in five minutes or less. He uses the Orders section of the Superstore dataset to create a quick and easy connected bar chart.

0cff4ffe e75c 40d1 9b0a b9ac5f954d9b

HOW TO DRILL INTO A SINGLE ROW OF A TEXT TABLE IN TABLEAU

Playfair Data's Ryan Sleeper explains how to drill into a single row of a text table in Tableau, utilising the trusty Superstore dataset. The trick to click into a single row to expand and find more detail can be done through Set Actions or Parameter Actions.

90a2026d 0abc 4fde 9d1e a7d259c0a098

HOW TO MAKE YOUR POPULATION PYRAMIDS POP! IN TABLEAU

Cerner's Sean Miller goes through the process of how to make your population pyramids POP! in Tableau by creating a chart using diverging bar charts to look at the population distribution for a client's high cost members.

4d9e223a c84b 48db 9435 8e72468b3fbe

THE LOGIC OF DASHBOARDS: DESIGNING FOR THE WHOLE PICTURE

Zen Master Bridget Cogley highlights how we should be designing dashboards for the whole picture. By working together through the charts that make up the dashboard, Bridget emphasises that it helps to think beyond the chart and encourage interaction for the user whether if it's focused on sales, profit or HR efforts.

e239f716 b016 4643 9121 d1c4e98bd8c8

WHEN CAN A LINE BE A BAR?

Webranz's Alex Waleczek questions the use of line charts and bar charts by looking at which chart you should use across different issues such as the usage of ink, the number of categories being used and the importance of NULL values as this depends on the question you are trying to answer in the chart.

7f9fc203 246a 4bec 81b1 c5f6496da4d0

HOW TO LABEL THE LONGEST OF A DUAL AXIS BAR CHART?

The Information Lab's Tom Pilgrem uses a bar-in-bar chart to demonstrate how to label the longest of a dual-axis bar chart by using some calculations to make your bar-in-bar charts more easier to read.

42ae4f78 ee19 4139 b645 65056f4da4c7

FEEDING THE SCREEN-TIME BEAST WITH SHIFTING MOBILE METRICS

DataBlick's Anya A'Hearn explains how Tableau users could modify their desktop dashboards to become more mobile-friendly, as well as highlighting how it could make the traditional KPI dashboard more modern.

afcfd3cc a8b0 4c4a afe6 1bf785c8875e

FILLING IN NULL RECORDS WITHOUT FILTERING

Interworks' Dustin Wyers explains how in Tableau you can fill in null records without needing to use a filter by applying a table calculation to show or hide the data you want your team to see.

a386b9eb 320b 4ced 8c0b 2a0a259a8757

3 CREATIVE WAYS TO USE TABLEAU PARAMETER ACTIONS

Zen Master Ryan Sleeper identifies three creative ways to use Tableau's parameter actions. Ryan explains how to use Tableau's parameter dashboard actions, using parameter actions to highlight selections within a visualisation and to change date parts with a click of a button.

78283d32 08e3 447b a5f1 ec072db9cc78

8 ALTERNATIVES TO DEFAULT TABLEAU LEGENDS

Tableau Zen Master Ken Flerlage highlights eight alternatives to the regular default Tableau legend. The post includes how to integrate the legend into text, custom images, putting the legend into a tooltip and so much more to make your visualisations clearer for the user.

6f8e6c58 c913 4c81 a788 54526c6563ad

TABLEAU 2019.3 BETA NOW AVAILABLE

Tableau's 2019.3 beta is now available for Tableau users. In the 2019.3 beta, there are three new features to try out, which includes the AI-powered Explain Data, Tableau Catalog and Project McKinley as Ryan McShane explains about the new features in the 2019.3 beta.

There are enhancements in the beta, including embedding in Ask Data, connecting to/join published data sources in Prep Builder and enhanced security.

2d870816 e562 4c4c 90ad 81c85af50b0e

MAKING GEOSPATIAL ANALYSIS EASY WITH TWO NEW SPATIAL FUNCTIONS; MAKEPOINT AND MAKELINE

Tableau's Lead Product Manager for Maps and Spatial Analysis, Kent Marten looks at the two new spatial functions that make analysing location data easier and help elevate your maps to the next level with MakePoint and MakeLine.

79fce52e d1ed 430f 8a50 d412aa7f9b83

CREATING, NOT DESIGNING: THE FOUR GOALS OF EVERY INFORMATION EXPERIENCE

Tableau Zen Masters Mike Cisneros and Lilach Manheim argue as data analysts and visualisers that we should not be designing, but creating visualisations. They mention the four goals that are essential of every information experience by using the delta design philosophy on Tableau's main blog.

2f1109d5 56a7 478b b9e1 49ce0349bba3

OVERCOMING THE VECTOR MAP LEARNING CURVE

Kevin Flerlage showcases one of the newest features from the release of Tableau Desktop 2019.2, vector tile mapping. We all love a good map right? Kevin overcomes the vector map learning curve to create some engaging map-related vizzes, using this new feature from the previous beta.

ecefe463 cef4 49a7 8678 298dc937698d

3 WAYS TO MAKE SPLENDID SLOPE GRAPHS IN TABLEAU

Tableau Zen Master Ryan Sleeper outlines three different ways of making your slope graphs splendid. It includes making the graphs dynamic-based on a date range filter, adding a slope graph toggle and adding vertical lines to connect slope graphs.

a5e0d2fd 316c 45c9 89f7 229602938f7d

USING SET ACTIONS TO SHOW/HIDE DISTRIBUTION

Jisc's Lorna Eden shows us a Set Actions tip that takes you through how to use set actions to show and hide distribution of your underlying data.

2bfe49ff c883 40ff 8422 0cdf527feaa9

HOW TO BUILD AN OVERLAPPING BAR CHART IN TABLEAU

Four Tableau Zen Masters in one newsletter? The fourth Zen Master to be featured is Unifund's Jeffrey Shaffer who has written an excellent post on how to build overlapping bar charts in Tableau, which builds on his most recent visualisation "Bar Hopping: Theme and Variations on a Bar Chart".

This was a very kind response to a question I raised to Jeffrey on a LinkedIn thread helping use Tableau to be IBCS compliant.

1ffe1e77 9937 4c80 87d0 c4bf00b3405e

PIMPING YOUR TABLEAU CONTROL CHARTS

If you already know about creating a control chart, then Promatix's Chris Dickinson has a blog post that will pimp your control charts in Tableau, taking these charts to the next level by giving a level of control to the user.

0b5d4197 cfeb 48aa a6b5 402aac953453

TABLEAU 2019.2 RELEASED

Tableau 2019.2 was released very recently. This article will allow you to explore the extensive new features including parameter actions, vector maps, show/hide dashboard containers, customisable reference line tooltips and much more...

ae24b117 4c23 48bb bf51 0467a26c622c

HOW VISUAL ANALYTICS HELPS AUDIT AND RISK PROFESSIONALS SHORTEN TIME TO INSIGHT

Joe Oringel, the Managing Director of Visual Risk IQ elaborates on how they have helped finance and internal audit professionals utilise Tableau effectively in this recent article.

3fd2ae29 3a5b 482b 9054 8fd289318e01

TIPS FOR CREATING MOBILE DASHBOARDS WITH NEW AUTOMATIC LAYOUTS FOR TABLEAU

Recently, Tableau introduced a faster way to mobilize your dashboards to users on their phone with the automatic mobile layouts feature. Bridget Winds Cogley talks through how to make the most of this brilliant new capability.

10288e26 ec3e 4726 9448 9c48c003419c

QUICK TABLEAU TIP – HOW DO YOU ADD ‘+/-‘ OR ‘▲/▼’ TO LABELS?

Sara Hamdoun from the Data School, shows us this simple yet neat tip for indicating whether a number is positive or negative. In this example, she uses the Sample – EU Superstore data set to analyse the total number of sales sold in each segment during each quarter.

ffe46864 22de 46d3 9284 499e7bc29bec

HOW TO SETUP A BASIC DRILL DOWN WITH SET ACTIONS

Andy Kriebel, from The Information Lab, shows us a handy tip to take you through how to set up basic drill down view using the new set actions feature in this video.

3f6f3ed9 7768 4f4a be91 01cb4dd3d2bd

SHOWING NOW VERSUS THEN? CONSIDER A COMET CHART

This 'How to' from Steve Wexler (co-author of The Big Book of Dashboards), explores how a measure for one period can be compared with a previous period - a common requirement - using a comet chart - is that a thing?

86bdad72 83a7 4266 91f7 45622decb996

HOW TO MAKE UNIT HISTOGRAMS / WILKINSON DOT PLOTS IN TABLEAU

Tableau Zen Master, Ryan Sleeper, explains how Unit histograms, or Wilkinson dot plots, show distributions of individual data points instead of bucketing them into bins like traditional histograms.

b4d62f58 12c4 4d59 bca2 cbe7620c4311

NOW IN BETA: VECTOR MAPS, PARAMETER ACTIONS AND NEW ASK DATA FUNCTIONALITY

The newest version of Tableau (2019.2) beta was released in March. They’re revving up the way you interact and tell stories with your data. Emily Chengives a quick overview of the highlights:​

a1fe3263 bbe7 4b41 9f00 4bfe60fca950

CREATING A DATE SCAFFOLD IN TABLEAU

Tableau Zen Master, Ken Flerlage, spends a lot of time answering questions on the Tableau Community Forum and one common problem he sees is missing dates. For instance, you may want your visualization to always show all twelve months of the year, regardless of whether or not there is data for all twelve months. Quite often, the solution to these problems is to use a date scaffold. So, in this blog, he shows you how to create and use a date scaffold in Tableau.

226ef53c 2a49 4c3d ab7e e069a2473140

HOW TO AUTOMATICALLY CHANGE DATE GRANULARITY BASED ON DAYS IN RANGE

Zen Master, Ryan Sleeper, shows how to automatically change the date granularity to the most appropriate date part based on the number of days in a selected date range. This post shows how to change the date part of a line graph from day, to week, to month, based on if there are 30 or fewer, 90 or fewer, or more than 90 days on the view, respectively

ffd6ed73 8d5d 4c44 9106 c7b909e5c02e

CREATING A SELECTION PANEL WITH SET ACTIONS

datavis.blog looks at the relatively new feature of Set Actions. MakeoverMonday recently ran an article on “Ranking the States by Fiscal Condition” They created a bump chart showing the total net assets per person for each state based on each state’s population. The curvy bump chart was created using Kevin Flerlage’s excellent Excel template.

This post will focus on the selection panel to the left of the bump chart that allows you to select a state (or states) and have that state highlighted in the bump chart, which was created with a couple of formulas and a set action.

be47ad93 5770 43e3 a00a cde2c1e3a742

3 WAYS TO MAKE MAGNIFICENT MAPS IN TABLEAU

Maps are one of the most effective chart types in Tableau and are also among the easiest chart types to create.

Ryan Sleeper's post uses a map of his top 10 favourite barbecue restaurants to share three ways to take your Tableau maps to the next level. Tips include a formatting trick, instructions for how to unlock additional map styles, and how to create a dual-axis map using a combination of generated and custom coordinates.

6e362696 d57d 4c77 a9ab b69fefd5db6b

IT’S OKAY TO BREAK THE RULES, SOMETIMES

Ken Flerlage's blog on medium.com gives us an insight into a Zen Master who doesn't always believe in sticking to a set of rules when it comes to data visualisation.

He explains 'In high school, I learned the rules for writing essays. Having mastered them, I realised that they were not so much rules as guideposts. Knowing this, he began to explore and experiment with the boundaries and gained a better understanding of when it was okay to wander outside of them'.

781b941a c92c 4639 93ef 33bf3e7a05ce

TABLEAU ASSISTANT DIRECTORY

Rebecca Roland has made a directory of free websites and tools you can use to enhance your work. Some require a sign up so do have your email and PW at the ready. You’ll find a variety of icons, images, text, shapes and colours! What more could you possibly need?

3bc82d3d 07a0 4522 8449 7678adde6077 1

3 MORE WAYS TO OVERCOME THE EXCEL BARRIER TO TABLEAU ADOPTION

Tableau Zen Master, Ryan Sleeper, talks us through how moving business users from a spreadsheet mentality to data visualisation is just as relevant as its always been.

843cf0df 23c5 4116 b764 0377f79ba767

8 ANALYTIC CONCEPTS TO EXPRESS WITH TABLEAU SET ACTIONS

Released in Tableau 2018.3, the set actions feature extends the interactivity in Tableau, allowing for deeper, more diverse comparisons through user selections and opportunities to see your data in a new light.

Now you can provide richer analysis, more flexible exploration, and simpler user experiences for your stakeholders. Bethany Lyons, Product Manager at Tableau writes an excellent introduction on how to bring powerful new comparisons to viz audiences with set actions.

abb2ebe5 fd7d 4e5c 9478 dce6d8427b25

LEARN MORE ABOUT TABLEAU PREP CONDUCTOR, A NEW ADD-ON FOR 2019.1

Organisations are seeking to become more data-driven, providing more people with access to wider sets of data so they can create better insights, quicker., It’s more important than ever that everyone is working with the right data.

Thats the philosophy behind Tableau Prep Conductor being released as part of their 2019.1 data management add-on.

6ec28fa4 2140 42ef 863d 65981716ec43

TABLEAU TIPS: HOW TO CONVERT A REFERENCE LINE INTO A LEVEL OF DETAIL EXPRESSION

This 'how to' video by Andy Kriebel builds upon a previous tip: How to Convert a Reference Line into a Table Calculation. In this tip, instead of using table calcs, it will show you how to convert a reference line into a LOD.

626e99d8 53d2 458d 8ec4 aaeda277e8d5

HOW TO SHOW CURRENT AND PRIOR PERIOD DATES ON THE SAME AXIS IN TABLEAU

Ryan Sleepers posts are always great, and in this edition of Tableau Bites he gets 2 slots!

Dates can be tricky to work with in Tableau. This one explains how to compare the performance of a selected date range to the performance of the date range immediately preceding it. For example, if you choose this week as the current date range, you want to see this week’s data in addition to last week’s data so you can do an easy period-over-period analysis.

7a8c2af2 4e8a 4bdf abfa 474f2c2e6035

CUSTOM TABLEAU SERVER ADMIN VIEWS

Tableau server guru, Jonothan MacDonald, explains how to build a custom view of tableau server admin.

You can customise the Tableau Server admin views for monitoring usage and data server statistics. For this, you need access to the underlying Postgres database that contains a lot of useful information about the Tableau server usage.

262d808a fdbb 4cb3 b6e8 5f688c121da0

TABLEAU 2019.1 RELEASED - SEE WHATS NEW...

Explore the newest features in Tableau 2019.1 including Ask Data, Prep Conductor and more

7b1aff8f 31e0 42a0 b255 595a322a0633

EVERYDAYDASHBOARDS.COM

This site is all about sharing real life dashboards. Dashboards made by real Tableau users. The purpose isn’t to show off clever charts, or amazingly designed infographics from fun personal projects. Instead they want to share what Tableau users are creating for work, with real dashboards for real users.

0e89f14a 7eb7 4b7b af10 591ae5bcdaf1

WHY DO YOU VISUALIZE DATA? WAYS TO DISCUSS WITH STAKEHOLDERS.

Ryan Sleeper talks about his favourite question to ask when presenting on Tableau and data visualisation: Why do you visualise data? He then gives insight into discussing data visualisation with Stakeholders.

6ec28fa4 2140 42ef 863d 65981716ec43 1

WANT TO SEE WHO IS USING YOUR VIZ?

Lorena Merary Vazquez shows several methods on Tableau Server to see who is looking at dashboards and published data sources. She also introduces us to an open library of custom Tableau Server dashboards, kindly hosted by Mark Jackson.

cd93c41f af24 4980 93db 3f513e36aa46

HOW TO MAKE A PARETO CHART

Ellen Blackburn talks us through her preferred method of creating a Pareto Chart. The Pareto principle (or the 80/20 rule) dictates that 80% of the effects come from 20% of the cause.

261ae227 c0ce 4c03 8d48 d48e937a3cca

QUICK TIP – HOW TO CREATE EXTRA SPACE BETWEEN YOUR BARS

Nils Macher addresses the question: Have you ever had the issue that you want to create extra space between bars which belong to a different category? It is really difficult to see which bars belong to which region. The last row for each segment is really close to the first row of the following segment.

74dfa195 ba21 4c75 8f82 f2bf183c2db2

QUICK TIP -THE ONE-CLICK TRICK TO CREATING HEADERS FOR SINGLE-MEASURE TABLES

This is a guest post by Tableau Zen Master Jonathan Drummey on the Tableau blog. This post first appeared on Jonathan's blog, Drawing with Numbers. Here’s the problem: In a single-measure table, I want the name of the measure column as a header.

4cef93c0 2fa5 48a1 b8c1 c0834bdf0ea7

WANT TO SEE WHO IS USING YOUR VIZ?

Chris Dickson has written an excellent series of blogs, taking us from the simple to some complex variations of control charts. All aimed at helping us answer "Is this normal??".

e73f46c9 66a6 40c0 8c8a cd68883eb5e4

ONE CLICK ZOOM IN AND OUT ON A MAP

This is a great Tableau post from Shinichiro Murakami and a simple use case for unioning a data source to itself. Now, why would you want to do that....? Shin walks through the steps to produce this great end-user experience.

2b814833 81ac 4aa8 ad79 51196e5dfa01

HOW TO SHOW TOP 10 LISTS IN TABLEAU TOOLTIPS

Ryan Sleeper combines action filters, context filters and Viz in Tooltips in this simple How to...part of a series that helps you get the most out of text in Tableau.

a91bf2b3 1f87 4cc3 a8b5 a35a3eb09146

BEYOND “SHOW ME” PART 1: IT’S ALL ABOUT THE X & Y

This is part 1 of a 2 part series on going beyond the charts available in the “Show Me” panel in Tableau by Ken Flerlage. He goes into detail about just how versatile the simple XY (or scatter) plot can be.

1b6e783e 2cdb 45bd a3c7 fac209684f6c

WHATS NEW IN TABLEAU PREP

Data prep is becoming more versatile each month. The latest release (2018.3) allows you to clean and track your changes in every step, apply wild card unions and connect to PDF files.

Now is a great time to start working with this tool if you haven't already. Why? Because they have just announced that from next year, we will be able to schedule Data Prep workflows. And THAT is a game changer.

5a3d7651 4f84 4ad2 8093 0008fb468fa7

FINDING PUBLIC DATASETS JUST GOT EASIER...

Google has launched a new type of search engine designed specifically around helping people find data. Simply called “Dataset Search,” the tool provides easier access to millions of datasets across thousands of data repositories on the web. Its in Beta, but well worth checking out if you haven't already.

8bb5b043 14b8 479a 9657 7b327085d952

FUNCTIONALITY COMPARISON - TABLEAU DESKTOP VS TABLEAU WEB EDITOR

If you need to understand what your users can do with web edit - and what they can't - this great resource created by Andrew Pick is the place to start. And it covers versions 9.0 through to 2018.2!

8114d0df 4d7a 415b 9f4c c6ab27d74b04

DO NOT MISS THIS TABLEAU REFERENCE GUIDE

Here is a "bonus track" for this edition of Tableau Bites.

BEWARE. This is a massive reference library provided by Jeffrey Shaffer and includes links to posts on Graphing, Color, Calculations and much more....by some of the masters as well as lesser-known Tableau authors.

Stick it in your bookmarks and come back often!

b1c40d58 fbc4 4d48 8be3 af5a1767bedc

NEW TO TABLEAU PREP? START WITH THESE FIVE FUNDAMENTALS

Annie Worman of Tableau talks through 5 easy to perform actions that you can do with Tableau Prep - the "new" tool from Tableau that has already had several releases. If you have a desktop license, then you can also get hold of this tool as part of your subscription. Learn how to Pivot, Group and Replace, Join and Union, Aggregate and Filter.

ff9971b8 c8b9 497f a3e8 f03ed8d1b6ac

EXAMPLE USE CASES OF TABLEAU CALCULATIONS

Olga Tsubiks introduces and provides example use cases of 10 frequently used Tableau Calculations. This is part of her guide to help get Tableau Certified and is a great resource.

1429fae9 d352 45ba af7c b2d8e71ca17a

AN ALTERNATIVE TO TREEMAPS

I am a fan of Treemaps, for specific use-cases, but they can be over-used. Elizabeth Ricks illustrates some pros and cons of using Treemaps, plus some possible alternatives.

22448f6c 6f7e 4930 a382 d1c3dfbe992c

DATA LITERACY, PART 3: ANALYSING THE FITNESS OF AVERAGES

Lilach Manheim walks through an example of the process for analysing fitness of averages and provides some ways of not "aggregating away" the insights.

cb4448fa 0427 41f9 a7e5 075b211166e6

UNDERSTAND AND EXECUTE THE FUNDAMENTALS LIKE A ZEN MASTER

Ryan Sleeper uses data from his blog posts to remind us that doing the fundamentals, well, is really what it takes to master Tableau. He then points us to 5 of his favourite Tableau tactics.

2c2cbc57 144a 4892 b498 7249bc691ceb

THE SPAWNING OF THE TADPOLE CHART

Mark Edwards talks through various incarnations of a design for a tadpole chart. This can be a great way to visualise period-over-period changes for multiple members in a dimension.

232ad934 b81d 4837 9da0 e930b22c332c

PREPARE SURVEY DATA FOR ANALYSIS WITH THREE EASY STEPS

Typically, survey data is formatted so that each row corresponds to an individual respondent and a column for each question.

Archana Ganeshalingam, a Product Consultant at Tableau, talks us through some simple steps we can perform within Tableau to help reshape the data to make it easier to analyse.

8cf8e720 4885 490f bca1 af1b20c4f8b5

THE BARCLAYS GENDER PAY GAP

...or, "Breaking News: Senior executives are paid more than junior positions". Jeffrey Shaffer talks about the dangers of using averages to draw conclusions from the data and gives some great examples that can be used if you need to argue the point.

03766945 4f1d 4091 b783 74c482b27fe3

USING POWERPOINT FOR TABLEAU GRAPHICS

Ken Flerlage points to an older post from Josh Tapley that gave him inspiration to use Powerpoint as a quick and easy graphics tool for some of his fantastic Tableau visualisations.

3d2b6c41 5972 4ffd 9bde 22d5238fbe06

HOW TO CREATE A CROSS DATABASE UNION

Joshua Milligan talks us through a neat workaround to create a cross-database Union - which is currently not supported in Tableau - by using Joins and the MAX function.

Even if you don't have a need, its a great reminder of how MIN/MAX functions can be used to get a desired outcome.

cac74423 0e96 418e 8239 d76b03067a0a

HOW TO BUILD A SANKEY DIAGRAM WITHOUT ANY DATA PREP BEFOREHAND

Sankey diagrams show the proportional "flow" (or make up) of one dimension from (or within) another.

Ian Baldwin of The Information Lab takes us through his 20 step process to create a Sankey without having to prepare the data before getting into Tableau - which would normally increase the data set as a bi-product. Well worth the effort in my opinion.

Data Duo

TEN QUESTIONS WITH THE DATA DUO

Michael Sandberg interviews the Data Duo, Pooja Gandhi and Adam Crahen, and pulls their top 3 favourite Tableau tips from each of them. The Data Duo have created more than 325 visualisations on Tableau Public (see the gallery at the end of the blog), so they certainly know what they are talking about.

22fc56b2 7667 4dbc 89d3 b2972016904d

QUIZ : MOST DANGEROUS COUNTRIES FOR MASS SHOOTINGS

Mark Jackson chooses this hot topic to introduce a very interesting use of Google Sheets to collect and display data directly through Tableau.

Yes, this provides you with the capability to collect data from users and display that through Tableau Server or Public - which is a feature I hear a lot of requests for, under the guise of "can I write data back from Tableau?". The viz has been kept simple for this under-the-hood hack, but think about how you can apply this in your organisation.

CREATING A BUTTON TO RESET FILTERS IN A DASHBOARD ON TABLEAU DESKTOP

I often get asked, "How do I clear all my filters" on a dashboard in Tableau Desktop. This simple approach can be used to clear a selection of filters as well "all". This use-case came up on a client project recently so thought you may also find it useful. Tableau knowledge base article.

5d21d260 73e5 453d 964e 6a1e8074e72f

INTRO-STYLE DASHBOARD WITH CROSS-DASHBOARD NAVIGATION

Ryan Sleeper has a series of posts about improving the User Interface on dashboards. This tip covers two approaches for guiding your user from a landing page through various additional "data story points". Simple but effective approaches that anyone can use.

6546e469 88d4 49d0 87cb 0f4285e8916f

KEEP IT SIMPLE STUPID

Tom Pilgrem of the Information Lab's data school applies KISS to 3 key aspects of dashboard design. It's always good to be reminded of the basics and how to apply them, to make sure your dashboard design is following good practice principles.

6c4a3b75 b30e 4660 83b8 373957e7dd49

TABLE CALCULATIONS - CUSTOM SORTS, PART THREE

In this post, Robert Curtis examines sorting on Discrete Measures and adds a few twists to present a bullet-in-bullet chart sorted based on user interaction. This technique also works when you want to sort dimensions on a field that is a blend-derived calculated measure - which are not available in the 'sort' menu. You can then just 'hide' the discrete pill header from the view if you don't want to show it in your viz.

aa42d0b5 78f1 41ae 8228 ec0729e22a6c

HOW TO USE SPATIAL BINNING FOR COMPLEX POINT DISTRIBUTION MAPS

In my training sessions, I warn people about using filled maps for data insights due to the possible issues of visual skewing.

In this article Sarah Battersby shows you how to overcome this with either square or hexagonal representation of geographical data. A great read, and its easier than you may think!

e8f3a47c a8bc 4c50 8071 ac33b774a221

VIZ IN TOOLTIPS BY EXAMPLE

What better way to see possibly the most popular new feature of any Tableau launch, Viz in Tooltips, than to see it showcased by Pooja Gandhi. Now in 10.5 - you should upgrade now just for this fantastic feature.

299ecf85 e502 47a0 a85a c9eea8aef497

MORE VIZ IN TOOLTIP EXAMPLES

If that example has inspired you, then take a look at the Viz in Tooltip gallery on Tableau public for more excellent examples.

ae4b587a 7771 47f6 92a9 39ce191f84d2

ANOTHER 10 TIPS FOR VIZ IN TOOLTIPS

This new features warrants 3 slots! Jeffrey Shaffer gives you a whole bunch of ways to use Viz in tooltips to your advantage. Be sure to follow the link to his earlier article.

0918209d 94d4 4e90 8686 c1dc170f3fc8

HOW TO USE INDEX() FOR EASIER TOP N TABLEAU FILTERS

Another great tip from Ryan Sleeper. This one helps you quickly dictate which rows you want to show when there are multiple filters in play on a worksheet.

30bb3156 1579 45e4 881e 181d97423310

COMPARING A TARGET GROUP WITH THE ENTIRE POPULATION

Steve Wexler talks through how to visualise both filtered and non-filtered results in the same view. This has many use cases and is well worth reading through his example using survey data.

d46462c9 179d 4ca3 9fc1 00693e9a96fe

LOD - THE EXCLUDE CALCULATION

Another great Deep Dive article by Robert Curtis, this time on using the 'Exclude' Level Of Detail expression.

bb49ff36 8546 459e b5d0 a8800165a0d0

MS OFFICE SERVER PLUGIN

Alex Ross provides a tool and steps for a server-side plug-in for those users that insist they need to export.

432a755f e85d 4161 8a49 cce917de52a7

THE DOS AND DON'TS OF DASHBOARDS

Post by Tableau. A dashboard is your go-to tool for communicating insights about a particular set of data. Building a great dashboard takes more than just putting all of your insights onto a canvas.

b4065caf 489b 4c56 becb 2363ed412bd8

3 TYPES OF DATA VISUALIZATIONS

Differentiating between different advanced visualisation types, Adam McCann provides good examples of how Data art, Infographics and Dashboards can be used.

24504f05 1a29 48bb bed1 995697bed3de

ENGAGING RELUCTANT STAKEHOLDERS IN THE DATA DESIGN PROCESS

Graceful Robot, aka Emma Cosh, talks us through her techniques for getting the right information from 3 different types of stakeholders.

6c9e0d57 4c3e 427e 8eb1 2d5fc7e968db

HOW TO MAKE PERFORMANCE INDICATOR TITLES

Ryan Sleeper shows a simple but effective way to conditionally colour a dashboard object based on whether the performance improved or declined.

bfc91b78 6289 4341 a982 b08199200390

HOW TO TALK IN ‘TABLISH’: LESSON 2

Joe Macari turns the Fixed LOD into plain English to help us apply in practice.

187911e0 5f5c 4ac5 805d dc932a181395

HOW TO ADD BIG ASS NUMBERS, SIMPLY

Charlie Hutcheson's blog introduces us to #RealTableau (recently initiated by Chris Love) and shows how to quickly add BAN's to a dashboard.

bb238a1a 6418 4420 892c eae6ca6d1570

HOW TO TAKE THE “SCREAMING CATS” OUT OF STACKED BAR AND AREA CHARTS

Steve Wexler, co-author of the BBOD, talks through some issues with, and good uses of the stacked bar chart, and provides a workbook example.

4a4c9b55 023d 4374 a435 620a1ec60aa5

WHAT TO NAME YOUR TABLEAU SERVER?

Paul Banoub talks through server naming factors that that help him sleep better at night as a server administrator.

9a16247b 6f7e 44c6 8da3 5f89e1fcb55f

THE INFORMATION IS BEAUTIFUL AWARDS 2017

A huge congratulations to Chloe Tseng, founder of the Viz for Social Good, and all that contributed, winning a silver for the community prize. Take a look at some of the fantastic Tableau visualisations this project has inspired here.

You can see the full list of winners here.

de542e33 3591 4aae a626 76cc21cc9d8a

HIGHLIGHTING DATA POINTS IN A CUSTOM DATE RANGE

From a series of tips by Ryan Sleeper to help improve the user experience of your dashboards by helping guide your end users.

ccb6b9b7 efcb 4152 afe0 a4188a7d8a36 1

CREATING A SHEET SELECTOR WITH DASHBOARD ACTIONS INSTEAD OF PARAMETERS

Matt Chambers talks through 2 alternatives for creating a sheet selector without using parameters, providing different user experiences. I love the join type of 1=1.

a5d8c93d 7d06 4f29 bc2e 22206138a356

ADDING ARC REFERENCE LINES TO A SCATTER PLOT

Alexander Mou talks through using a combination of union and polygons to create this effective type of visualisation.

344bada7 1431 4954 ae33 1ae5a05fe485

DEVELOPING A TABLEAU CENTRE OF EXCELLENCE

Simon Beaumont has pulled together an excellent resource package, in Tableau Public of course, to help others get the most from their Tableau deployments and analysts.

08044bb5 f082 47fc bb53 bd7abce4a4c6

THE TABLEAU FOUNDATION ANNUAL REPORT....UPDATED WEEKLY...

This Living Annual Report shows the work the Tableau Foundation has done so far and shares what they’ve learned along the way. Introduced by Neal Myrick.

535df6c8 ed8d 4b68 bebd d15d95be65be

LOOM ART IN TABLEAU

Just because you can. Ken Flerlage uses Bézier curves to create visualisations based on images. Although you're unlikely to use this extreme example, its good to see how this can be done.

0916232d 3081 439a b956 8d701568ce84

TIPS FOR DESIGNING MOBILE-FRIENDLY DASHBOARDS

Here are some useful pointers for you to consider, to help improve user engagement and wider adoption. Dash Davidson.

272f030d ecaf 4987 a41c 9cc0e63d9d24

7 TIPS AND TRICKS FOR DASHBOARDS

This Living Annual Report shows the work the Tableau Foundation has done so far and shares what they’ve learned along the way. Introduced by Neal Myrick.

3259eb5f bac5 4a38 9c20 da12e9759a5b

THE NEED FOR SPEED: HOW TO BUILD TABLEAU VISUALISATIONS QUICKLY

Just because you can. Ken Flerlage uses Bézier curves to create visualisations based on images. Although you're unlikely to use this extreme example, its good to see how this can be done.

1e307dbe 6f33 4c6c 991b 0a6ed0d254c4

EXPLORE THE VIZ THAT REIGNED SUPREME AT IRON VIZ 2017

The annual contest held at the global conference produced 3 great finalists and visualisations. All produced in 20 minutes.... Nancy Matthew.

c2dc8c2d 5136 410f bb70 c2a88ff32938

10.4 - TAKE COLLABORATION ONE STEP FURTHER

Generate data-driven discussions and improve decision-making. With viz snapshots, comments and 'people mentions' its easier to get others involved. Tableau.

b8630be8 392c 4f66 8682 298f87dd512e

10.5 BETA - 10 TIPS FOR VIZ IN TOOLTIPS

This long awaited new feature is currently in beta. Here are 10 ideas how to use once it is released. Jeffrey A. Shaffer.

05543fe4 d5e6 4b1f bdfc bef245839440

IN TABLEAU DEVELOPMENT - THE NEXT GENERATION DATA PREPARATION LAYER

Take a peek at how Project Maestro will assist the data preparation and workflow into Tableau. Tableau.

6e08137d 6083 4d6f 9ee1 699e9f750aee

END-OF-LINE TREND INDICATOR WITHOUT DUAL AXIS

This tip can provide an effective visual aid if you're already using dual axis for something else.

b1325178 cc76 4d4c a2fc 539a75e75f97

HOW TO "SPLIT-UP" A LONG BAR CHART

Every so often, an Analyst might run across a situation where they need to compare values among a very long list of categories. This approach avoids the dreaded scroll bar.

e405d95b ac13 4b4b 8432 e145f255ec7b

LETTING THE FORMATTING BLEND IN

Another snippet of best practice. This series is full of little ideas that make a difference.

82b398f9 54d6 446f a46b 5716c9753062

TABLEAU EXAMPLE: OBESITY IN AMERICA

A nice example for dynamic info graphics and relevant for #TCC17 attendees perhaps...

49ae6a94 4f0d 487f b2b8 9ca304dbf3c1

TABLEAU 10.4 FEATURE: USING LINEAR GEOMETRIES

Using London Bus Routes to show how this new feature can add customised detail to map views.

401f2221 73d1 49c6 bebf a2ddb86c53cc

HOW TO MAKE DYNAMIC TOOLTIPS

In this post, Ryan Sleeper shares how to make dynamic tooltips, allowing you to show different information for each mark.

502ba404 bd6b 4945 b6c8 c5b2261d7a7d

10 TIPS WHEN GIVEN SOMEONE ELSE’S WORK

It's always difficult picking up someone else's work to continue, and this article by Bridget Cogley gives some Tableau specific tips.

684101a2 653e 440d bd2e ce4a24bb22d4

ITERATION IS THE BEST WAY TO FIND INSIGHTS

Andy Cotgreave tells us there is simply no way you can open a dataset and know, ahead of that exploration, how best to display it.

598fd392 ac41 4556 b8db 60423af9efca scaled 1

5 KEY LEARNINGS FOR DATA DESIGNERS

The Tableau Research and Design team present their initial findings from an eye-tracking study.

2a4dc53a 784f 4129 8b1e 57859920a191

VIZZES ABOUT VIZZES

Ken Flerlage has been posting Tableau Public dashboards for a while now and thought he'd summarise some off them. Some interesting samples of work - don't forget to browse the top ones!

d5c7ec31 554f 4260 a6c8 a22c22413676

TABLEAU 10.4 - OUT NOW!

Just in case you missed it, the latest version was released this month. Take a look at some of the new features.

74974ecc 3a43 4073 9937 7a6bd5e24963

HOW TO MAP CIRCLE ROUTES IN TABLEAU 10.4

The spatial file connector now also supports linear geographies allowing infrastructure networks to be easily plotted.

1f005c14 0821 4b67 9884 76bd27bfd685

HOW TO DYNAMICALLY DISPLAY THE TOP N VS OTHER

Ryan Sleeper shows how to dynamically group everything outside the Top N into "Others" to maintain 100% of the data in a visualisation.

2e38b0c8 1224 4e3d b8f3 fdbeabfed18f

TWO APPROACHES TO BENCHMARKING WITH TABLEAU

Yvan Fornes tells how to perform benchmark analysis against the total population, or a subset of the data.

ccbada66 2a12 4dc7 ac2b d99bfaf6f36d

CONTAINERS: MY APPROACH IN 9 TIPS

Elena Hristozova tells us she used to hate Tableau's dashboard containers. These tips are intended to help you learn to love them.

66672829 c161 4ec5 9691 ae327ed9b06c

HOW TO SHADE BETWEEN 2 LINES

Rody Zakovich provides several ways to shade between two lines Tableau.

7d87984b 79a4 4374 9d00 ad3964880a5a

SHARPEN YOUR ANALYSIS WITH TOOLTIP SELECTION

Up until v10.3, tooltips just provided information. Now users can make selections and filters straight from the tooltip, in the flow.

1d68c825 9099 40f7 80d6 5190a4b7cc73

TABLEAU 10: A RADICAL OVERHAUL AIMS TO KEEP TABLEAU AT THE FOREFRONT OF THE PACK

If your organisation is still wondering whether to upgrade to Tableau 10, this independent overview of the latest features maybe of interest.

555c23a4 e48f 4ebb 858a e70e7ddbf5f2

A NEW WAY TO VISUALIZE AN INCOME STATEMENT

Andy Kriebel suggests an alternative approach to convert those "Excel" look-a-like Tableau reports for finance.

025d16af cb16 4d54 9f2e 3b83825ba404

10 WAYS TO ADD VALUE TO YOUR DASHBOARDS WITH MAPS

Sarah Battersby shares tips for improving the analytic and aesthetic value of maps in your dashboards.

74126ba2 b5c8 4d0f 926c 198d6c745330

REDESIGNING A CIRCULAR TIMELINE

Visualisation guru and author Alberto Cairo talks about improving circular visualisations.

2ca8e701 eb1c 417a 9814 a8504524bfd2

ORGANIZATIONS STRUGGLE WITH TIME TO VALUE FOR BI

Short summary of a TDWI research paper that highlights the obstacles analytics projects face and suggests best practices for overcoming those challenges. Leads to a link where you can download the 48 page white paper for free.

c4c2bd37 0113 42a3 90af f6bfeb36ea25

TABLEAU ACQUIRES NATURAL-LANGUAGE QUERY STARTUP CLEARGRAPH

Tableau stated that they would be developing "natural language" search capabilities last year. It will be interesting to see how this develops.

steve 1b circle

Steve Adams

Hi, I'm Steve Adams and I am a self-confessed analyst! Starting out over 25 years ago as an accountant, I became the Finance Director of a EUR 6B turnover company, delivering business analytics and performance management solutions. Since 2007 I have been consulting internationally in a wide range of industries.

I'm an agile BI practitioner. Visual analytics is an art form which I teach, study and enjoy.

For reporting, I believe that transparency and clarity of message are critical and I am a keen follower of the SUCCESS formula of the IBCS® (International Business Communication Standards). I am an IBCS® Certified Consultant.

My software weapon of choice is clearly Tableau and I am a Tableau Qualified Associate, consultant and trainer.

Get one, regular newsletter with everything you need to know about Tableau

Join enthusiasts who get the best Tableau articles straight into their inbox for free.