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 Living in Chicago, one of my favorite things to do is visit parks. Some are small, some are gigantic, and it’s often that I don’t really know all the options my local parks have to offer. I wanted to build this quick app off of Chicago Parks District data to help find parks near …
Introduction I often use the #datafam community as inspiration for my #WOW challenges, as it gives me the perfect opportunity to try out a particular technique or visualisation style, which I hope you all then benefit from too 🙂 This week’s challenge was inspired by this blog post by the Flerlage Twins, which in turn …
#WOW2025 | Week 31 | Can you build an alternative to a stacked bar chart? Read More
Can you create a feedback app? Introduction This week, we’re switching gears — from surfacing insights to capturing them. Using just a few of Sigma’s core features — input tables, controls, and actions — you can build a fully embedded NPS tool that lives right inside your dashboard. No scripts, no third-party forms, and no …
Introduction Happy Workout Wednesday, data fam! This week, we’re taking bar charts to the next level—with built-in scales that visually speak for themselves! We all love a good bar chart, but sometimes you want to show progress toward a goal or segment values into performance zones – without extra visuals, DAX trickery, or custom backgrounds. Just …
2025 Week 30 | Power BI: Bar chart with built-in scales 📏 Read More
Introduction Welcome back to Workout Wednesday! This week we’re building a special tooltip.It will include flags, and some special custom formatting. Want to learn, how to create a tooltip like this?Let’s do it! Requirements Download the sample data from the Data World Website – part 1 and part 2. [Note: Data.World requires you to create a …
Introduction Welcome to Week 29 of 2025! This week’s challenge is all about bringing back a tried-and-true classic: the Gantt chart. Whether you’re mapping out project timelines or visualizing task dependencies, this is your chance to put a clean, modern spin on one of the original BI visuals. Build something in Sigma that’s as functional …
Introduction This week’s challenge was inspired by a question from a colleague. They were looking for ideas for how to manage a chart with multiple lines and mulitple metrics. My colleague started with the idea of highlighting a single line in each chart, to show how the company compared to its competitors – a simple …
Introduction This week we’re challenging you to join the official Power BI 10th birthday celebration! Microsoft is celebrating by hosting a dataviz contest, and we’d love to see you join! You can find all of the details on the Fabric/Power BI Community Site, and we’ll paraphrase the challenge here below. Contest Timeline Start Date: Tuesday, …
Introduction Welcome to Week 28 of 2025! This week, we’re going to practice a newer feature of Sigma: Custom Context Menu Options. When combined with a series of actions, these options can really beef up your data application, allowing you to guide the user to new insights more easily than simply drilling down. Good luck! …
Introduction With the release of Tableau 2025.2, it’s time to test out its powerful new capabilities! This week, we’re tackling the new Dynamic Color Range feature using data from Japan’s House of Councillors elections. The basic requirements cover the fundamentals. For the bonus, we’ll address a practical issue you’ll almost certainly encounter when you try …
#WOW2025 | Week 28 | Can you use Dynamic Color Ranges? Read More
