Data Viz Done Right

October 20, 2020

#TableauTipTuesday: Four Methods for Creating Dots on a Map

No comments

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

October 13, 2020

#WorkoutWednesday 2020 Week 42: Can you build a Strava Workout Calendar?

No comments


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. 


  • 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 


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! 


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


October 6, 2020

#TableauTipTuesday: How to Format Numbers as Trillions

No comments

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!

October 1, 2020

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

No comments

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.