Introduction If you’re as old as I am, you might remember MacGyver. For eight-year-old me, he was simply the coolest person who ever lived: he was a brilliant thinker and could get out of any situation with a Swiss Army knife and whatever was lying around. These days, to “MacGyver something” is a homage to […]
2023 Week 29 | Power BI: Core Visual Waffle Chart Read More »
Power BI, Workout Wednesday
Introduction For retro month at WOW Towers, I decided to go way back into the archive and focus on a challenge that was set by one of the original WOW coaches, Emma Whyte, in May 2017. The original challenge looked like the below image and provided a visual representation of the results of a blind
#WOW2023 | Week 29 | Re-viz : Blind leading the blind Read More »
Tableau, Workout Wednesday
Introduction This week’s challenge was inspired by Bas. We are creating a Timeline Visual using the Line Chart and measure-driven data labels. For this project timeline, we will be adding a today line, highlighting completed milestones, and milestones that are off-track. We will be adding descriptors to the milestones and truncating the descriptors to a
2023 Week 28 | Power BI: Project Timeline Read More »
Power BI, Workout Wednesday
Introduction This is week 28 of 2023 and week 2 of #RE-VIZ-IT and I’m bringing back my VERY FIRST #WOW challenge from WAY BACK in the summer of 2018! I chose this challenge because “back in my day” this use case required additional sheets, a “custom” chart and a lot of sheet swapping. If you
#WOW2023 | 28 | Can you Show & Hide Legends? Read More »
community, Tableau, Workout Wednesday
Introduction Hello and welcome to WoW week 28! This weeks topic takes it back to a fundamental lesson in CRM Analytics. I often get questions about data accuracy from users when they are comparing rows of data to the row count of a grouped chart or table. Have you ever experienced a case of “missing
2023 Week 28 | How to Handle “Missing” Rows Read More »
CRM Analytics, Workout Wednesday
Introduction This week we are going to have some fun with Power Query to obtain data from a website that spans multiple pages and then visualize the data in a treemap. Treemaps are meant to display hierarchical data as a set of nested rectangles. They aren’t a great replacement for bar charts when minor differences
2023 Week 27 | Power BI: Power Query Simple Pagination and a Treemap Read More »
Power BI, Workout Wednesday
Introduction This July we bring you another month of challenges with a theme: We are going RETRO!Each coach will be going back through the WorkoutWednesday archives and re-vizzing a challenge from the past. It may be one of their favourite challenges, or maybe there’s a much easier way to do
#WOW2023 | Week 27 | Re-viz: Discovery Dashboard Read More »
Tableau, Workout Wednesday
Introduction Welcome back to Workout Wednesday! This week we’re exploring the new card visual that was released in preview this month. Key metrics are frequently displayed in reports, and in the past it took a combination of cards, images, and other visuals. Thanks to the new card visual, we now have more flexibility, options for
2023 Week 26 | Power BI: Display metrics with the new card visual Read More »
Power BI, Workout Wednesday
Introduction This week we are exploring the Component widget. Essentially it is a container with pages that allows you to quickly create and reuse dynamic areas of a dashboard! Components solve 2 main use cases: Reusability & maintainability (the components you create in this challenge will be used again in a future challenge!) Easily (through
2023 Week 26 | The Component Widget Read More »
CRM Analytics, Workout Wednesday
Introduction This week we are tackling Antarctic ice data. The changing sea ice will represent significant challenges for ourselves but even more for future generations. One thing we’ve come to realize in the past few years is that changes are coming much faster than we ever anticipated. For this week’s challenge we’re going to use
2023 Week 26: Antarctic Ice Extent Read More »
Tableau, Workout Wednesday