Introduction Last week’s workout caused some healthy discussion about bar chart labeling preferences and best practices. This week we will look at other ways to implement space saving labels while also showing the data labels for the each bar in a bar chart. The report shown below demonstrates 4 ways to implement bar chart labels …
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 As promised, this challenge is a continuation of my last challenge in week 3. The source data stays the same just this time we convert the chart into a kind of Gantt. While the dot plot highlighted the points in time when the stage of the opportunity changed, this chart focusses a bit more …
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 One of the inciting factors for the CRMA WorkoutWednesday was this collaborative Tableau challenge last year. I attempted it in CRMA and actually got quite far. This week we’ll try something similar, with the hopes to be able to build on it for my next challenge in a couple of weeks. (We’ll see how …
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
