Launch, grow, and unlock your career in data

December 20, 2021

How to Filter by Rank Across Multiple Worksheets

No comments

In this tip, I show you how to use a parameter to filter the rank across multiple worksheets or an entire dashboard.

December 8, 2021

#WOW2021 Week 45: Customer Purchasing Habits (RFM Analysis)

No comments
We were extremely fortunate to have Ann Jackson join us on the weekly Wise Up Wednesday at The Data School. Originally she was going to take us through how she completed week 45. However, I thought it would be interesting for Ann to see how we approach the challenges. Ann pitched in a couple times with some hints to keep us from heading down the wrong path. We were able to build the chart in one sheet, including the headers whereas Ann used a text box for the headers.

Personally, I felt a lot of pressure not to mess up with Ann watching. As Erica Hughes of DS20 pointed out, this is how I make them feel during training. I promise it's done with love! 🙂

Here's the video of our session. We nearly finished in the allocated hour. After we dropped off, I cleaned up the tooltips and put together the dashboard, so that's not included in the video. 

Click on the image below to view the viz on Tableau Public.

December 7, 2021

How to Create a Scatterplot Drill Down with a Parameter Action

No comments

In this example, I show you how to create an interactive scatterplot that allows the user to select a mark in a scatterplot to drill down to the underlying data. This tutorial shows you how to drill down from Sub-Category to Product. This process will work for any two dimensions.

October 14, 2021

How to Embed a Google Slides Presentation in a Tableau Dashboard

No comments

Let's say you are giving a presentation that includes both slides and Tableau dashboards/charts. You'd rather not switch back and forth between applications. You'd prefer to have it all in Tableau.

It's super simple with Google Slides. In this tip, I show you how to embed a Google Slides presentation in a Tableau dashboard.

NOTE: The Google Slides presentation will not render on Tableau Public, but it will work if you download it and open it on your computer. Download the workbook here.

September 29, 2021

#MakeoverMonday 2021 Week 39 - MLB All-Time Offensive Wins Above Replacement

No comments
This is the final installment of Makeover Monday as a community project and I decided to go back to the very first week of Makeover Monday in 2016 to use as our viz to makeover this week. It's looking at a complicated stat in baseball called Wins Above Replacement, which is basically a measure of how good a player is that an average player that would replace him.

There are several, even more confusing stats included. I thought the easiest way to compare them would be with a scatterplot. So I made an interactive scatterplot that highlights players that are above the average of the top 200 players. 

If you watch the Watch Me Viz video (below), you'll see how I used table calcs to highlight those players and also count the number of players in that quadrant. You'll learn how to use parameters to create a dynamic scatterplot, plus some other bits along the way.

Thanks for coming along on this 300 week journey with me. I hope you have developed your skills and become better at your work. Until next time...

September 21, 2021

#MakeoverMonday 2021 Week 38 - What is your personal information worth?

No comments

Short and sweet this week. The data set is about the price of personal information on the dark web. There are three fields: Category, Product, and Price. To me, this looks like Superstore, so that's how I approached it. How can I visualize two fields that have a hierarchy?

In the video, I show you how to create a drill down with both a set action and a parameter action. Here's the video and below is the visualization.

How to Label the Inside and Outside of a Bar Chart

No comments
A bar chart can look really nice with a bit of formatting. In this tip, I show you how to move the header from the dimension to the inside of a bar chart while also having the value on the end of the bar chart.

September 14, 2021

#MakeoverMonday 2021 Week 37 - The World's Largest Solar Power Plants

No comments
I found this week's viz super confusing. I found it hard to track which bar went with which label, how it related to the other parts of the infographic, and ultimately all it required was a simple bar chart.

If you have a look at the video below, you'll see me create a drill down action, using a boolean table calc to color the bars, create a parameter to choose a metric, and lastly I show you how to create different number formats for a single calculation.

September 7, 2021

How to Create a Bar Chart Without an Axis

No comments

Did you know you can create a bar chart without using the rows or columns shelf? Check out this super simple tip to see how it's done.

September 6, 2021

#MakeoverMonday 2021 Week 36 - How Has American Support For Abortion Changed Since 1975?

No comments

Despite the massive setback to women's right in Texas, less Americans are anti-abortion than in 1975. Now maybe if the barbaric dinosaurs in Congress in Texas came into the 21st century, they'd finally realize women are our equals and we shouldn't control them. It's all very, very disgusting. They should be ashamed, but of course they're not. In fact, they are quite proud of what they "achieved".

