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 Welcome to Week 35 of 2025! When building reports in Power BI, one of the most common requests I hear from users is: “Can I explore different KPIs side by side without creating dozens of visuals?” The good news: yes, you can! And it’s cleaner than ever with field parameters grouped by category. In …
2025 Week 35 | Grouped Field Parameters in a Matrix Read More
Introduction We’ve had a few weeks of beautiful data apps on Workout Wednesday, but today I want to focus on something that will make your data apps even cleaner, and that’s the quality of your data! I love the ‘Transpose’ feature that Sigma added a few releases ago, and it enables quality control (QC) checks, alerting, …
2025 Week 35 | Sigma: Can You Improve Your Data Quality? Read More
Introduction I’ve recently been running several hands-on Tableau workshops for beginner- to intermediate-level users across different prefectures. In one of those sessions, a participant asked how to visualize both ranking changes and differences in sales at the same time. This week’s challenge was inspired by that question. It might be a bit tricky, but I …
#WOW2025 | Week 35 | Can You Visualize Yearly Rank Changes in Sub-Category Sales? Read More
Can you create a data request and approval app? Introduction This week, we’re moving beyond analysis and into data apps. We’re going to solve one of the most persistent problems in any data-driven organization: data quality. The challenge isn’t just to clean data. It’s to build a complete, self-service system that empowers your business users …
2025 Week 34 | Sigma: Let’s Request Some Data Changes Read More
Introduction When building reports, one of the most common requests I hear from users is: “Can I see the top three, top five, or top ten items without having to look at multiple visuals?” The good news: yes, you can! And it’s cleaner than ever with numeric range parameters in Power BI. In this week’s …
Introduction I’ve been playing around with Tableau MCP and something called “Vibe Analytics” lately (look them up if you’re curious!).This week’s challenge was inspired by working with a generative AI to analyze the Sample Superstore dataset, exploring ways to break down profit into its key drivers and compare year-over-year performance. Have fun building this waterfall …
#WOW2025 | Week 34 | Can you breakdown YoY profit into its drivers? Read More
Introduction Welcome to Week 33 of 2025! We’ve all been there: you want to cross filter a dashboard by clicking on a field, and just as easily clear the selection. With charts, it’s easy – just click the white space. But with tables, it can be a little trickier. This week’s challenge: master cross-filtering from …
2025 Week 33 | Sigma : Can you cross filter tables? Read More
Introduction It’s good to be back again, and a bit sooner than last time! This time, we will be creating a visual using Deneb. Deneb has featured a lot in WoW, which I’m very grateful for, but I’ve yet to submit and exercise for it. As such, I wanted to try something that would help …
2025 Week 33 | Create a Circular Heatmap with Deneb Read More
Introduction I created this viz to show off some crazy golf scores from my latest cohort at The Data School, especially to show off the fact I won. But I added in some Table Calculations and other bits to add some context, I thought it would make a good challenge. Click to open in Tableau …
#WOW2025 Week 33: Can you recreate this Marginal Histogram Read More
Introduction Welcome to Week 32 of 2025! This week, we’re going to have a little summer fun comparing roller coasters. This prompt is less prescriptive than usual to give you the freedom to let your creativity flourish. Where do your favorites fall? Good luck! -Ashley Need access to Sigma? Click Here to Sign Up Link …
