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 If you spent any time working with charts, you are probably aware of the controversy around pie charts. While there are some aspects to be discussed, others are generally agreed upon. One of these ones is the fact that it’s next to iimpossible to compare the slices of two pies with each other. Nevertheless, …
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 …
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 …
Introduction This week we are continuing our viz efforts inspired by the 1 dataset 100 visualizations project, presented by the Data Viz Project. Last week, Meagan challenged us to create as many visuals as possible using the Deneb custom visual available in Power BI AppSource. The week before, Shannon challenged us to make as many visuals as …
2023 Week 25 | Power BI: Bubble Chart Variants with Charticulator Read More
Introduction I saw this visualisation floating around my twitter and trending on Tableau Public and thought it would make a great challenge for Workout Wednesday. Big thanks to Jacob for letting me use his visualisation as inspiration today! In this weeks workout, I want you to look at the percent change between two dates, we …
#WOW2023 Week 25: Can you calculate a percent difference between a range of dates? Read More
Introduction This week we are continuing our viz efforts inspired by the 1 dataset 100 visualizations project, presented by the Data Viz Project. Last week, Shannon challenged us to create as many visuals as possible using the core visuals available in Power BI. This week’s challenge is to create visuals using the Deneb custom visual. I have …
2023 Week 24 | Power BI: Visualize Change Between Two Points in Time with Deneb Read More
Introduction This week’s challenge is another exploration of dynamic zone visibility, this time combined with a mobile app-like concept. Sometimes executives need just a few critical metrics at their fingertips, and this is a concept I’ve mulled around for a while (probably stemming from this concept by Anya A’Hearn) but felt like dynamic zone visibility …
#WOW2023 Week 24 | Can you build a mobile KPI app? Read More
