Introduction Recently, I needed to build a dashboard from some pre-aggregated, segmented data counting unique users. This created some difficulty, because we may want to look at overall numbers, or one segment, or multiple segments, and that changes the user counts. Each of these have their own level of aggregation in the data, so it …
#WOW2023 Week 36: Can you build a dashboard for pre-aggregated metrics? Read More
Introduction We’re continuing retro month this week, and I decided to re-viz Andy’s Week 41 challenge from 2017. I chose this one because I really like the concept of being able to drill down from state into city on the same chart, but I wondered if things would be easier than the calculations required to …
WOW2023 Week 30: Can you build a dynamic drill down scatterplot in one view? Read More
Introduction This week’s challenge is another exploration of dynamic zone visibility, this time combined with a mobile app-like concept. Sometimes executives need just a few critical metrics at their fingertips, and this is a concept I’ve mulled around for a while (probably stemming from this concept by Anya A’Hearn) but felt like dynamic zone visibility …
#WOW2023 Week 24 | Can you build a mobile KPI app? Read More
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
