2021 Week 49 | Tableau: Frequency Matrix Redux

This week is my last week as a full time Workout Wednesday coach!  As such it’s only fitting and appropriate that my last challenge echo and be a retake or redux of my initial challenge – the frequency matrix.

Over the past (nearly) 4 years, I’ve shared 52 challenges (meaning you can have a whole year of just Ann Jackson) with the Tableau community.  It’s been an absolute pleasure to construct these challenges and share my work with you.  I have and always will consider Workout Wednesday the best free resource to see how people solve problems in Tableau Desktop.

I’ll be honest: for this last challenge I struggled with what would be the end of an era.  After soliciting feedback from the community and a chatting with the new 2022 coaches (which you’ll find out about soon enough), I finally landed on reworking my very first challenge, the frequency matrix.

I wanted to keep it similar to the original, but update it to be more streamlined with new Desktop features and a clearer representation of the data.

• Dashboard Size: 1100px by 900 px
• # of Sheets – 1
• Create a frequency matrix that colors and shows the number of orders associated with the cross-section of subcategories
• Use Color Brewer Blue Purple (google Tableau color palettes)
• Order subcategories alphabetically, making sure that any repeated combinations are white
• You are only allowed to connect to ONE data source and you MUST use logical data modeling
• Match the tooltips, in particular
  • Look at the language when there’s only one subcategory
  • Make sure you look at the colons as well
• You are also NOT ALLOWED to use LODs, Table calculations only