Recently I gave a “State of the Unions” address for Tableau’s Think Data Thursday (the recording is here) in which I discussed new features for unions in Tableau Prep and Tableau Desktop. One thing I didn’t cover, but has subsequently come up is the question “What about INTERSECT and MINUS or EXCEPT Unions”? Can we […]Continue Reading... No Comments.
I am so excited to head to NOLA for #TC18! Tableau always puts on an amazing conference and I cannot wait to be there, see everyone in person, see #DevsOnStage, #IronViz, and all the amazing keynotes. If you’re there too, let me know! I’d love to see you! Here are a few of the things […]Continue Reading... 3 Comments.
I’ve been hearing about DataRobot for a while now (in fact, Teknion Data Solutions, where I’ve been a consultant for nearly 15 years, recently became a DataRobot partner) but I hadn’t had the chance to be involved in actually using DataRobot… …until now!And in conjunction with my colleague and fellow Tableau Zen Master, Bridget Cogley, […]Continue Reading... No Comments.
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... 8 Comments.
How can you leverage SQL Server geospatial tools in Tableau to draw cool curved flight paths (or any great arcs)? I’m glad you asked! When I first started learning Tableau, one of the most difficult things I encountered was the Path shelf. I just didn’t get it. Why would lines break when you placed certain […]Continue Reading... No 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... 3 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... 11 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... 14 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.