We received a reprieve from advanced challenges with Week 14. It was a good practice challenge to reinforce some fundamental best practices with prepping data.

This challenge required some pivots and unpivots. These are more expensive processes, so remember: Filter early! Filtering early limits the impact of these processes because it ensures that you are only pivotting what you need to.

Here is my walkthrough of the challenge on Youtube: