Get this email packed with useful links for people interested in improving their Tableau knowledge and skills.
"I think this is a brilliant newsletter, there's always so much going on in the Tableau community it can be hard to keep up."
Nai Louza, Data Analyst, UBS
"I just wanted to say what a superb feature this is, some fabulous content."
Simon Beaumont, Head of Information, Southern Health NHS
"Thanks for the newsletter, this is a really useful resource. I look forward to future editions."
Colin W, Datawoj Ltd
"Steve is a highly skilled trainer in Software products especially in Tableau. He has in depth knowledge from his time consulting with clients and his deep knowledge of the product.
He is able to gauge the experience of the group and react accordingly. Steve should be your #1 choice for independent Tableau training in the UK."
Daniel Ruthenberg, Account Manager, Tableau Software
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:
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.
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.
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.
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.
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'.
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?
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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!
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!
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.
Lilach Manheim walks through an example of the process for analysing fitness of averages and provides some ways of not "aggregating away" the insights.
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.
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.
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.
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.
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.
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.