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 26 of 2026! Sigma Agent allows you to read, write, and execute actions natively within the workbook, data sources, and input tables. This challenge showcases how you may build last-mile data prep into a workbook with Sigma Agent. The example setup requires a Linked Input Table to store output from Sigma
2026 Week 30 | Sigma: Workbook Data Prep AI Agent Read More »
Sigma, Workout Wednesday
Introduction This week, we have another new contributor to Workout Wednesday for Power BI: Cameron Ayre. Give Cameron’s challenge a try! This week, we’re creating smoothed lines with a handy LOESS measure. We’ll use it to turn noisy data like this: Into this: Kerry Kolosko challenged us to do this last year , with Deneb
2026 Week 30 | Power BI: LOESS with DAX and Core Visuals Read More »
Power BI, Workout Wednesday
Introduction For this week’s challenge, I’m asking you to build a viz I put together that visualises the the tennis career of the current men’s world #1 and 2026 Wimbledon champion, Jannik Sinner. There’s a fair amount going on, so I appreciate this may take a while to completely replicate. If time is short, the
#WOW2026 | Week 30 | Can you build a ladder chart? Read More »
Tableau, Workout Wednesday
Introduction Welcome to Week 29 of 2026! This week, we’re going to create an approval process. In the past, we’ve created one using Insert Row and Update Row(s) actions. In this version, we will utilize Sigma’s new Insert Row(s) action to create an activity stream. With this new action, we can allow for tabular inputs,
2026 Week 29 | Sigma: Do you approve…. again? Read More »
Sigma, Workout Wednesday
Introduction One of the first “unique” chart types I ever learnt to visualise in a BI tool has since become one of my favourites, the Peas-in-a-Pod chart. This chart can be a great way to visualise the change between multiple data points. For example, in this challenge, we will be exploring how the IMDB ratings
2026 Week 29 | Power BI: Peas, Pods, & Pivoting Read More »
Power BI, Workout Wednesday
Introduction Welcome to week 29! I’m so excited to be back with another interesting challenge. It occurred to me recently that we’ve been using Sample – Superstore for decades and there is no shortage of date filter tips and tricks but they are all based on traditional Gregorian calendars. And I’ve yet to work with
#WOW2026 | Week 29 | Fiscal Fun Read More »
Tableau, Workout Wednesday
Introduction Imagine, your company hired a Chief Happiness Officer (CHO). Their job: keep the office running smoothly. Coffee stocked, ping-pong table used, no-show meetings under control. They ask for a dashboard. Your first instinct? KPI cards. One per metric, previous value, delta, nice arrow. Clean. Visual. The CHO loves it. Until there are more metrics.
2026 Week 28 | Power BI: Redesign a KPI monitor for the CHO Read More »
Power BI, Workout Wednesday
Introduction I’ve been on a mapping kick lately – as input tables make data entry and writeback easier, they come with some pitfalls: misspellings, circular references, and cowboy mapping. Today I want to show you a new strategy for handling mapping effectively in Sigma (sometimes called crosswalk tables by AI) using the new Unnesting feature.
2026 Week 28 | Mapping and Unnesting Read More »
Sigma, Workout Wednesday
Introduction This week we have a challenge by Lisa Hitch, Coach of the New York Data School and Winner of the Tableau Conference Tips Battle. This week we’re putting a fresh spin on a classic chart: the Pareto chart! The Pareto principle (also known as the 80/20 rule) tells us that roughly 80% of outcomes
2026 | Week 28 | Can you build a Pareto Chart with Colored Backgrounds? Read More »
Tableau, Workout Wednesday
Introduction You’ve probably seen the default Power BI tooltip that lists values like Sales, Profit, or Enrollment. While that’s useful, it doesn’t always explain what those numbers mean. Sentence template tooltips let you turn those values into a natural sentence… making your reports easier to understand without creating a custom tooltip page. Where can you
2026 Week 27 | Power BI: Create Smarter Tooltips with Sentence Template Tooltips Read More »
Power BI, Workout Wednesday