Introduction This week is my last week as a full time Workout Wednesday coach! As such it’s only fitting and appropriate that my last challenge echo and be a retake or redux of my initial challenge – the frequency matrix. Over the past (nearly) 4 years, I’ve shared 52 challenges (meaning you can have a …
We’ve covered a TON of different types of table calculations but one thing we’ve not challenged you to do is filter table calculations while keeping the context in view. Can you complete the challenge?
Introduction Today I’m excited to share a challenge in collaboration with Dr. Eric Eager at PFF. PFF analyzes data about professional football (in this case the American version). In this game, there are many players, but the most critical player supports a role called the Quarterback. In this challenge you’ll count the number of consecutive …
Introduction After the results of the community survey, the top ranked feature was Table Calculations, so guess what? Let’s do some Table Calculations! Click to open in Tableau Public Requirements Dashboard 600 x 600 ONE SHEET Table Calcs ONLY! Create a parameter controlled moving average by month for sales. Create a way to multi-select subcategories …
I love puzzles, it’s the reason I love #WorkoutWednesday and have since it began in 2017. This week we’re tackling a recent puzzle I was confronted with. Let’s count the number of consecutive weeks with more sales than the week before. Can you solve it?
Introduction Like a fine pinot grigio, I really enjoy a good box-and-whisker plot. There is so much good stat stuff in one place like the min/max, median, top/bottom performers, and outliers in the data set. I have found, however, that they are rarely used and some business end users find them hard to read. …
2021 Week 27: Can you find the top and bottom performers? Read More »
Introduction This week we are going to do two things: look at alternative for the most common scatterplot I see in Tableau. use a very uncommon unsynchronized dual axis chart. First, the chart I always run into is this scatterplot of total sales and total profit by order. While we can see which orders were …
2021 Week 26 – Tableau: Profitability with Dual Axis Charts Read More »
Introduction I came across an interesting challenge. When comparing data, Tableau automatically compares to the same date on the prior month/year etc. But what if you want to compare to the same DAY. For example, Tuesday 18th May 2021, would compare to Tuesday 19th May 2020 for the previous year, and Tuesday 20th April for …
2021 Week 20 | Tableau: Can you compare Same Day to a Selected Date? Read More »
Introduction Is it too late now to start the post with Happy New Year? Well it’s my first Workout of the year so Happy New Year everyone, it’s really great to be back for my third year! After completing the first two workouts from this year (because I suck at Table Calculations), I wanted to …
2021 Week 3 | Tableau : Can you build a Control Chart Read More »
Introduction This year we’ve made a commitment to start with the basics and build, so this challenge is designed to do just that. This week, you’ll be constructing a Customer Lifetime Value Matrix (CLTV). This viz is frequently used in marketing and retail industries to understand the value of each customer. Specifically, the interesting insights …
2021 Week 2 | Tableau : Can you build a Customer Lifetime Value Matrix? Read More »
