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 In my 7 years of “coaching” #wow challenges, this might be the one I’m most excited about. You see, this weekend is Halloween and one of my favorite traditions around this holiday is carving pumpkins! I tried it all, mostly unsuccessfully, but I’ve never, in all my years, tried carving a pumpkin in TABLEAU!!!
#WOW2026 | 43 | TableauLanterns! 🎃 Read More »
community, Tableau
Introduction This week’s challenge we are visualising lottery draws. Lotteries are random, so whilst patterns that emerge may look pretty or interesting, they may not be insightful. What does your local lottery look like when visualised? Dataset Data for this challenge can be obtained from GitHub.https://github.com/JDsnyke/saturday-tatts-lotto-scraper/blob/main/supplementary_numbers.csv Requirements Data: Obtain the data from the link above
2026 Week 43 | Power BI: Visualising Lottery Patterns Read More »
Power BI, Workout Wednesday
Introduction Welcome to Week 42 of 2026! You built a Sigma App that addressed a critical business process and could possibly replace a legacy SaaS solution, but the workbook takes forever to load due to complex transformations and workarounds in Sigma. This Sigma Workbook Query Performance Optimizer combines Sigma workbook metadata from API endpoints and
2026 Week 42 | Sigma Query Performance Optimizer – Deterministic Approach Read More »
Sigma, Workout Wednesday
Introduction Bookmarks in Power BI can be so tricky sometimes but they’re so satisfying when everything lines up the way you want it to. This weeks challenge by Vivien Lee looks simple at first, it’s only one chart, one table, and a few buttons. But click on the info button in the corner and the
2026 Week 42 | Power BI: Overlay Information With Bookmarks Read More »
Power BI, Workout Wednesday
Introduction This week we have a challenge set by a fellow Data School Consultant, Oscar Kriebel. Yes you read that correctly another Kriebel in the Tableau World. Oscar kindly volunteered to submit a challenge for this week. Whilst I don’t agree with seeing so many Pie Charts, the techniques are interesting! Have fun! Click to
#WOW2026 Week 42: Can you create a small multiple pie chart? Read More »
Tableau, Workout Wednesday
Introduction What if a column chart could tell a story through color? A stripe chart uses colored stripes to reveal patterns and changes in data at a glance. In this exercise, we’ll transform Power BI’s native column chart into a stripe chart where each stripe represents a data point, and its color helps us spot
2026 Week 41 | Power BI: Stripe Chart using Native Column Chart Read More »
Power BI, Workout Wednesday
Introduction Welcome to Week 41 of 2026! This week, we’re going to use Sigma’s AI Assistant to build a dashboard for us… again! Sigma released new functionality to its AI builder assistant, so let’s test it out! This challenge is very open ended, so we may end up with something that looks different than mine,
2026 Week 41 | Sigma: Can you waterfall smarter? Read More »
Sigma, Workout Wednesday
Introduction This challenge comes straight from real-world work once again. The ask was simple: make both the count and its share easy to read, even if it requires scrolling.This design didn’t make the final cut, but it’s one of my personal favorites.Use this as a chance to deepen your understanding of what bar charts can
#WOW2026 | Week 41 | Can you unstack a stacked bar chart? Read More »
Tableau, Workout Wednesday
Introduction A profit card tells you the result. It does not show how that result is built, which components changed, or where to investigate next. This week, build an interactive Financial Metric Map in Power BI. Start with Net profit and reveal its components one branch at a time: revenue, cost of goods sold, operating
2026 Week 40 | Power BI: Metric Navigator Read More »
Power BI, Workout Wednesday
Introduction I’ll admit that I’ve been hesitant to leverage AI inside of Sigma for certain projects, especially when it came to some of the more advanced builds involving actions, controls, and conditional formatting, but I always throw a complex build at it when new updates come out. And with the Sigma Assistant becoming GA and
2026 Week 40 | Selectable Containers Read More »
Sigma, Workout Wednesday