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... 4 Comments.
You know you have a great piece of software when you can use its paradigm to come up with workarounds to features that don’t yet exist. Such is the case with Tableau Prep (formerly Project Maestro). I recently needed to unpivot some data and realized, the Tableau devs are truly miracle workers! Unpivot Data – […]Continue Reading... No 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 had the privilege of presenting a preview of Tableau’s Project Maestro (now known as Tableau Prep) to the Amazon Tableau User Group. This is not the exact presentation, but is a very similar data flow to the one I demonstrated there. The flow also shows how to replicate a Level of Detail calculation […]Continue Reading... No Comments.
Often, you’ll have data that looks something like this: Every day, there are new records for projects that give the latest status and count of hours used. Often a project spans multiple days and the status can change and count of hours might go up. But if I want to get the most recent […]Continue Reading... 3 Comments.
I love hex maps! Especially for the United States, you can keep states in a basic geographic orientation, but eliminate the visual perception problems caused by the fact that some states are huge compared to others (and Alaska and Hawaii shift the scale when added). But there are a few headaches that can occur when […]Continue Reading... 11 Comments.
Tableau’s new data prep tool, Maestro, is now in public beta, and I’m loving it! While the first beta doesn’t necessarily include all the features that might soon make it to a production release, what blows me away is the overall paradigm. It brings the intuitiveness and transparency that Tableau brought to visual analytics and […]Continue Reading... 3 Comments.
I used to think you couldn’t hot-swap geographic levels of detail in a Tableau visualization. And, before Tableau 10, you couldn’t. I mean, of course in Desktop or web authoring mode you can drag and drop fields, but for the end-user of a dashboard that wasn’t an option. You might have thought to use […]Continue Reading... No 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.