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 »
Say hi to hierarchies Introduction This week, we’re turning hierarchies into a decision tool. Using Sigma’s ragged hierarchies, hierarchy controls, and funnel charts, you’ll build a Campaign Leak Finder that pinpoints exactly where your funnel is breaking down. You’ll create a navigable tree from Lead through Campaign, wire it to a live funnel, and layer …
2025 Week 50 | Sigma: Find the Leak with Hierarchies Read More »
Introduction For my last challenge of the year, I decided to make it a little spicier. It has parameters, it has fun calculations, it has AND/OR logic, and it has a dynamic title that is worthy of your attention. Here’s hoping you can apply all those skills you’ve gained this year to sail through this …
#WOW2025 | Week 50 | Top 1% of Customers by Profit OR Sales OR Quantity Read More »
Introduction The first snowfall in Denver was unseasonably late this year. So I got curious about the data and decided to make a visualization. While this one does communicate with data, it’s taking a bit of artistic license. This is your challenge as well: create a first snowfall scatterplot with some wintery visual effects. You …
2025 Week 50 | Power BI: First Snowfall Scatterplot Read More »
Introduction Welcome back to Workout Wednesday! This week we’re partnering with the Fabric Community team for their final QuickViz challenge! The idea is simple: create a single visual, upload the .pbix to the Fabric Community, and browse the other entries to see what you can learn! Read more about the challenge in the Fabric Community. Let’s …
2025 Week 49 | Power BI: Join the last QuickViz Challenge Read More »
Introduction Welcome to Week 49 of 2025! Going back to data applications this week. I come across a constant request from clients when building data apps: How can I let users view all the records but not be able to edit them? This week we are going to figure out how we can do this …
Introduction I thought about this challenge after I had a question about doing it, usually where these ideas come from. Tableau don’t make this easy and unfortunately you have to hack it a little bit. But today we are going to create breadcrumbs in Tableau especially when using filters Click to open in Tableau Public …
#WOW2025 W49: Can you create breadcrumbs for filters? Read More »
Introduction Welcome back to Workout Wednesday! This week we’re building a stream graph in Power BI! A stream graph is a variation of the stacked area chart that arranges categories so they flow above and below a central baseline. This creates a smooth, organic “stream” appearance. Stream graphs are excellent for visualizing how many categories change over time …
Introduction Welcome to Week 48 of 2025! This week, we’re going to create a list of admin-curated announcements with an indicator showing if the current user has any unread announcements. Good luck! -Ashley Need access to Sigma? Click Here to Sign Up Link to WOW Sigma Instance Youtube Click here to Watch: How to Register …
Introduction Following last week’s challenge, we’re continuing with the Bar Chart Race theme — but this time, it’s more advanced! Last time, we created a basic Bar Chart Race, but because we used monthly data, the animation movement was somewhat discrete. This week’s challenge takes it to the next level by using Data Densification and …
Introduction This week, Agentforce World Tour Tokyo is being held in Japan! As one of the many sessions from DataFam, Workout Wednesday will be holding its first-ever live session in Japan! For this special occasion, With Yoshi and other supporters from the Japanese Workout Wednesday enthusiasts have created a fun, quick challenge themed around a …
#WOW2025 | Week 47 | Can you make a bar chart race? Read More »
