Launch, grow, and unlock your career in data

September 28, 2020

#MakeoverMonday 2020 Week 39 - Child Marriage Around the World

No comments

Week 39 brought another #Viz5 topic, this time it was about children that are now 20-24 who were married under the age of 18. Child marriage is, of course, horrific and it's a violation of human rights. Unicef has done an excellent job of recapping all of the issues and why these marriages happen on their website here.

As I've mentioned before, I ALWAYS find these Viz5 data sets tought. I'm not sure why; perhaps I have a mental block on them now. This week the data set was three columns: country, female %, and male %. That can't be too tough...right?

Well, I sure made it tough. First, I joined the data to regional mappings from Unicef so that I could possibly look at the data at the regional level; I decided to use medians for each region in the end. Then I went into Tableau and built a bunch of charts to explore the data. I used chart guides to help me think through options and none of them seemed to make any particularly interesting insights pop out.

After about two hours of nothing, I got the idea of simply looking at the % of females that were married under the age of 18. I ended up with a simple bar chart, which turned out to not be too far from the first chart I created a few minutes in.

Here's the #WatchMeViz video and below is the visualization. Thanks to those that watched live and contributed ideas along the way!! It really helps knowing others are there encouraging me.

September 25, 2020

#WorkoutWednesday 2020 Week 3: Orders by Day and Time

No comments

As time permits, I'm going back through some of the Workout Wednesday challenges that I've yet to complete. I'm starting with those that will help me most as a teacher to impart what I learn on those that I have the pleasure to train at The Data School.

For week 3, Lorna Brown challenged us to create a viz that shows the number of orders by hour of the day that allows the user to swap between day of the month and weekday.

In her solution, she chose to create two sheets, one for the day of the month and another for weekdays. I didn't know that when I tackled the challenge so I proceeded down the route of doing it all in one sheet. Success!

I did a couple things differently than Lorna:

  1. I combined the order date and time into a string calculation and then used the DATEPARSE function to make it a date/time field.
  2. The size of my circles depends on the option selected in the parameter. For day of the month, the size is the number of orders. For weekday, I have them set to a fixed size. I chose to make them a fixed size because otherwise the circles become way too big for the view.
  3. I used only one sheet.
  4. I am not showing a tooltip when there are no orders.

My solution is here and below as a gif.

September 22, 2020

#TableauTipTuesday: How to Visualize Survey Data on a Likert Scale and Include a Net Promoter Score

No comments

We've all answered Likert scale questions. These are questions like "How likely are you to recommend our product?" and they are typically on a five point scale (e.g., from not at all to very highly likely).

In this video, I show you how to visualize Likert scale data and how to include a Net Promoter Score (NPS). To get the data that I used, simply download the workbook and unzip it. You will then see a folder named "Data".

Useful links:

1. What is a Likert Scale?

2. What is a Net Promoter Score? 

September 21, 2020

Watch Me Viz - #MakeoverMonday 2020 Week 38 - Pick Up A Book And Read

No comments
This week I went through a TON of iterations before settling on a hex map of Europe. In the video, you'll see me build lots of charts with time series, deviations, etc. before settling on a hexmap of Europe. 

Download the workbook here

Subscribe to my YouTube channel here to get all of the latest content and please share this is if you find it useful. 

Here are a few useful links... 

  1. Geometrics shapes (for the default number formatting) - LINK 
  2. FIXED Level of Detail Expressions in a Plain English Sentence - LINK 
  3. TABLE CALCULATIONS in a Plain English Sentence - LINK 
  4. Shading between two lines - LINK 
  5. Daniel Rowlands - TWITTER 
  6. Daniel Rowlands (EU hex map template) - LINK

Click on the image below the video to interactive with the workbook. Or download it from Tableau Public here.

September 9, 2020

Watch Me Viz - #MakeoverMonday 2020 Week 36 - How Healthy Is Your Favorite Cereal?

No comments
Watch from start to finish as I create my Makeover Monday viz. I'll start by reviewing the original viz (what I like and don't like), getting context from the original article, then create charts and graphs to make a better version than the original.

Click on the image below the video to interactive with the workbook. Or download it from Tableau Public here.

September 8, 2020

#TableauTipTuesday: How to Make a Dashboard Unclickable

No comments

This week is a nice quick tip that I showed a couple years ago at TC during a Tableau Tips battle with Jeff Shaffer. There are times when you want to make sure that your users cannot click on a dashboard. This tip shows you how to make that work.


September 1, 2020

#TableauTipTuesday: How to Find the Highest Selling Item per State with a Table Calculation

No comments
In this video, I show you how to use the RANK table calculation to identify which sub-category has the most sales in each State. While this example answers a question that works best on a map, you can easily apply this technique to any dimension or combination of dimensions for which you need to find the largest.