Are you looking to take your Tableau skills to the next level? Do you want to create dashboards that offer a dynamic and interactive experience? 

Look no further! 

This comprehensive tutorial will walk you through the process of creating a Year→Quarter→Month→Day Drilldown in Tableau.

🔹 What You'll Learn:

1. How to set up 2 parameters for drilldown functionality

2. How to perform 9 simple calculations that power your dashboard

3. How to implement 8 simple dashboard actions for enhanced interactivity

4. Introduction to dynamic zone visibility

🔹 Who Should Watch:

1. Data analysts looking to expand their Tableau toolkit

2. Business intelligence professionals aiming for dynamic reporting

3. Anyone who wants to unlock the full potential of Tableau

🔹 Why This Tutorial is Unique:

1. Step-by-step guide for each component: Parameters, Calculations, and Dashboard Actions

2. Introduction to advanced Tableau functionalities like dynamic zone visibility

3. Reusable examples to cement your understanding

4. Tips and tricks for maximizing the utility of your drilldowns

Don't miss out on upgrading your Tableau skills. 

Let's dive into the world of advanced Tableau functionalities and take your dashboards to the next level! 

Welcome to this comprehensive tutorial on creating a Yearly to Monthly Calendar Drill Down using Dynamic Zone Visibility in Tableau.

📌 What You Will Learn

🔑 Key Takeaways

🔗 Additional Resources

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.

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

This week we explored the cost of 20g of protein in various foods. During Watch Me Viz, I showed how to create toggles to allow the user to filter by vegan and vegetarian foods. I did this with parameter actions; if you want to learn more, watch the video below.

In the end, though, my fancy filtering with parameter actions didn't quite work out. I hadn't account for the option when the user might want to look at all foods. So I ended up using basic filtering. I overcooked the whole process, but I bet you'll learn something anyway.

I then went through the entire dashboard design process using containers, padding, shading and more. Check that out if you're interested in learning how to use layout contains.

Here's the #WatchMeViz recording, followed by the interactive viz. Enjoy and thanks for watching!

Starburst charts, sometimes called sunburst charts or circular timelines, are one method of displaying data over time. They may look cool, but they aren't exactly easy to understand. If you are going to use them, I'd advise you to check with your audience first to ensure they understand how to read them.

In this video, I take you through how to build a single starburst as well as a series of starburst charts as small multiples or trellis chart.

All of the calculations are in the description for the video here. You can download the workbook below. 

Makeover Monday is back! Every Monday I'll be running a #WatchMeViz and every Wednesday, Eva will be running #VizReview. Subscribe to my YouTube channel for reminders of the latest events.

https://youtube.com/andykriebel

This week was a makeover of a visualization by Visual Capitalist about the top 10 military spenders. During Watch Me Viz, I iterated through 15 different charts before settling on a bump chart. If you want to learn about sets, parameters, table calculations, containers and more, watch the video below.

Below the video you can see my viz, or click here. Enjoy! If you need clarifications on anything, please comment on the video here.

There are tons of ways to create a single level drill down, but if you’re having issues creating a second drill down, this video is a guaranteed way to help you fix this problem.

Additional video - Single Level Drill Down 

In this tip, I show you how to create a hexbin map in Tableau. But first, let me explain the purpose, benefits and drawback of a hexbin map.

There are countless times when I have been asked to display way too much data on a map. Sometimes I’ve been asked to display thousands of points on a map..but why? I know no one will understand it. 

A hexbin map uses hexagons to divide an area into multiple parts and assign a color gradient to each hexagon. This chart type is used to visualize density, where the hexagons dividing the whole space into discrete units of equal size. 

This video is going to help you communicate the concentration of data on maps more effectively and give you another option for visualizing geospatial data. I’ll show you how to create a hexbin map based on both the value and the rank, giving you two options depending on your use case.

If you want to follow along, these are the data sources I used:

1. Austin Bike Accidents - https://bit.ly/AustinBikeAccidents

2. Austin Zip Codes Shapefile - https://bit.ly/AustinZipCodes

3. Price Summary - https://bit.ly/PriceSummary