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 …
Introduction This week’s challenge is inspired by a Makeover Monday I did a couple years ago, which was inspired by Lindsey Poulter‘s Set Actions workbook. But rather than use the same soccer data, I’m continuing to celebrate the start of baseball season by comparing two Major League Baseball greats. The overall challenge here is to …
Introduction Last week a colleague reached out for help creating a boxplot to look at age distribution for different subscription methods, and my first thought was, “I know how to do that, but I don’t remember how to do that.” So I went back to find one I had made previously, and we were able to …
Introduction This week is our third installment of this month’s “dashboard series” so we’ll be building upon Erica’s challenge from Week 5 and Sean’s challenge from Week 6. If you’ve done Week 6, you can start from that, or you can check out those challenges linked above and come back to this when you’re done…or …
Introduction I’m excited to join the Workout Wednesday coaching team this year! For my first challenge, I’m pulling from some recent work experience. Our leadership team wanted to see weekly performance for the week ending Sunday, with the current and prior 2 years in the chart. We also needed to include the YoY% change, and …
WOW2022 Week 2: Can you build a weekly Year-over-Year line chart? Read More
