In June, 2018 I wrote a blog post about three things Tableau Prep couldn’t do. One of those was the ability to transpose (unpivot) data. That is no longer the case.
Working with data that isn’t clean can be a pain. One of the most frequent data issues I come across is dealing with duplicated rows of data.
Imagine you have a dashboard that looks almost exactly the way you want. The data looks great, the visuals are just right, but the colors are a little off…
Imagine you’ve run into a scenario where you want to be able to show a little more information on your dashboard but it makes it feel too cluttered. However, it’s not nearly enough extra information that it warrants creating an entirely separate dashboard. This is a great opportunity to use a little known feature in Tableau that allows you to expand and contract worksheets in a dashboard.
Have you ever had an experience in Tableau where you set a filter but don’t get the results you expected? There are multiple reasons that can happen. One of them is that you can set multiple filter criteria in a single pill on the Filters Card.
URL actions open up a new world of possibilities in Tableau dashboards. You can link to a URL field, look up a data point of interest, or even create an action that creates an email form. URL actions have been used to successfully linked sales opportunities to Salesforce, link furniture companies to their products on the web and generate emails to further discussion about data points of interest.
I recently finished a book called, Astroball written by Ben Reiter. It tells the unlikely story of how the Astros went from the worst team in baseball to winning a World Series a few seasons later. As much as I wish I could say I didn’t like the book (I’m a Mariners fan after all) it was a compelling read and gave me great insight into their organization and methodology.
Creating a calendar visual in Tableau can be an effective way of communicating data-based information to your end user. For example, using a calendar in an effective way of seeing that sales are highest on Saturdays for this restaurant.
Occasionally, you’ll come across scenarios in Tableau where you need more than the stock shapes that Tableau provides.
I recently read the book Shadow Divers by Robert Kurson. Spoiler alert; I’m going to reveal a lot about the book’s plot.