All tagged Tableau Data Prep
Unions are an incredibly powerful tool in our data prep stage when working in Tableau Desktop. But how do you know when to use a Union and when to use a Join?
The general rule of thumb is: when you want to add rows of data to your data source, use a union!
Are you having trouble getting your data to work in Tableau the way you want? Join us to learn how to prepare data for analysis in Tableau!
You can find a thousand tutorials on how to use Tableau, but they're all worthless until your data is structured for analysis in the format that Tableau likes. Don't get stuck in your analysis journey because Tableau doesn't like your data.
6 data formats to avoid, 8 key rules for structuring data, and 1 video you can't miss. Check out the recording to learn about the key concepts you can utilize to prepare for your data for Tableau.
When joining two tables in Tableau, have you ever wondered any of the following questions?
Is the join working?
Is the join resulting in data duplication?
Am I losing rows of data due to the type or argument of the join?
Tableau's default method for relating tables of data on shared columns is now Relationships. The previous default was joins. Despite looking outwardly similar, these approaches have some key differences.
Groups are an incredible feature in Tableau, but they are limited. For instance, you can’t leverage a group for a blend or cross-database join.
If you need to use the output of a group for data preparation, you will probably want to turn it into a calculated field. Rather than doing it slowly by hand, why not leverage a quick calculation which can speed up the process?
Check out the video below to learn how you can easily turn a group into a calculated field in Tableau.
No! This post is not a mistake. It really is our third blog post in the last three years detailing how to transpose values in Tableau Prep. The tool is rapidly evolving, and the good new is that the process of transposing values is becoming more seamless each time.
Did you know there are at least 3 different types of groups you can create? Which of the types is a best fit for you depends largely on your situation and data.
I’ve known for several years that Google Sheets is the only data source which Tableau Public can automatically refresh for users. Until a few weeks ago, I had never tried to set up a living connection between Tableau Public and a routinely updated Google Sheet. It turns out that Tableau Public is good at holding up it’s end of the bargain, but keeping Google Sheets updated isn’t as simple.
While working with personally identifiable information, you may need to suppress sensitive data. Let’s say that you are working with healthcare data and want to suppress patient names.
I was recently working with a client when we hit a roadblock. We came across a situation where we needed to create a multi-row formula and Tableau Desktop is not equipped to do that. Let me walk you through the situation.
The new Tableau Relationships feature will likely replace joins in a lot of circumstances. I was recently asked, “What kind of join does the Tableau Relationships feature most closely resemble?” I didn’t know with certainty so I did some digging.
“Relationships” are a new and powerful way to connect tables of data in Tableau and are included in the release of Tableau Desktop 2020.2.
Data scaffolding allows you to generate missing data for visualization purposes.
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.
You might never have heard of a self join but you might need one. Occasionally, tables in a database are structured so that it makes sense to join a copy of a table to itself…
