Today I've been teaching DS23 a bit of PBI. We teach PBI as more of awareness than expertise. I need them to understand how it work in the event it comes up while on their placements. After creating some charts with Superstore and showing them how easy it is to download data from the web, I gave them (and myself) the task of completing Workout Wednesday 2020 Week 53. We had established the basics of building the charts so it was pretty simple, notwithstanding the inevitable formatting time (this is a lot of work in Tableau too). 

The requirements for week 15 are here. This is another super useful challenge as it helps you develop a dashboard you could easily use in your own organization.

My go-to blog post for working with and formatting time is this one from Jonathan Drummey. I'd say it's critical for solving this challenge. Also, think about the calcs for the reference lines and the BANs. As a hint, they're not just simple reference lines based on the measure on the rows. You WILL need to calculate the overall average separately.

Click on the image to interact with the dashboard and/or download the workbook here.