Introduction Hello and welcome to Week 34! Let’s get the fun started this week with Rows and Columns Total in the Pivot Table! Yes, you heard that right, we want to sum the rows and columns and yet have all the data show. Requirements Create a dev org or use an existing org you have …
Introduction This post is special! It has been sent by Pedro Gagliadri who has been working on CRM Analytics since it was called Wave! Yes, some of us have been using this tool forever! Now for the challenge: This Outliers Detection will use Z-Scores. Prepare a recipe and a dashboard that allows you to see …
Introduction We are already into the mid 2024 and hope you are ready for another challenge! This is hopefully easier than some of the previous challenges we have set in CRM Analytics this year! It contains windowing function with input widgets. Yes, you read that right! Two great tools that can make your and your …
Introduction It’s the 18th week of the year and time for another CRM Analytics challenge! This week’s task is to rank the energy dataset by country for each year and create one chart out of it. This chart will show the least and most energy consumed based on the type of energy consumption selected. Sounds …
Introduction Another month another week and we are already in the second quarter of the year! Let’s start this quarter strong and use timeseries in dashboards. This week is based on similar dataset as the week 4 and 9 but has been organized by energy types as a column! The challenge is to create a …
Introduction Almost the end of February! Time flies fast! – And another WoW Challenge is here!! This week is based on the same dataset and maps we had as a challenge during Week 4! The changes are adding one KPI, and one top 5 chart to the existing dashboard. Then add an Interaction (not binding) …
2024 Week 09 – Formulate Select and Navigate Dashboard Read More
Introduction We are already into the 4th week of the year – WOW!! My first time creating a WoW challenge. This one is based on maps! Yes, I know CRM Analytics maps make us desire for better versions, but we can always do cool things with what already exists. But, but… this one is not …
Introduction Welcome to Workout Wednesday 2023, Power BI edition! If this is your first time joining us, we’re happy you’re here. The goal of this initiative is to help you build your Power BI skills. We provide the data and the instructions, and you build the visuals! We hope you have fun and learn a new …
2023 Week 01 | Power BI: Use DAX to control visual display Read More
Introduction This week’s challenge is brought to you by a new guest coach, Kieran Adair. Kieran lives in Australia and has been working with Tableau for several years. He has been a long-time fan of Workout Wednesday and recently reached out to me with an idea for a challenge, which I thought you all might …
#WOW2025 | Week 8 | Can you display a ratio and a volume on the same chart? Read More
Introduction The January 2025 update of Power BI Desktop brought us some enhancements to the tree map visual, including 3 new tiling methods and options for spacing between groups and nodes. So this week we are trying out those features to make a tree map organized into columns. Requirements Download the “Regional Sales Sample.pbix” file …
2025 Week 7 | Power BI: Create a tree map organized into columns Read More
Introduction Welcome to week 6! This week, we’re looking deeper into dynamic switching. I’ve liked creating elements that dynamically change the metric or the dimension, but I ran into an issue when I also needed to have a custom sort order for one of the dynamic dimensions. I hope this helps you solve some edge …
2025 Week 07 | Sigma: Dynamic Switching and Custom Sorting Read More
Introduction I’m honored to present another challenge as a WOW coach this year.Being a coach last year was a great learning experience. It made me rethink whether my approach was truly the best and if the content was genuinely valuable for WOW participants.I’m excited to continue this journey and thankful for the chance to contribute …
WOW2025 | Week 7 | Can you Manually Color a Highlight Table? Read More
Introduction Welcome to week 6 of Workout Wednesday 2025. In this week’s challenge we will be exploring other charting options used across the web and how these can be embedded into Power BI Desktop. Using publicly accessible charts and data, we will utilise the HTML content visual to embed interactive charts within iFrames. The examples …
2025 Week 6 | Power BI: Can you embed charts from Web? Read More
Introduction Welcome to Week 6 of 2025! This week, we’re going to learn how to calculate a rolling metric, or moving sum. We’re going to use some sample Marketing Data to help us assess trends over time. We’re going to combine with some dynamic parameters to select which metric to calculate and how granular we …
Introduction I am truly honored to continue serving as your coach and supporting your learning this year.My first challenge in 2025 is about an exploratory dashboard. Have you ever created a dashboard that allows users to explore data step by step, from an overview to detailed information?In many cases, this can be achieved using filters …
#WOW2025 | Week 6 | Can You Adjust Dashboard Design by Filter? Read More
Introduction There are times where we want to compare categorical data with a total, perhaps an average. And sometimes we don’t want to see that total at the bottom of a table. So this week we are creating a bar chart that contains a “total average” bar. We want the bar chart sorted descending by …
2025 Week 5 | Power BI: Add an All Category to a Bar Chart Read More
Introduction Inspired by the colors of the Kansas City Chiefs and Philadelphia Eagles, who are competing in the upcoming Super Bowl, this week we are exploring some new customization options in Sigma charts. Have Fun!Katrina Need access to Sigma? Click Here to Sign Up Link to WOW Sigma Instance Youtube Click here to Watch: How …
2025 Week 5 | Sigma : Can you customize this chart? Read More
Introduction I was looking through the new features available in version 2024.3 recently, and came across Spatial Parameters. Since I had some spatial data from a couple challenges ago, I decided to give it a try and see if I could make it work. For a quick intro of Spatial Parameters, I suggest TableauTim’s introductory …
