Introduction We’re continuing retro month this week, and I decided to re-viz Andy’s Week 41 challenge from 2017. I chose this one because I really like the concept of being able to drill down from state into city on the same chart, but I wondered if things would be easier than the calculations required to …
WOW2023 Week 30: Can you build a dynamic drill down scatterplot in one view? Read More
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 …
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
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 …
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 …
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 …
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
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 …
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
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 …
