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 […]
Pivot – Rows and Columns Total Read More »
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
Outliers Detection in CRM Analytics Read More »
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
Windowing with Input Widgets (Energy Data) Read More »
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
Playing with Ranks in CRM Analytics! Read More »
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
2024 Week 14 – Timeseries in CRMA! Read More »
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
2024 Week 04 – Maps and Interactions/Bindings Read More »
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 features the new Repeating Container element, which is a powerful new visual that can display feed-like information quickly and easily. Today, I want to show you how you can use this feature to make more detailed KPI-like cards in your workbooks. This feature is still in beta – are there any things
2026 Week 04 | Sigma: Can you Make a Repeating Container? Read More »
Introduction Happy New Year everyone, my turn comes round awfully quickly these days. As it’s still the start of 2026, I didn’t want to go too hard too quick. Hopefully this isn’t too bad. We are flexing our Table Calc, Date and Order of Operations skills in this challenge. Have fun! Click to open in
#WOW2026 | Week 4 | Can you create a dynamic moving average? Read More »
Introduction This week’s Workout Wednesday is about turning feedback into part of the workflow, not a side conversation. You’ll build a lightweight, in-workbook feedback loop in Sigma that lets stakeholders flag issues directly on tables and charts, with context intact. Instead of comments that disappear or Slack messages that pile up, feedback becomes structured, reviewable,
2026 Week 03 | Sigma: Running Feedback Loop Read More »
Introduction Last month I had some colleagues that were able to attend DataFam Europe, and a few of them came back saying how much they enjoyed Tristan Guillevin’s presentation and asked if we could get his viz extensions for our Cloud site. In the process, I decided to play with a few, and since they
#WOW2026 | Week 3 | Can you create KPI cards with viz extensions? Read More »
Introduction Welcome back to #WOW2026! Thank you all for your continued support, and for bearing with us while we carried out some maintenance on the website. For the first challenge of the year, I’m asking you to recreate a technique that was originally introduced way back in 2010, and re-shared during a ‘tips and tricks’
#WOW2026 | Week 2 | Can you create a fake Viz in Tooltip? Read More »
Introduction Welcome to the final week of 2025! Since it’s a holiday week, we’re keeping things simple with a classic but powerful visualization: the Pareto chart. Your challenge this week is to build a Pareto chart in Sigma that highlights which issue categories contribute the most to overall incident reports. By combining a sorted bar
2025 Week 53 | Sigma : Can you build a pareto chart? Read More »
Introduction Welcome to Week 52 of 2025! This week, we’re going to take it easy and practice utilizing some new UI elements in Sigma: Headers and Navigation Elements! They have not been around for long, but I already use them everywhere I can. Good luck! -Ashley Need access to Sigma? Click Here to Sign Up
2025 Week 52 | Sigma: Can you go head to head? 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 51 | Power BI: Holiday Traffic: Who Came, Who Left 🎄 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 »
