Introduction One of my favorite challenges from the past is from Week 4 2020: Can you combine relative and custom dates? I was always fielding questions if I could have a relative date filter and a date picker on the same dashboard, but hadn’t ever figured it out. After Sean’s challenge that week, I implemented …
#WOW2023 Week 18: Can you combine relative and custom date filters? Read More
Introduction A few weeks ago I saw this Twitter poll (and the ensuing discussion) about Team Tiled vs Team Floating and I noted that I am neither. Rather, I am Team Container. Using Containers in dashboards makes positioning and sizing everything in your dashboard a piece of cake, once you have mastered how they work. …
#WOW2023 | Week 12 | Can you build a dashboard using containers? Read More
Introduction As Donna mentioned last week, this month we’re focusing on alternative chart types. This jitterplot is a fun one inspired by one of Steve Wexler‘s charts in The Big Book of Dashboards. I like jitterplots because they allow you to easily see how an individual compares to the rest of the group via distribution, …
#WOW2023 | Week 6 | Can you create a normalized jitterplot? Read More
Introduction What a year 2022 has been! For the last challenge of 2022 we’ll build some waffle charts showing % of sales by segment. Even though I knew the general principle of waffle charts, it was some good practice for me making this one. Hopefully it’ll be some helpful practice for you all as well. …
#WOW2022 | Week 52 | Can you create a waffle chart? Read More
Introduction Small multiples can be a good way to see overall trends across several categories, but sometimes it can be tricky to get the sorting and labels right, so that’s what we’ll practice this week! Since baseball season is over now, we’ll look at overall win percentage from 1998 to 2022 for Major League Baseball …
#WOW2022 | Week 47 | Can you label and sort small multiples? Read More
Introduction Hello there, Workout Wednesday #DataFam! This week’s challenge is all about two of my passions growing up: baseball and physics. This past baseball season, New York Yankees outfielder Aaron Judge broke the 61 year old American League record for home runs in a single season set by Roger Maris in 1961 – Judge concluded …
#WOW2022 | Week 42 | Can you use Tableau to estimate Aaron Judge’s home run trajectories? Read More
Introduction This week’s challenge is focused on Level of Detail (LOD) calculations. We could probably build this chart using Table Calculations, but we’re not going to. Deliberate practice with some basic LODs. This also can be the basis for some cohort analysis, aligning various groups from different time periods on the same starting point. And …
#WOW2022 Week 37: Can you create a common starting point? Read More
Introduction About three years ago, I was participating in our weekly Makeover Monday group at work, and happened to immediately know what I wanted to build and got it done in about 40 minutes. A colleague also completed theirs in that time, and so we then shared what we had built with the rest of …
Introduction This week’s challenge is inspired by one of the dashboards in The Big Book of Dashboards, by Steve Wexler, Jeffrey Shaffer, and Andy Cotgreave. If you’re not familiar with it, the BBOD is a tremendous resource of tools and concepts you can apply to real world business scenarios, and you can learn more at …
Introduction This week’s challenge was inspired by one of the charts Ann Jackson used in her Advanced Speed Tips session with Lorna Brown. If you had a chance to watch live or virtually, you know it was an awesome session with some great tips and techniques (so if you haven’t seen it yet, you should …
