Workout Wednesday

2022 Week 31 | Power BI: Connected Scatter with PlotlyJS

Introduction This week for Workout Wednesday we are getting familiar with the PlotlyJS visual by creating traces and annotations for a connected scatterplot.   Connected scatterplots are a cross between a scatterplot and a lineplot whereby two numeric variables are connected by a third ordered variable (often time).   The below graph created with the …

2022 Week 31 | Power BI: Connected Scatter with PlotlyJS Read More

#WOW2022 | Week 30 | Dynamic Dates in a Heatmap

Introduction I’ve been wanting to create this challenge for some time, so I’m really glad to finally be releasing it. This challenge was inspired by some work I did last year where a client wanted to be able to visualize the number of hours that their team had spent working on different projects. What made …

#WOW2022 | Week 30 | Dynamic Dates in a Heatmap Read More

2022 – Week 29: What is the Time-Weighted Return?

Introduction Working with financial data is hard. There are some calculations that make for long evenings to get right. One of those calculations is Time-Weighted Return. This challenge is simple: calculate the Time-Weighted Return Rate for a simple data source and return a line chart. Click to open in Tableau Public Requirements Dashboard Size: 400px …

2022 – Week 29: What is the Time-Weighted Return? Read More

#WOW2022 W28: Can you build a butterfly chart?

Introduction This week my challenge comes from two places of inspiration. Firstly the ONS website and secondly a final interview for someone applying to the Data School. I loved the concept of the chart and it helps with context and also synchronisation of axis. Have fun. Click to open in Tableau Public Requirements Dashboard Size: 800 …

#WOW2022 W28: Can you build a butterfly chart? Read More

2022 Week 28 | Power BI: Error Bars

Introduction Welcome back to Workout Wednesday! If you’re joining us for the first time, welcome! We present you with a challenge, a dataset to recreate the challenge, and a solution video or file. You can use these challenges to build your skills and your portfolio! This week we’re exploring the error bars feature in Power …

2022 Week 28 | Power BI: Error Bars Read More

#WOW2022 Week 27: Can you make a bullet chart?

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 …

#WOW2022 Week 27: Can you make a bullet chart? Read More

2022 Week 27 | Power BI: Navigating Hierarchies

Introduction If you weren’t aware, June was Music Month and Kerry Kolosko gave us a brilliant visualization of Beatles tunes using Charticulator – you can check out the challenge here.    This week we are going to be recreating a recent Tableau challenge from Sean Miller that was featured in Week 11 of this year’s Tableau …

2022 Week 27 | Power BI: Navigating Hierarchies Read More

#WOW2022 | 26 | Let’s make a dynamic relative filter

Introduction Welcome to week 26 – the halfway mark of 2022! This week is pretty straightforward; how simple it will be is up to you 😀 I’ve always really liked using the relative date filter in Tableau but one thing that’s always irked me is that the anchor date is not dynamic – neither end-user …

#WOW2022 | 26 | Let’s make a dynamic relative filter Read More

Scroll to Top