Introduction Hello and welcome to the week 40 CRMA challenge! The instructions are written assuming you already have a dev org with Accounts and Contacts loaded. If you need to spin up a new org with data, see the link below. This week we are creating a interactive table to search/sort Customers and Accounts by …
2023 Week 40 | Interactive Rolodex for Large Data Viewing Read More
Let’s analyze product sales for each year as this week’s #WOW2023 challenge.
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 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