August 31, 2021

How to Compare to the Average with a Bar Chart

No comments

Context is important in data visualization. For every chart you create, consider asking yourself "compared to what?" 

In this tip, I show you how to add context to a simple bar chart by showing whether a value is above or below the average.

August 30, 2021

#MakeoverMonday 2021 Week 35 - Male Circumcision Around the World

No comments

In this week's Watch Me Viz, I started by showing the original visualization, demonstrated how to make a non-geographical field geographical, and then I spent lots of time working through set action drill down.

I showed how to do drill down to two and three levels of dimensions in a hierarchy. Lastly, while building the dashboard, I also showed how to move fields you select in an action to the top of the view with a sorting calculation.


August 24, 2021

How to Automatically Exclude a Partial Week

No comments
In this video, I show you how to use level of detail expressions to only return sales through the latest completed week. This method will work as weeks complete; you will not need to edit any of the calculations to ensure weeks that close in the future get included in the chart.

#MakeoverMonday 2021 Week 34 - Entry-Level Jobs on LinkedIn Requiring 3+ Years Of Experience

No comments
Eva sent me an interesting, and ironic data set for this week. It's based on a studying done on LinkedIn of jobs that advertise as "entry-level" yet require 3+ years of experience. I'm still having trouble wrapping my head around that.

In this week's Watch Me Viz, I tried something new. I used both Tableau and Power BI. I focused on methods for rebuilding the original chart. Unfortunately, the PBI demo didn't go so well. That wasn't any fault of PBI, but rather my laptop, as I have to run Parallels on my Mac in order to run PBI and I was also live streaming. Either way, I hope you find it useful.

August 19, 2021

#MakeoverMonday 2021 Week 33 - UCAS Daily Placements

No comments
UCAS is a service that helps people find open placements universities in the UK (and hopefully place them). I found this particular data set quite confusing until I looked at this viz from UCAS. I then understood that we were basically looking at the number of applications from UCAS based on the time that has elapsed since exam results days. That probably took me a couple hours to wrap my head around.

I decided to create an exploratory dashboard, focusing on the number of applicants that were placed for women vs. men. Women use UCAS's services way more than men do.

August 9, 2021

#MakeoverMonday 2021 Week 32 - Mortality Rates in England and Wales

No comments

I couldn't find too much to do with this week's data set, so I ended up with some simple BANs and line charts that take the original and reorganize them a bit to make them more clear.


  1. Data set -
  2. Chart Guide -
  3. Final Viz -

August 4, 2021

#MakeoverMonday Week 31 - Bicycle Collisions in London

No comments
This week's data set was pretty straightforward. During #WatchMeViz I iterated through some maps, including joining to spatial files for London, and also lots of time series charts. Below are links to the resources, the video, and the final viz.


July 26, 2021

#MakeoverMonday 2021 Week 30 - America's Racial Breakdown by State

No comments

Makeover Monday week 30 looked at this viz from Visual Capitalist showing the percentage of each race in each State in America.

In the video below, you'll see my recreate the tiled treemap before creating a tiled bar chart. Thanks for watching!

Click here to view the interactive version on Tableau Public.

July 21, 2021

How to Compare to the Prior N Months Using the IN Function

No comments
This tip comes from an exercise I did alongside DS21 to find different ways to compare to the prior 3 months. Owen Barnes came up with the method using the IN function upon which this tip is based.

Check out how we did this same exercise with a table calculation and a level of detail expression on Owen's blog here.

July 19, 2021

#MakeoverMonday 2021 Week 29 - Non-Whites Are At Higher Risk of Dying From COVID-19

No comments

Another COVID-19 data set this week and a great visualization that shows how much more likely ethnic minorities in the UK are to die from COVID.

In the video, I worked through rebuilding the original viz since I liked it so much. Interact with the viz below the video.

July 12, 2021

#MakeoverMonday 2021 Week 28 - COVID Vaccination Rates by Ethnicity and Age in England

No comments
How can ethnic groups be treated differently when it comes to the COVID vaccine? It's terrible! And this data from NHS England clearly demonstrates the racial divisions that exist in this country.

I'm not sure what happened during the recording, but it got split into two parts. Both are below.


Thanks for tuning in! Interact with the viz by clicking on the image below or here.