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.
April 24, 2024
20 Dashboard Design Best Practices
April 23, 2024
How to Create Rounded Bar Charts in Tableau
A rounded bar chart is a type of bar chart where the ends of the bars are rounded instead of being straight. They create a more visually appealing and softer look to the chart.April 21, 2024
How to Create Custom Date Hierarchies in Tableau
April 20, 2024
The What, Why, and How of Custom Dates in Tableau
Custom dates allow users to define the level of granularity and format of the date field according to their specific needs based on existing date fields in the data.Why you should build a Tableau Public profile
April 18, 2024
How to Create a Donut Chart in Tableau
Which chart would you like to show?
Beginners and advanced designers alike get stuck deciding which chart is right for their data. Next time you're stuck, try this chart guide by Damola Ladipo.
Check it out on Tableau Public here. Click the image below for a hi-res version to print.
April 16, 2024
How to Create a Bar-in-Bar Chart in Tableau
A bar in bar chart is a type of chart in that allows for comparisons between two measures. It involves placing one measure as the main bar and another measure as a smaller bar inside the main bar.April 13, 2024
25 Example to Help You Master Calculations in Tableau
How to Create a Proportional Stacked Bar Chart in Tableau
Proportional stacked bar charts are a good way of showing the size and proportion of data at the same time.
April 10, 2024
How to make sense of ANY data set
Demystify ANY data set by answering 5 simple questions:
- When?
- Where?
- Which?
- Who?
- Why?
----------
P.S. Newsletter subscribers get a deeper dive into each of these for FREE when they sign up. Go to andykriebel.com to get yours.
11 Ways to Compare Two Measures
I don't believe in complexity in data visualization. I stick with simple charts when you needs to compare measures to add context.
Tableau workbook here.
April 9, 2024
The Ultimate Tableau Date Calcs Cheat Sheet
How to Create a Floating Bar Chart in Tableau
A floating bar chart is similar to a Gantt chart, except it shows the range of two data points instead of two dates.
April 8, 2024
How to Create an Enclosed Dot Plot in Tableau
An enclosed dot plot is similar to a barbell charts except the line connecting the dots surrounds the dots.
April 7, 2024
How to Create a Barbell Chart in Tableau
A barbell chart is a dot plot that shows two or more points and also connects those points to display the range.
April 6, 2024
How to Create a Histogram in Tableau
A histogram visualizes the distribution of data over a continuous interval. Each bar represents the frequency at each bin.
18 Ways to Visualize Bar Charts in Tableau
The SECRET to never choosing the wrong chart...the Bar Chart! Here are 18 options for your next bar chart.
Tableau tutorial and workbook here.
How to Create a Heatmap in Tableau
A heat map is a good way of showing the patterns between 2 categories of data. They use color to encode the intensity of the relationships in the matrix.
April 3, 2024
How to Create a Butterfly Chart in Tableau
A butterfly chart is a type of bar chart where two sets of data series are displayed side-by-side each going a different direction.
Follow a video tutorial here and here.
April 2, 2024
60 Ways to Visualize Time Series Data in Tableau
I don't believe in creating fancy visualization to get attention. I prefer easy to understand. Here's my complete list of 60 unique ways to visualize time series data.
Learn to build them here. View the workbook here. Download it on Gumroad here (for a small fee).
April 1, 2024
#WatchMeViz: Can viral infections be cured with antibiotics?
March 27, 2024
8 Reasons Power BI isn't "FREE"
What are joins?
I bet you didn't know how easy it is to understand the 4 types of joins. Let me show you...March 11, 2024
#MakeoverMonday 2024 Week 11 - Housing Vacancies in America
- Size - 1000x475
- Max 4 containers; no tiled containers allowed
- Filter out Alaska, Hawaii and Puerto Rico
- Clicking on a MSA in the map highlights the MSA in the map and bar chart and changes the MSAs that are displayed in the bar chart
- The bar chart shows the rank of the MSA for the metric selected.
- There should always be 11 bars (though I didn't test the lowest rank).
- The label on the end of the bar and in the map reflect the formatting of the measure selected (i.e., either whole numbers or a percentage to one decimaal).
- Include an option to change the measure and to change the number of MSAs on the map.
- Create a mobile view
- NO LODS!
March 8, 2024
Visualizing Time Series Data in Tableau
Last night I was invited to speak at the Chicago Tableau User Group about visualizing time series data. Other than spatial data, time series data is my favorite to visualize.
There seem to be endless methods for making time series data useful for analysis. Check out this video for 60ish ways to visualize time.
I had a 20 minute slot to present and, of course, I ran over time. I seem to do this with every session I run lately. Be it training for Next-Level Tableau, presenting at events, or running a livestream, I get into a groove and don't want to stop.
I was able to create 14 vizzes in 20+ minutes. I added an extra in this workbook to make the dashboard format nicely.
Click on the image below to download the workbook and dissect it. Get the data here to follow along.
Have fun!
March 6, 2024
What does Level of Detail mean in Tableau?
If you’re serious about learning Tableau, you must understand the level of detail of the view. Another way to think about it is the level of granularity.
This is essential for ensuring you know the aggregations that Tableau will perform as this will impact your analysis.
Here's a guide to help you:
March 5, 2024
11 Steps to Create KPIs & Sparklines in the Same Sheet in Tableau
Want to cut the number of sheets you need in your KPI dashboard in half? These 11 simple steps will get much closer.
Steal the calcs to speed up your work.
P.S. If you like tips like this, remember to follow me on LinkedIn so you're notified about everyting I post. Content curated just for you, 3 times daily.
February 26, 2024
How I Create a Beeswarm Chart in Tableau
Beeswarm charts a one method of showing distributions in a data set. I show you how to create one in this #MakeoverMonday livestream.
Download the workbook | Download the data
January 8, 2024
Step-by-Step Guide to Building a Beautiful Bump Chart in Tableau
We all create charts we know *could* be better.
Here's how to make your next bump chart look like magic 🤯
Tableau is incredible for creating bump charts...
But 99% use shortcuts which don't look great.
Here's my secret:
It all comes down to the small details.
Each step has to be done right to get the view you want.
Most people don't follow these steps.
And even more don't know how to make it look great...
I'm going to show you how.
In this tip, I give you specific step-by-step instructions to get your bump chart to look just right.
👀 Do you want a copy of my viz? 👀
You got it!
Send a DM on LinkedIn saying CHART MAGIC! and I'll send you a PDF of the instructions AND the workbook for you to use for FREE.