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 »
CRM Analytics
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 »
CRM Analytics
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 »
CRM Analytics, Workout Wednesday
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 »
CRM Analytics, Workout Wednesday
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 »
CRM Analytics
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 »
CRM Analytics, Workout Wednesday
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 »
CRM Analytics, Workout Wednesday
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 »
Power BI, Workout Wednesday
Introduction Welcome to Week 36 of 2026! This week, we’re going to create a basic ordering workflow. When you build your workflow, I encourage you to use two new functions that Sigma released last week: TextJoin and LookupMatchNulls. We have moved our Workout Wednesdays to Sigma Public. Be sure to build your version there! Good
2026 Week 36 | Sigma: Do you promo? Read More »
Sigma, Workout Wednesday
Introduction Welcome back to Workout Wednesday! This week we’re exploring parts to a whole using a waffle chart and unemployment data. This visual was inspired by Steven Ponce, whose work has been a great source of inspiration for me. It also builds on my previous Workout Wednesday waffle chart, giving me an opportunity to revisit
2026 Week 36 | Power BI: Create an Unemployment Waffle Chart Read More »
Power BI, Workout Wednesday
Introduction We know that Tableau can be used for really great executive dashboards and analytic explorations, but one of the things that I love using Tableau the most for is storytelling. Especially whenever you can combine that with a map, Tableau can do some pretty incredible things. This week, for Workout Wednesday, we’re going
#WOW2026 | Week 36 | Let’s tell a story with Map Layers Read More »
Tableau, Workout Wednesday
Introduction This week I wanted to use Tableau Publics WebEdit to build a viz with one of their published datasources. Granted not all of the formatting options are there that I would like, so some of the chart choices are a bit wackier than they would be in Desktop. I would have love to have
Introduction Traditional customer rankings tell us who generates the most revenue, but they do not explain what those customers buy. A customer may be highly valuable and still buy almost entirely from one product category – which makes the next conversation much clearer than a generic “upsell” message. This week, build a Customer Cross-Sell Map in
2026 Week 35 | Power BI: Ternary Charts for Cross-Sell Read More »
Power BI, Workout Wednesday
Introduction Welcome to Week 34 of 2026! Do you leverage Sigma Input Tables to produce critical data that supports downstream data marts, joins, or reporting that could be impacted by a breaking change? This example shows you how you may leverage multiple layers of Sigma Input Tables to create a staging area that checks values
2026 Week 34 | Sigma: Input Table Staging with Conditional Validation Read More »
Sigma, Workout Wednesday
Introduction This week is all about maps. Tableau has always been strong with maps, but this time we’ll push it further using Dynamic Spatial Parameters, added back in 2025.2, to build something a little cooler. It’s a technique that’ll come in handy for real-world work too, so have fun with it and give it a
#WOW2026 | Week 34 | Mark Clustering Read More »
Tableau, Workout Wednesday
Introduction Last week’s bump chart reminded me of one of our early challenges from 2021, where David turned a ribbon chart into a bump chart. We’ve done other bump chart challenges over the years, so give them a try if you haven’t already. This made me curious about trends in chart selection in our challenges.
2026 Week 34 | Power BI: Visualizing WoW Chart Choices Read More »
Power BI, Workout Wednesday
Introduction Welcome to Week 33 of 2026! This week, we’re going to use Sigma’s AI Assistant to build a dashboard for us! This challenge is very open ended, so we may end up with something that looks different than mine, depending on your prompt and chat with the AI. Have fun building and share your
2026 Week 33 | Sigma: Can you work smarter? Read More »
Sigma, Workout Wednesday
Introduction Sometimes you’ll have products that launch at different times, and so questions come up of how is this most recent launch comparing to other launches in the past? So this week, we’ll have a view of the past year for 5 different products, and then a view with all of those products from a
#WOW2026 Week 33 | Can you visualize a common starting point? Read More »
Tableau, Workout Wednesday