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
Can you create an if-else action workflow? Introduction This week, we’re exploring how Sigma’s new if-else Action transforms dashboards into decision apps. Instead of static filters and views, you’ll build a responsive experience that changes based on what users select. The goal isn’t just to add logic – it’s to streamline ad-hoc work. With a …
Introduction In this challenge, you’ll recreate a Tableau Pulse–inspired dashboard from scratch. One of the key features of Tableau Pulse is to automatically detect trends and changes in your data, displaying an “Expected Range” for each metric to help users instantly grasp performance at a glance. Your task is to reproduce this concept using Tableau’s …
#WOW2025 | Week 41 | Let’s Make a Tableau Pulse-inspired Dashboard! Read More
Introduction I’ve been reading the new book Dashboards That Deliver by Andy Coatgreave, Amanda Makulec, Jeffrey Shaffer, and Steve Wexler. Chapter 14 contains an eCommerce dashboard by Dorian Banutoiu that shows how many people viewed a product, added it to their cart, and then actually purchased it. I appreciated the compact nature of what the book …
2025 Week 41 | Power BI: eCommerce metrics bar-in-bar visualizations Read More
Introduction Workout Wednesday crew! Did you know that Microsoft is now hosting a Dataviz World Championships every year, twice a year? The premise is that you create a report for a preliminary round (or rounds), and 4 finalists are then selected to compete live on-stage at the Fabric Community Conference (FabCon). I just returned from …
2025 Week 40 | Power BI: Announcing the DataViz World Champion Read More
Introduction Welcome to Week 40 of 2025! This week, we’re going to dive deeper into the world of Data Apps. We’re going to create an approval workflow where users can submit requested changes and then someone can go into the same workbook to approve or reject these changes. Good luck! -Ashley Need access to Sigma? …
Introduction I had a thought last week about using the parameter driven axis ranges and whether they could be reset to the minimum and maximum. Turns out they can be, and hence this challenge. Click to open in Tableau Public Requirements 1 sheet You’ll need: 4 parameters 4 LODs 1 colour calc (reference lines are …
#WOW2025 | Week 40 | Can you create this Zoom and Reset Scatter Plot? Read More
Introduction Sigma’s new features keep coming and they don’t stop coming and this past week was no different. We got two powerhouse features that eliminate SO MUCH EFFORT from maintaining beautiful workbooks: Navigation Elements and Custom headers. Today, I wanted to focus on those, since I have a feeling we’re all going to be adding …
Introduction Today at work I started to create a two-level hierarchy bar chart, but then I realized one of the measures I was using was a MAX() value for the 2nd tier, but I wanted to sum those for the top tier. So I needed to create a drill down instead of a hierarchy. In …
Can you create a data request and approval app? Introduction This week, we’re proving Sigma isn’t just for crunching numbers – it’s an all-weather, cross-functional tool. The challenge is to step outside pure analytics and build a lightweight, system for managing notes and reminders. The goal isn’t to replace your task app. It’s to show …
Introduction Sometime ago, I came across this post by Sarah Pallett ( X | LinkedIn ) introducing the idea of L-Shaped bar charts… … and I thought it would make a perfect WOW challenge (as it gave me an excuse to build a version myself). Click to open in Tableau Public Requirements Size 1000 x …
#WOW2025 | Week 38 | Can you build an L-Shaped bar chart? Read More
