Data Preparation — The OneNumber Blog

Tableau Prep

One of the primary ways we combine multiple tables of data in Tableau Prep is with joins! Joins allow us to merge multiple tables of data horizontally on a common key.

One of the things that distinguishes joins in Tableau Prep from Tableau Desktop are all the join types we can create! In Tableau Desktop, we're limited to Left, Right, Inner and Outer joins. In Tableau Prep we have those four options with the addition of Left Unmatched, Right Matched and All Unmatched. Those unmatched join types provide greater flexibility to create customized workflows and identify values which did not match in our join clause.

Jul 12
Jul 12 How to Calculate Running Headcount in Tableau with Start and End Date Fields

Data, Table Calculations, Tableau Calculations

Do you want to use Tableau to look at running headcount over time? For example, you work with employee level data which has Start Dates and End Dates and you'd like to be able to see how the total active headcount at the company has changed over the last 8 quarters.

That's something Tableau can do, but it isn't going to work out of the box. It's going to take some creative data structuring and calculations to get things working.

Jun 28
Jun 28 Why Tableau Created Relationships

Tableau Relationships, Data

In 2020, Tableau unveiled a new way to combine multiple tables of data in Tableau Desktop: a Relationship. Billed as "smart joins", relationships provide the capability to merge multiple tables of data horizontally on shared dimensions (like a join). However, they don't duplicate data when the tables being combined have different levels of granularity.

So, are they better than joins? Not always! Relationships can reduce data duplication and improve performance, but a data set that is generated from a relationship might present blind spots if the data isn't perfectly clean.

Apr 12
Apr 12 How to Union Tables in Tableau Desktop

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!

Jan 18
Jan 18 How to Tableau: Pivots in Tableau Desktop

Tableau General Knowledge

Getting the structure of our data correct for Tableau Desktop can make a huge difference. Tableau is pretty picky about the way it wants our data to be formatted. Generally, each column should be a new dimension or measure.

Jan 11
Jan 11 Tableau Join Types Explained (Left, Right, Inner, Outer)

Joins in Tableau Desktop are one of the primary methods for combining multiple tables of data horizontally. One of the great things about joins are their flexibility! You can choose if you'd like to keep all data from both tables in your result set, or if you prefer to keep only matching records.

Dec 14
Dec 14 How to Tableau: Cross-Database Joins

Tableau General Knowledge

A huge benefit of using joins in Tableau is that we can combine data from multiple tables into a single table for analysis. When those tables are in different databases, it can be a little tricky to work out where to start. If you know how to join tables within the same database, that's great! Cross-database joins only take a few more steps to execute, and I'll walk you through them in today's video.

Aug 11
Aug 11 Tableau Join Calculations

Data, Tableau Calculations

How do you join two tables together in Tableau when they don’t share the same common field? Or what if that common field is slightly different in both tables? A Join Calculation can help solve a lot of those problems! In this video, we take a look at how to use a join calculation to join tables with mismatched fields.

Jun 28
Jun 28 How to Prepare (Structure) Data for Tableau - Webinar Recording

Data, Tableau Prep

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.

May 5
May 5 Tableau Blending; Why am I getting an asterisk (*)?

Blending is nearly as old as Tableau Desktop itself. Executing a blend in Tableau is a method for relating data from multiple different tables so it can be analyzed together. For instance, a sales value and a quota.

Apr 14
Apr 14 How to Keep Superstore Data Sets Up to Date for Tableau

The superstore data that Tableau provides is a helpful tool for practice, mockups and trying out concepts. However, one of the frustrations is that it can get “out of date” so to speak so the latest date in the data set might be December 31, 2021 even though today’s date is month’s later.

Apr 7
Apr 7 How to Validate Join Results in Tableau Desktop

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?

Mar 10
Mar 10 Preparing Survey Data in Tableau Desktop - Webinar Recording

In its natural state, survey data is rarely in a format where it is optimized for analysis. If you need to visualize survey data, it's likely going to require some preparation and reshaping.

Dec 9
Dec 9 Tableau Relationships vs. Joins - Webinar Recording

Tableau Relationships

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.

Oct 21
Oct 21 Easily Turn a Tableau Group into a Calculated Field