Useful, fun, and sometimes off-the-beaten path, these Tableau tips will often challenge and inspire you
One thing I’ve submitted an idea for Tableau Prep (and would love if you voted for it!) is the ability to use Table Calculations, especially Index() and PreviousValue(). This would solve a lot of use cases, including adding row numbers, rank, sort, handling cumulative values, and more. But to compute a rank or sort specifically, […]Continue Reading... 2 Comments.
How to handle new input files in Tableau Prep Let’s say you’ve got a situation where you get new input files for Tableau Prep every month (or, maybe in your case it’s every week or every day or every so often). These aren’t files to be added to your data source in addition to existing […]Continue Reading... 2 Comments.
One of the questions that comes up quite often is “How do I remove duplicate records in Tableau Prep?” or “How do I dedup data in Tableau Prep?” Some data preparation tools have a specific feature to do this. At first glance, the first version of Tableau Prep doesn’t seem to have this feature. BUT […]Continue Reading... No Comments.
Tableau 2018.1 introduces a lot of new features, especially geospatial features that open a whole new world of data exploration and analysis. With support for SQL Server geospatial data types, there are near-infinite possibilities. I’m sure I’ll have more than a few posts on various options soon! Here’s one thing you can do: render circles […]Continue Reading... 8 Comments.
Cross database joins have been available in Tableau for a while now – and I love the ability to join data at a row-level across various databases and files! And union functionality is available, but for now, only if you are dealing with tables in the same database (or files or Excel tabs). But what […]Continue Reading... 3 Comments.
I recently competed in the Tableau Iron Viz where Tristian Guillevin, Jacob Olsufka and I raced to build a dashboard in 20 minutes! One of the most incredible things about Tableau is how versatile it is as a tool. You can spend hours to build a stunning Tableau dashboard or just a few minutes to […]Continue Reading... 10 Comments.
I recently came across this post by Simona Loffredo in which she describes a certain type of data structure, why it wasn’t ideal for analysis, and how to reshape it using Alteryx. While I love Alteryx and really love how it can be used alongside Tableau, I get especially excited when I can do something without […]Continue Reading... 1 Comment.
Wow! I’m still stunned to have won the first IronViz feeder contest for 2017! And excited! And humbled. And honored. Wow! Thank you to everyone who has had kind words of encouragement! You can read some broad description of my entry here: The Changing Shape of History: From the Colonies to the United States. In […]Continue Reading... No Comments.
The Tableau technique shown here is to use an action to update an entire dashboard, including the filter selection and the view which triggered the action. The trick doesn’t have to be used to navigate hierarchies or hierarchical data, but it happens to work very nicely for that purpose. Let’s say you have a Tableau […]Continue Reading... No Comments.
I really love the Tableau Community Forums. If you haven’t ever experienced the forums, you really should! It’s a vibrant community all centered around helping people learn Tableau and solve real world problems! You can participate as a helper and provide answers to individuals who are asking Tableau questions or ask for help if you have a […]Continue Reading... 5 Comments.