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.