September 26, 2024
Stop Chart Disasters NOW With This Crucial Method
August 30, 2024
How to Create a Win/Loss Sparkline
Check out the workbook here.
August 15, 2024
How Popular is Your Birthday?
Click on your birthday to see how popular it is.
July 8, 2024
Build an interactive Tableau dashboard in 3 minutes!
Build 80% of your dashboards with these 4 charts, a bit of interactivity, and that's it.
You probably won't need to create anything fancy, formatting will be minimal, and you won't need to wrestle with containers.
This video show you how to create it in only 3 minutes!
June 30, 2024
How to Rank & Filter the Top 5 in Tableau in Under 60 Seconds!
June 28, 2024
How to Replace a Datasource & Fields in Tableau
Need to change a datasource but don't want to rebuild the workbook? Has a field name changed?
It can be a real pain to update each sheet in a workbook one by one.
Conveniently, Tableau allows you to change the entire datasource with the "Replace Datasource" option.
Or, if you only need to change a field, Tableau has an option called "Replace References" that allows you to swap one field out for another all in one shot.
In this example, I take you through the whole process.
You could also apply this method when you simply want to swap out all existences of one field for another.
For example, you want to change all used of Order Date to Ship Date.
Easy peasy!
June 25, 2024
How to Create a 9-Box Matrix in Tableau
In this video, I show you how to build a 9-box matrix.
These are commonly used in talent management and HR to map a company's workforce along two dimensions, potential and performance.
Each of these two dimensions is split up into three categories, low, medium, and high, depending on the score.
For each employee performance is then plotted horizontally and potential is plotted vertically. From there, we summarize the number of employees that fall within each box.
June 20, 2024
How to Simultaneously Highlight & Deselect with a Parameter Action in Tableau
June 4, 2024
Find Red Flags in Your Data in ONLY 5 MINUTES with Control Charts
May 26, 2024
How to Create a Barcode Chart in Tableau
May 25, 2024
How to Calculate Year over Year Change in Tableau
How to Create a Dot Strip Plot in Tableau
May 15, 2024
#MakeoverMonday 2024 Week 20 - Exporting Freedom, One Bullet at a Time
I struggled mightily with this week's #MakeoverMonday. My goals was to replicate the original visualization by Bloomberg.
I knew I need to create path to connect the US at the center to each country.
I wanted to make the US the center of the of the map.
Sounds simple, right? I made it way harder than it needed to be.- I overthought the data prep.
- I forgot how to create the paths.
- I couldn't get the math right to offset the longitude.
The coloring and labeling was straightforward for me.
Adding the US as a circle in the middle was pretty simple.
To overcome the problems I facedI looked at a previous visualization I created using paths.
- I opened the workbook and the data to see the configuration.
- I replicated that set up by adding a second set of records to the data set.
- Viewers on the livestream helped me figure out the math to offset the longitude.
The simplest way to explain the location of each country is to think of the lat/lon for the US as 0,0. Then you compare that to the lat/lon for every other country to create the offset.
I got there in the end. What do you think? Was the juice worth the squeeze?
Click the image below to access the viz.
May 3, 2024
How to Make Your Cycle Plots Actionable in Tableau
Cycle plots are a fantastic way to identify seasonality in a data set. And you can make them even more useful by adding indicators for whether they are above or below the average.
Here's how you can do that in Tableau in only 2 minutes.
Like this? You'll love Next-Level Tableau. Learn more at nextleveltableau.com.
May 1, 2024
Which chart should you use for your analysis?
Over on Tableau Public, Judit Bekker create this fantastic directory of charts to help you pick the one that's most appropriate for your analysis.
Check it out below.
How to Create a Cycle Plot in Tableau
April 30, 2024
How I Create a Unit Histogram in Tableau
A unit histogram is a chart that shows the distribution of data points across a series of bins of a measure.
Unlike a traditional histogram that uses bars, a unit histogram consists of a set of marks, each representing a member of a dimension.
In this example, our final result is a unit histogram showing the distribution of states by their average sales.
If you like this, you'll love Next-Level Tableau. You get over 175 hours of live training with me, 130+ on-demand videos, workshops, office hours, workbooks, data sets, lots of new videos each year, any new courses I create, and a great Community.
Get more info and sign up today at nextleveltableau.com.
April 29, 2024
How to Create a Comet Chart in Tableau
April 26, 2024
Jumpy Curvy Things in Tableau
I received a request to teach how to build a jump plot during Next-Level Tableau office hours. The idea was to recreate this visualization that I created for Makeover Monday back in 2018.
The problem, though, was that the data preparation was done in Alteryx, which I no longer have a license for. Thanks for a member of NLT that had an Alteryx license, we were able to decode what the workflow was doing.
Then, in office hours, we recreated the data prep in Tableau Prep before building the visualization in Tableau. Download the Prep flow here. Download the workbook below.
This is just one example of one thing learned as a member of NLT. Sign up today and I guarantee you'll become a Tableau expert.
April 25, 2024
The ULTIMATE Guide to Custom Visualizations in Tableau
Here's the ultimate guide to custom visualizations in Tableau. Each chart contains a link to a tutorial so you can build it too.
I rarely use these charts on a day-to-day basis, but they are a fantastic way to build your technical skills.
Have you used any of these in a business context? Click on the image to view on Tableau Public.