VizWiz

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

January 22, 2025

L-Shaped Bars: The Chart You Didn't Know You Needed

No comments
In this Tableau tutorial, I’ll walk you through how to create L-shaped bar charts, a unique and visually way to display your data, perfect for giving your dashboards a fresh, modern look.

You’ll learn:

- How to connect and prepare your data using Superstore and custom point files.
- Creating relationships and calculated fields to build the L-shaped structure.
- Using Tableau’s Map Layers feature to add detail and customization.
- Formatting and finalizing your chart for dashboards.

Whether you’re impressing stakeholders or sharpening your Tableau skills, this step-by-step guide has you covered!

Resources:
🔗 Point data files
🔗 Tableau workbook


P.S. Want to become an advanced Tableau user?

Unlock your full potential with Next-Level Tableau, the ultimate training program for Tableau users. Gain access to expert-led tutorials, live sessions, and a supportive community designed to help you master advanced skills, create stunning dashboards, and achieve your career goals. Learn more and take your Tableau skills to the next level today at nextleveltableau.com.

Unsure? Sign up for my free course at starter.nextleveltableau.com.

May 1, 2024

Which chart should you use for your analysis?

No comments

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.

October 24, 2023

Master Containers: Build an Interactive Tableau Dashboard From Scratch

No comments
In this video you will learn step-by-step how to create an interactive Tableau dashboard. 

We'll start with a 2 datasets:

1. Beverage sales
2. Custom shape for US states

I will show you how relationships work in Tableau to combine these two datasets.

Once we create the data set, we'll build all of the charts we need, create a parameter, and apply the filters.

We’ll create:

1. Summary key figures (KPIs)
2. A custom map of the US
3. A monthly breakdown as a line chart
4. Two bar charts for products and customers

Lastly, we'll make the dashboard dynamic and interactive using different filter types and a parameter and make sure everything updates automatically.

As a bonus, you’ll learn a lot about working with containers in Tableau.

Resources:
1. Data
3. Workbook (or click the image below)


May 11, 2022

How to Color BANs by Positive or Negative Change

No comments
In this tip, I show you two methods for coloring BANs based on whether there is a positive or negative change. The first method colors the entire BAN, whereas the second method only colors the value of the change itself.

March 22, 2022

Two Methods for Labeling the Top N Values in a Chart

No comments

In this tip I show you how to use the INDEX and RANK functions to label the top N values in a chart. I also explain the difference in how they work, and how the RANK function is simpler to configure.


March 11, 2022

How to Include Multiple Dimensions on the Color Shelf

No comments
In this tip, I show you how to include more than one field on the color shelp. 

A few notes:
  1. You can have more than two dimensions on the color shelf. Simply repeat the steps for adding a second color.
  2. This only works for dimensions, as I show in the video.
  3. You do not have to use Sets for this to work; I used that in my example for simplicity.

February 15, 2022

How to Create a Barbell Chart

No comments
In this tip, I show you two methods for creating a barbell chart. The first method uses two measures and the second method uses one measure split up by a dimension.

February 8, 2022

How to Create an Enclosed Dot Plot

No comments
In this tip, I show you how to create an enclosed dot plot, which is essentially a dot plot that is enclosed by a line. It's very similar to a barbell chart except the line connecting the dots surrounds to dots.

February 2, 2022

How to Create a Jitter Plot

No comments

In this tip I show you how to create a jitter plot. A jitter plot is very similar to a dot strip plot other than it reduces the overlapping of the data points. The data is plotted like a dot plot and then we use either the RANDOM() or INDEX() functions to spread out the dots.

Data - https://data.world/vizwiz/mock-car-sales

January 25, 2022

How to Calculate the Distance Between Two Points

No comments
In this tip, I show you how to use the Distance function in Tableau to calculate the distance between two points. I also show you how to use the Makepoint and Makeline functions to draw the map. 

Download the data set to follow along here - https://data.world/vizwiz/airport-to-airport-routes

July 19, 2021

#MakeoverMonday 2021 Week 29 - Non-Whites Are At Higher Risk of Dying From COVID-19

No comments

Another COVID-19 data set this week and a great visualization that shows how much more likely ethnic minorities in the UK are to die from COVID.

In the video, I worked through rebuilding the original viz since I liked it so much. Interact with the viz below the video.


July 7, 2021

#WOW2021 Week 26 - Profitability With a Dual Axis Chart

No comments
Typically our Wise Up Wednesday crew do these together but today, I was on my own In this video, I take you through how I completed Workout Wednesday 2021 week 26. It's a bit of a ramble since I started from scratch, but I got there.

Video and solution below...


June 7, 2021

#MakeoverMonday 2021 Week 23: The Percentage of Never Married is on the Rise

