VizWiz

Launch, grow, and unlock your career in data
Showing posts with label split. Show all posts

February 18, 2026

How to Use Split, Custom Split, and Replace in Tableau

No comments
In this lesson, I walk through three of the most useful text functions in Tableau for cleaning and transforming string data:

• Split
• Custom Split
• Replace

We use a real-world example based on U.S. county data.

At first glance, it looks simple. You might just want to remove the word “County” from your geographic names.

But then you hit real data.

Louisiana uses “Parish.”
Other regions have different naming conventions.
And suddenly, a simple clean-up task requires more thought.

Inside this video, I’ll show you:

• When to use Split vs Custom Split
• When Replace is the better option
• How to handle inconsistent naming conventions
• Practical tips for cleaner geographic data
• How small text changes impact downstream analysis

This is the kind of data prep work that makes the rest of your dashboard development much easier.

You can download the workbook and dataset used in this lesson here:

If you’re serious about leveling up your Tableau skills, this is exactly the kind of practical training we go deeper on inside Next-Level Tableau.

Live classes.
Real use cases.
Advanced techniques you can apply immediately.

Learn more here:



----------

To go deeper, check out my courses:
→ Tableau Starter Kit - A beginner-friendly course designed to help you understand Tableau quickly - https://www.nextleveltableau.com/starterkit

→ Tableau Core Concepts - A comprehensive, self-paced course for Tableau users ready to level up - https://www.nextleveltableau.com/tcc

→ Join Next-Level Tableau - My most comprehensive Tableau program to help analysts become industry leaders, with the support of a like-minded community, and 1-to-1 help from me - https://www.nextleveltableau.com/

📩 The Dual Axis Newletter
Each week, I'll send you Tableau tips, tutorials, and strategies to design better dashboards, have more impactful, and stand out in your career: https://nlt.kit.com/

June 27, 2023

Blue vs. Green - What does it mean?

No comments

When I first started using #Tableau, I assumed that blue meant dimensions and green meant measures. They don’t.

Blue means Discrete
Green means Continuous

It took me a couple of years to get my head around this most foundational concept in Tableau.

Dimensions and measures are merely a way that Tableau organizes the data.

And if you only take away one thing from this video, this is it:

  • Blue things GROUP your data
  • Green things COUNT your data
  • Dimensions SPLIT up the view
  • Measures FILL the view
I've spent years teaching people what blue and green mean in Tableau and I keep coming up with new methods. In this video, I’ll explain the entire concept to you.


June 5, 2018

Tableau Tip Tuesday: Split, Pivoting and Union with Tableau Prep

No comments
Now that the manuscript of the Makeover Monday book (pre-order here) has been sent to the publisher, I'm going to do my best to get back into a rhythm with weekly tips. This week, I'm going to show you how I used Tableau Prep to prepare the data for my Makeover Monday viz this week. It involves splitting eight columns into two sets of four, renaming fields, pivoting the data, and then unioning it all back together.

You can download the flow here.