Introduction Only X months/ a year later, Val is back as a guest coach with another challenge.And if you remember #WOW2022 W35, you know that Val loves a good table! Anicely formatted table, if possible. A table filled with table calcs – even better.This week’s WOW challenges you to create a dynamic tidy-looking table showinga …
#WOW2023 | Week 39 | Target Achievement Report (Guest) Read More
Introduction This week we’re revisiting Meagan’s challenge where we built a bar chart with long labels. We’re going to use a trick recently unveiled by Bas (@howtopowerbi on Twitter) to create custom labels for bar charts. If you have long labels in your bar chart, they may be truncated depending on the size of the …
Introduction Hello and welcome to week 38 of our CRM Analytics WoW challenges! This week we are exploring Single-Click Interactions through Dashboard Widgets! This feature allows you to create a curated journey for your users turning a static dashboard into a dynamic navigation experience that progressively reveals more details. The teams at Salesforce CRM Analytics …
Introduction The race to dominate quantum computing has the potential to revolutionise various fields by solving complex problems that are currently intractable for classical computers. This week we will recreate the infographic “The State of Quantum Computing” published in the Harvard Business Review magazine (Harvard Business Review, vol. 101, issue 2, 2023, p. 25). Requirements …
2023 Week 38 | Power BI: Visualize the State of Quantum Computing with Deneb Read More
Introduction I joined the Workout Wednesday crew in 2018. Since then I’ve provided–from what I can count–64 challenges. And I’ve never been short of real-life challenges. In my job, I’ve encountered so many problems that I could take apart and provide to the community without exposing who my customers were at the time. Many of …
Introduction This weeks challenge came to me through a Data School consultant trying to figure something out. We figured for their workbook it would take a full rebuild, but it gave me inspiration to try and do it from scratch. So today I present to you a KPI dashboard, where you can only pick a …
#WOW2023 Week 37: SDG Goals showing a maximum of 6 Read More
Introduction Recently, I needed to build a dashboard from some pre-aggregated, segmented data counting unique users. This created some difficulty, because we may want to look at overall numbers, or one segment, or multiple segments, and that changes the user counts. Each of these have their own level of aggregation in the data, so it …
#WOW2023 Week 36: Can you build a dashboard for pre-aggregated metrics? Read More
Introduction Sometimes it can be useful to show all data points instead of aggregating them. That is where an instance chart, also called a strip plot or a barcode plot, can be useful. A strip plot is like a single-axis scatter plot. The symbol or shape used in the instance chart can vary, but it’s …
2023 Week 35 | Power BI: Create a Faceted Instance Chart Read More
Introduction I’m always on the lookout for ideas for challenges. Typically I’ll see something someone has done and want to know how they did it and whether I can craft it into a WOW challenge. When my colleague, Sam Parsons, demonstrated the concept of an interactive Viz In Tooltip (VIT) at Tableau Conference this year, …
#WOW2023 | Week 35 | Can you build an interactive Viz in Tooltip? Read More
Introduction Welcome back to Workout Wednesday! This week we’re building some basic visuals and use dynamic titles to visualize gas prices in the Rocky Mountain Region of the US (where I live!) over the past 3 years from the U.S. Energy Information Administration. Be sure you’re using the June 2023 version of Power BI desktop or later …
2023 Week 34 | Power BI: Use core visuals with dynamic titles Read More
