## VizWiz

Launch, grow, and unlock your career in data

## How to Create Time Series Tile Grid Maps

Unlike traditional maps, tile grid maps allow you to allocate equal space to each geographical area. We've probably all seen hex maps of the United States. Tile Grid Maps are similar, except they are squares with each block being the same shape and size.

In this video, I show you first how to create the tile grid map, then how to overlay time series data. I then show you three different visualization types for the time series. You could easily create bar charts as well.

Enjoy!

## How to Create a Venn Diagram

Venn diagrams (also called Set diagrams or Logic diagrams) use overlapping circles to illustrate the logical relationships between two or more sets of items. They depict how things relate to each other within a particular segment.

For example, how many customers made purchases in the East region, in the West region, and in both regions?

Where the circles overlap, you display text or a value the represents the value associated with the relationship.

I created a Venn diagram for my Visual Vocabulary and while teaching how to create it, I thought of a much simpler way to create them. All of the versions you see online (and the version in the Visual Vocabulary) require you to:

1. Create sets
2. Evaluate how many things are in each set as an aggregate
3. Align the circles according to these values
4. Create a calc to display the text for the overlap with a computed set

In this video, I show you how to create a Venn diagram with one simple calculation for the placement of the circles (a continuous dimension), a dummy field for the middle text, and one LOD to count the things that overlap.

No sets required! It's super simple, I promise! I also show you why the LOD calculation works that counts the things in the overlap.

Enjoy!

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

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/

## #TableauTipTuesday: Four Methods for Creating Dots on a Map

People love maps. Putting dots on a map gives a sense of precision. There are lots of methods for displaying maps. In this video, I show you four:

1. The exact locations
2. Density map
3. Using the ROUND function to generalize the points
4. Using the HEXBIN functions to generalize the points, but at a level controllable by the user

## Introduction

When Lorna asked me to be a Community contributor for Workout Wednesday, honestly, I was hesitant since I don’t participate every week. I typically only take on the challenges that I think are most beneficial to me as a teacher. I want to share work that I know the Data Schoolers are likely to use on their placements. Lorna talked me into it (she’s my favorite after all) and I have something pretty straightforward to share with you this week.

I’m a keen triathlete and track all of my activities on Strava. There are some great dashboards and visualizations that help you understand your performance. One of my favorite is the Training Calendar. It gives you an overview of an entire year at once. And that’s what you’ll build for this workout.

## Requirements

• Dashboard size: 1680 x 1020
• Max 3 sheets
• Max 1 text box
• Joins are not permitted
• Data model is not permitted
• They MUST be separate data sources.
• No annotations
• No text boxes on the main chart
• No floating objects
• No Level of Detail expressions
• Remove highlighting from anything you can click
• Match formatting and tooltips
• The blue hex code is #0070A0.
• The blue bars on the upper right are the weekly number of hours spent exercising.
• The black bars in the main chart are the daily hours spent exercising.
• Any days when I did not exercise should have zero hours displayed.
• Allow scrolling through the years

## Dataset

The two files you need can be downloaded here. REMEMBER: No joins or data modeling!

When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration. Also include the hashtag #WOW2020 in your description to make it searchable!

## Share

After you finish your workout, share on Twitter using the hashtag #WOW2020 and tag @VizWizBI, @AnnUJackson, @LukeStanke, and @_L    orna_Brown.

## #TableauTipTuesday: How to Format Numbers as Trillions

During #WatchMeViz this week, I showed how to format numbers as trillions. Trillions isn't an option in Tableau's number formatting. However, you can get around it with a custom format. In this video, I show you how to do that. It's quite simple!

## #WorkoutWednesday 2020 Week 32: COVID-19 New Case Trends

As I continue to catch up on Workout Wednesday challenges I've missed, I'm picking and choosing those that looking interesting at first glance (and that I think are doable in a short amount of time). Week 32 was one I knew I could get done quickly since it was very similar to 2017 week 7. Actually, since the columns and rows were provided to use already via a CASE statement, the trellis part of the exercise required no calculations and no work.

The toughest part was normalizing the calculation within each State. The key here is to think about each State individually, find the highest value, and then compare all of the other dates to that value. I did this by putting each State and date into a row, creating a calculation to get the largest value, then computing the necessary ratio. Once I had that, it was simple to turn it into a chart.

To get the State names in the middle of each chart, think about how you can count half of the day in each chart. Then take that value and add it to the first date and you'll get a single date that's halfway across the date range. This solution will be flexible for any new data that would be included.

Some difference between mine and Luke's

1. I didn't filter the dates; I decided to use the entire data set, but keep in mind that I did this several weeks after Luke posted the challenge.
2. I created a mobile version as well.

And with that, here's my completed #WorkoutWednesday for week 32 2020.