September 19, 2023
Mastering 4-Level Map Drill Downs in Tableau
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
September 12, 2023
How to Calculate Weekday-Only Sales in Tableau
Have you ever wondered how to compare sales performance between two sets of weekdays?
In this video, I'll show you how to calculate and compare sales for the last 10 weekdays against the prior 10 weekdays—all while excluding weekends.
What You Will Learn:
- Setting up your data source for comparison
- Creating calculated fields for two sets of weekdays
- Configuring table calculations to get only the days you need
- Filtering out weekends from both data sets
- Implementing advanced date functions for comparison
- Visualizing and comparing sales for both sets of weekdays
Background Context:
Tableau enables you to conduct intricate data analyses, but comparing specific sets of weekdays can be tricky. This tutorial simplifies that process, focusing on comparing the last 10 weekdays' sales with the 10 weekdays preceding them.
Assumptions:
- You have a foundational knowledge of Tableau.
- Your sales data contains date information.
- You've previously worked with calculated fields in Tableau.
Related Videos:
Resources:
- Workbook & data: Link
#MakeoverMonday Week 37 - First time home buyers in the UK are being shut out of the market
September 5, 2023
60 Unique Ways to Visualize Time in Tableau
September 4, 2023
28 Charts in 60 Minutes - Forbes Cloud 100: Companies Scaling Up and Scaling Down
How many people power the Forbes Cloud 100? Is there a correlation between company rank and employee size? Have they expanded or contracted.
Learn how to build 28 charts in 60 minutes that compare two years.
August 29, 2023
How to Compare YTD, QTD, MTD, WTD & Daily Sales in Tableau
August 23, 2023
#MakeoverMonday Week 34 - Go-To Drinks for Men and Women on Dates
Join me for live analysis of Zoosk's recent survey, covering 8,793 members' dating drink preferences!
In this livestream, I'll break down the responses across 7 different drink types, comparing the preferences between men and women.
Is there a gender divide when it comes to what people choose to drink on dates?
I'll explore this question and more.
August 22, 2023
From Boring PowerPoint to Dynamic Tableau with Microsoft Web Viewer
August 15, 2023
An 8-Chart Guide to Dashed Lines in Tableau
In this tip learn when to use of dashed lines. Through this video, I'll walk you through 8 distinct examples, demonstrating the effectiveness and clarity that dashed lines can bring to your data representation:
- Line Chart with Dashed Elements: Understand the basics of creating dashed lines.
- Multiple Lines Differentiation: Explore how to distinguish multiple measures using varied dashed patterns.
- Line/Area Chart Combination: Integrate dashed lines with filled areas.
- Comparison to a Moving Average: Learn how dashed lines can contrast raw data against its moving average, helping in trend analysis.
- Current Year vs. Prior Year: Used dashed lines to make year-on-year comparisons.
- Combination Chart: Combine several chart types, using dashes to maintain clarity.
- Barbell Chart Analysis: Learn how dashes can link data points in a barbell chart, highlighting change and consistency.
- Forecast vs. Actuals: Create a forecast with dashed lines.
August 8, 2023
How to Master the 3-Level Drill Down in Tableau (with Dynamic Zone Visibility)
Welcome to my guide on mastering the 3-Level Drill Down in Tableau!
In this tutorial, I show you step-by-step how to make the most of using dynamic zone visibility to create this functionality. We'll go through both scatter plot drill downs from Region → State → Postal code and then replicate that as a bar chart.
You can easily make this a map drill down by changing the chart type. That's it!
🔍 What you'll learn in this video:
1. The basics of drill down functionality in Tableau
2. Hands-on demonstrations, tips, and best practices
3. How to interact with the data
💡 Why is this important?
Drill down capabilities allow analysts to explore data from a broad overview down to granular details. By mastering the 3-level drill down, you can uncover hidden patterns, insights, and trends that might be overlooked in higher-level analyses.
📌 Prerequisites:
A basic understanding of Tableau's interface and primary functions will be helpful, but beginners will be able to follow along as well!
If you are following along, be sure to pause the video along the way as you repeat the steps.
August 7, 2023
August 1, 2023
How to Use ANY Tableau Public Dashboard as a Template for FREE!
Have you ever spotted a great dashboard on Tableau Public and wished you could repurpose it for your own data?
Look no further! 🌟
In this video, I'll guide you through the easy steps of using dashboards on Tableau Public as templates.
From downloading the workbook to swapping out the data and troubleshooting errors, learn how to quickly create dashboards in minutes.
Note: Ensure that you're respectful of original creators' work and provide appropriate credits or mentions when using their dashboards.
Get the data and python code to create your own mock data here - Link
Priya Padham's dashboard - Link | My dashboard - Link
July 31, 2023
#MakeoverMonday 2023 Week 30 - Drinking Fountains in Milan
You'll learn about:
- Joining spatial data sources
- Parameters
- Hexbin maps
- Custom shapes
- Using mapbox maps
- Dashboard layout containers
- Dynamic Zone Visibility
- Parameter Actions
- Custom colors
- Drill down / drill up actions
Enjoy the video and check out the viz below.
July 25, 2023
The Big Thaw: Exploring the Disappearing Antarctic Sea Ice
- Visualizations from chapter 12 of the Makeover Monday book that showed how to add context to visualizations
- Several of the vizzes from 2018 week 15, each with their own unique take on the data
- The original viz by The Guardian
18 Ways to Create Bar Charts in Tableau
In this comprehensive Tableau tutorial, I will explore 18 different ways to create bar charts using Tableau. This video is inspired by Rosa Mariana de Leon-Escribano, my colleague at The Information Lab France.
In this tutorial, I will use various techniques to build bar charts that will help you visualize your data effectively. Whether you are a beginner or an advanced Tableau user, this video is designed to cater to all skill levels.
Throughout the video, I will guide you step-by-step, demonstrating each method so that you can follow along. I will help you understand when to use each type based on your data requirements.
By the end of this tutorial, you will have a solid foundation in creating bar charts in Tableau and be equipped with the knowledge to choose the appropriate bar chart type for your data analysis needs.
Rosa's bar chart catalog - Link | My bar chart catalog - Link
July 18, 2023
UNLIMITED Charts, Metrics, and Number Formats in Tableau with Dynamic Zone Visibility
July 11, 2023
Mastering Tableau: The Power of Context Filters
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:
- Identifies the data that meets the context filter criteria.
- Performs calculations and aggregations based on the filtered data.
- 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:
- The difference between regular filters and context filters
- 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.
#MakeoverMonday 2023 Week 28 - Global Passport Rankings
- Grouped bar chart
- Bar in bar chart
- Grouped bar chart with a gantt bar for the difference
- Diverging bar chart
- Histogram
- Butterfly chart
- Barbell chart
- Scatter plot
- Slope graph
- Trellis chart
- Jittered bar chart
July 4, 2023
Create 10 ACTIONABLE & IMPACTFUL KPIs in Tableau
What is a KPI?
KPIs are measurable values that indicate how well a business is performing in achieving its key objectives and goals. They provide a clear and concise snapshot of critical areas within a business.
KPIs help to:
Monitor progress
Identify areas of improvement
Make data-driven decisions
In order to do this, KPIs must be tailored to specific goals and strategies.
Making KPIs Actionable
Here are 8 suggestions to ensure that KPIs are actionable and impactful.
Align with business objectives
Focus on relevance and simplicity
Set measurable targets
Collect accurate and timely data
Visualize your KPIs
Regularly review and update
Add context
Drill down
Actionable KPIs are vital for measuring performance and achieving results. You can drive your business forward by aligning data with goals and simplifying and visualizing KPIs effectively
Read more about KPIs in my newsletter here. Sign up so you don't miss any future newsletters at andykriebel.com.
⏬ DOWNLOAD the data, and starter and solution workbooks here. I would appreciate your support to continue making videos for you.
June 27, 2023
Blue vs. Green - What does it mean?
When I first started using #Tableau, I assumed that blue meant dimensions and green meant measures. They don’t.
Blue means Discrete
Green means Continuous
It took me a couple of years to get my head around this most foundational concept in Tableau.
Dimensions and measures are merely a way that Tableau organizes the data.
And if you only take away one thing from this video, this is it:
- Blue things GROUP your data
- Green things COUNT your data
- Dimensions SPLIT up the view
- Measures FILL the view