VizWiz

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

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 19, 2023

Mastering 4-Level Map Drill Downs in Tableau

No comments

If you've enjoyed my previous tutorials on 2-level and 3-level drill downs in Tableau, prepare to take your skills to the next level. 

I've got something unique for you: a step-by-step guide on creating a 4-Level Map Drill Down in Tableau!

What You'll Learn:

- How to drill down from a region to a state

- How to further drill down from a state to a county

- Finally, how to drill down from a county to a city

Prerequisites:

This is an advanced tutorial. Make sure you're comfortable with Tableau basics and have seen my 2-level and 3-level drill down videos.

Previous Videos:

2-Level Drill Down Tutorial

- https://www.vizwiz.com/2022/08/two-level-drill-down.html

- https://www.vizwiz.com/2023/06/map-drill-down.html

3-Level Drill Down Tutorial

- https://www.vizwiz.com/2023/08/dzv-drilldown.html

Links & Resources:

Workbook - https://public.tableau.com/app/profile/andy.kriebel/viz/4-LevelMapDrilldown/MapDrilldown 


July 11, 2023

Mastering Tableau: The Power of Context Filters

No comments

What are Context Filters?

A context filter in Tableau is a powerful feature that allows you to isolate a specific subset of data and create a temporary data subset 

When you apply a context filter to your visualization, Tableau first applies the context filter and then performs calculations and aggregations based on the filtered subset of data.

How do they work?

By creating a context, you can optimize the performance of your visualizations by reducing the amount of data being processed.

When a context filter is applied, Tableau performs the following steps:

  1. Identifies the data that meets the context filter criteria.
  2. Performs calculations and aggregations based on the filtered data.
  3. Evaluates any other filters and calculations based on the context data subset.

A context filter allows you to control the order in which Tableau applies filters and calculations.

Tutorial

In this video, I'll explain:

  1. The difference between regular filters and context filters
  2. How context filters can significantly improve Tableau performance

I'll finish up by showing you a couple of the most common use cases for Context filters to drive the concept home.

Newsletter

Sign up for my newsletter. Every week I provide advice, tips, live stream videos, discounts on products I create, and much more.

Launch, grow, and unlock your career in data at andykriebel.com.

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/


August 19, 2021

#MakeoverMonday 2021 Week 33 - UCAS Daily Placements

No comments
UCAS is a service that helps people find open placements universities in the UK (and hopefully place them). I found this particular data set quite confusing until I looked at this viz from UCAS. I then understood that we were basically looking at the number of applications from UCAS based on the time that has elapsed since exam results days. That probably took me a couple hours to wrap my head around.

I decided to create an exploratory dashboard, focusing on the number of applicants that were placed for women vs. men. Women use UCAS's services way more than men do.

June 14, 2021

#MakeoverMonday 2021 Week 24: Which States Have the Highest Average Student Loans?

No comments
If you watch this week's #WatchMeViz (below), you'll get a good look at how I use containers to create a dashboard. I didn't iterate very much this week, as far as the number of charts is concerned, but I did mess around way too long when trying to create a hex inside of a hex map. HINT: It turned out terrible.

Resources:
  1. Final workbook
  2. U.S. Hexmap Shapefile (credit: Joshua Milligan)


March 16, 2021

Mastering Containers in Tableau (Part 2) - Sales Performance Dashboard

No comments
Containers...you either love them or hate them. And I want you to learn to love them. 

In part one of this series, I showed you how to build a simple KPI dashboard with three cards. In the video below, I show you how to build a more complex dashboard that requires 7 containers:

Click for the interactive version

This video shows you how to organize the containers, how to use padding, and how to build an engaging dashboard for your stakeholders. Enjoy the video!