VizWiz

Launch, grow, and unlock your career in data
Showing posts with label charts. 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.

April 25, 2024

The ULTIMATE Guide to Custom Visualizations in Tableau

No comments

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

No comments
Understanding best practices when designing dashboards is critical for ensuring they are used, useful, and help drive the business forward.

March 27, 2024

8 Reasons Power BI isn't "FREE"

No comments
Too many IT leaders are ignorant. They are blinded by the allure of Power BI being "free". It's not.
Why I don't use Power BI by Andy Kriebel

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)


September 12, 2023

#MakeoverMonday Week 37 - First time home buyers in the UK are being shut out of the market

No comments
Have you ever heard of the "sunken cost fallacy"? If you haven't, it is where you continue a task based on previously invested resources, such as time, despite new evidence suggesting that the cost, beginning immediately, outweighs the expected benefit.

This is what nearly happened to me during Watch Me Viz. I was convinced I had created the perfect chart. That is, until comments started coming in to the contrary. I had gotten so fixated on this one chart that I thought all other ideas were inferior.

I snapped out of it eventually and turned my attention to another chart that told the story much better.

The lesson learned: be careful of, and attuned to, sunken cost.

With that, here's Watch Me Viz for you to follow along and learn lots about Tableau.


June 12, 2023

#MakeoverMonday 2023 Week 24 - Cereal and the Green Revolution: Yields vs. Land Use

No comments

At the global level, how has crop production changed over the last fifty years? 

In this Watch Me Viz live stream, I analyzed how the yield and land use of producing cereal has changed over the last 50 years.

I really liked the original visualization, so I rebuilt it in Tableau. I learned how to use dynamic zone visibility, layout containers, and more. Check it out.



Resources:

1. Data - https://data.world/makeovermonday/2023w24

2. Final Dashboard - https://tabsoft.co/3P3Sdl3


===============

Watch Me Viz is a weekly live stream where I help people become better at #Tableau, #PowerBI and data analysis. I show how I take an existing visualization, critique it, analyze the data, and build several visualizations all the while looking for a "better" visualization than the original.

If you are considering participating in Makeover Monday, you can get started by downloading data sets from the Makeover Monday website. I promise you'll become better at data analysis and data visualization by practicing every week.

Data sets - https://www.makeovermonday.co.uk/data/

===============

LEARN FROM ME

Join my newsletter. Sign up at andykriebel.com


ARE YOU INTERVIEWING FOR A NEW JOB?

Contact me for more information about how I can help you prepare for that big interview.

coaching@makeovermonday.co.uk

===============

CONNECT WITH ME

https://linktr.ee/andykriebel

More Watch Me Viz - https://bit.ly/WatchMeViz2023

June 6, 2023

Mastering TABLEAU Dashboards from Scratch

No comments

This comprehensive video will help you create business dashboards that are more actionable and meaningful and that your users will find easy to use at first glance. You’ll be on your way to being a dashboarding expert!

You’ll learn:

  1. Building basic charts
  2. Formatting fundamentals
  3. Using layout containers
  4. Dashboard formatting
  5. Essential tips for padding
  6. Filter controls

We'll create an interactive sales dashboard for Adidas in Tableau that's going to dynamically update based on the filters on the side of the dashboard which will allow us to select specific years, regions, products, and more. 

⏬ DOWNLOAD my preferences file, the data, and starter and solution workbooks for £2 (this covers the costs of making this and future videos):
https://andykriebel.gumroad.com/l/adidassalesdashboard

Sign up for my newsletter to get advance, exclusive viewing of all of my videos, tips for using Tableau, plus exclusive discounts on products that I create.
https://andykriebel.com/


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.

April 21, 2022

#B2VB - 2022/W4 - Design Some KPIs

No comments

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 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