No comments
This week I iterated through 12 charts and a dashboard in 50 minutes. Once again, I ended up with a bar chart. They're rarely going to let you down. The only other bit I added was the thinner bar showing the change from 2006 to 2016.

Resources:
  1. Final Viz (and below)
  2. Preferences file (all of my custom color palettes)
  3. How to Create a Combination Bar Chart & Candlestick Chart 


May 17, 2021

#MakeoverMonday Week 20 - Humans vs Animals

No comments
Check out this week's #WatchMeViz as I look at what men and women think about fighting an animal unarmed. I iterated through 17 vizzes in 60 minutes that show how to compare two measures.

WatchMeViz



Visualization


April 26, 2021

#MakeoverMonday 2021 Week 17 - Price Parity in America

No comments

In this week's Watch Me Viz, I covered the following charts: 

  1. Line chart
  2. Trellis chart
  3. Slope graph
  4. Connected scatter plot
  5. Bar charts with comparisons
  6. Diverging bar charts
  7. Heatmap
  8. Hex map
  9. Tile map
  10. Barbell chart
  11. Peas in a pod chart
  12. Bump Chart
  13. Comet chart

In the end, I settled on the bump chart using highlighting and BANs. Other topics covered include:

  1. Sorting calculations
  2. Level of detail expressions
  3. Rank table calculations
  4. Parameters
  5. Filter actions
  6. Padding in dashboards
  7. Cleaning tooltips
  8. Divider lines in dashboards

View the final dashboard here.


March 9, 2021

How to Create a Control Chart

No comments
Control charts are used to monitor the stability and control of measurements over a period of time. There are four elements to make an effective control chart. 

  1.  A control chart is a time series graph.
  2. A line across the time series that represents the mean of all of the measurements in the graph. 
  3. Upper and lower control limits (UCL and LCL) that are displayed as a reference band across the view at a specified number of standard deviations from the mean. 
  4. Indicators to show which measurements are "out of control". 

Typically, any measurements that are more than three standard deviations from the mean are considered unlikely and therefore outside the control limits. However, it is also common to consider measurements that are more than 1 or 2 standard deviations from the mean as a form of analysis. 

In this video, I show you how to create a control chart that allows the user to specify the number of standard deviations at which to plot the upper and lower control limits.

March 2, 2021

Mastering Containers in Tableau

No comments

The Workout Wednesday 2020 Week 53 challenge required extensive knowledge of containers in Tableau. Containers can be quite the mystery! It's taken me years to grasp them.


In this webinar, I showed what I've learned about containers, how to complete the Workout Wednesday challenge, and how you can master containers.

Resources:

  1. Workout Wednesday Challenge - http://www.workout-wednesday.com/2020w53/
  2. Data source (Superstore 2020.3) - https://data.world/vizwiz/superstore-20203
  3. Workbook - http://bit.ly/WOW2020WEEK53

October 26, 2020

#MakeoverMonday 2020 Week 43 - #WatchMeViz - Apparel Exports to the U.S.

No comments

For #MakeoverMonday week 43 we analyzed data about apparel exports to the US during the Coronavirus pandemic. In this session of #WatchMeViz, I showed 28 different ways to visualize time series data (there are way more) before we all settled on a viz that's basically the same as the original and looks nicer.

Subscribe to my YouTube channel here to get all of my latest Tableau Tips and notifications for upcoming live streams.

Show Notes / References:

  1. Data Set - https://data.world/makeovermonday/2020w43-apparel-exports-to-us
  2. Tableau Reference Guide (incredible repository of thousands of Tableau tips) by Jeffrey Shaffer - http://www.tableaureferenceguide.com/
  3. How to Shade Between Two Lines with Polygons by Rody Zakovich - http://www.datatableauandme.com/2017/08/how-to-shade-between-2-lines-in-tableau.html
  4. Title Capitalization - https://capitalizemytitle.com/ 




June 13, 2013

How many ways can Facebook Dublin team visualize simple data?

2 comments

After an incredible Tableau conference in London, I headed to Dublin for two more days of data viz and Tableau training.  Today’s class was about brain games and data visualization, my favorite class to teach.

I end the class with a simple exercise that I want to share.

image

I don’t remember where I found this idea on the web, but credit to whoever came up with the idea.  (UPDATE 14-Jun: Thank you to readers Michael Cristiani and Joey for reminding me that it came from this post from Santiago Ortiz on the visual.ly blog!)

It always amazes me how many different ideas people come up with.  The purpose isn’t necessarily to get them to only use what they’ve learned; it’s more of a way for them to be creative and have some fun.  Inevitably several people create pie charts, the only reason being that they know I hate them.

IMG_2070

There were about 25 people in the class and they came up with 73 ideas in about 10 minutes.  Pretty good ROI!