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 »
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 »
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 »
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 »
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 »
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
2024 Week 04 – Maps and Interactions/Bindings Read More »
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 Imagine you are the Senior Customer Success Manager at a SaaS company that runs on a subscription model, and you are responsible for reviewing complaint resolutions proposed by junior-level agents. This week, we are bringing Snowflake AI_Sentiment(), AI_Classify(), and AI_Complete() functions into Sigma AI App. Snowflake Cortex AI will help you identify the customer’s
2026 Week 18 | Sigma: AI Sentiment Analysis with Snowflake Cortex Read More »
Introduction This challenge was released at the TC26 Workout Wednesday session. Whether you’re here in the room or finding it later, I hope you’ll have fun! In this challenge, we’ll visualize the sessions of Tableau Conference itself. Three difficulty tiers are available, so pick the one that matches your confidence and give it a try.
#WOW2026 | Week 18 | Let’s Visualize TC25! (#TC26 Live Edition) Read More »
Introduction This month, we’re teaming up with the Microsoft Fabric Community to bring you a series of bite-sized, hands-on challenges designed to help you build (and share!) your skills one week at a time. Whether you’re just getting started or looking for a quick midweek spark, Miniviz May is all about learning by doing. Jump
2026 Week 18 | Power BI: Miniviz May Week 1 Read More »
Introduction Welcome to Week 17 of 2026! This week, we’re going to play with a newer feature in Sigma: Pixel Perfect Reporting. We’re going to create a report that examines food waste which could be scheduled to export to various food truck executives on a weekly basis. Good luck! -Ashley Need access to Sigma? Click
2026 Week 17 | Sigma: Let’s Waste Some Time Read More »
Introduction Since I jumped the gun on Community Month with Jack’s guest challenge last time around, I was exploring some of the other viz extensions from LaDataViz, when I came upon a radar chart. Since Donna’s challenge last week was a radar chart inspired by a community member technique, I thought it would be interesting
#WOW2026 | Week 17 | Can you build a radar chart using viz extensions? Read More »
Introduction Inspired by a previous Tableau challenge, we are making a double-sided stem-and-leaf plot, but we are using a different dataset and showing the observed petal length of two species of iris. A stem-and-leaf plot displays numerical data by splitting each value into a “stem” (leading digit) and a “leaf” (trailing digit), arranging them so
2026 Week 17 | Power BI: Create a Double-Sided Stem-and-Leaf Plot Read More »
Introduction Sigma has been adding functionality that has taken the app from a fantastic BI solution to an outstanding Application building tool. One of the features that helps with that is the introduction of API Actions. With API Actions, you can retrieve data from outside sources and send data out to other sources. The challenge today is
2026 Week 16 | Can you check the weather? Read More »
Introduction This week, we are making a Power BI version of a previous Tableau challenge by Donna Coles. We are making small multiple spiral charts, also called satellite charts. Satellite charts can be used to show percentages when values exceed 100%. Rather than creating one circle like a donut chart, the line spirals out to
2026 Week 16 | Power BI: Recreate the Tableau Satellite Chart Read More »
Introduction For this week’s community challenge, I am drawing inspiration from this blog post by fellow Ambassador and new Visionary, Johan de Groot. I’ve had radar charts on my back-burner for some time, but never got round to putting out as a challenge, as felt they may seem ‘too fiddly’. But Johan shared a ‘map
#WOW2026 | Week 16 | Can you build a radar chart with map layers? Read More »
Introduction In this week’s challenge we are exploring the new Power BI Theme that is in Preview : https://powerbi.microsoft.com/en-us/blog/deep-dive-into-modern-visual-defaults-and-customizing-theme-improvements-preview/ The new theme comes with new chart defaults and additional Style Presets. The challenge is to set your own defaults by downloading the JSON Theme file and modifying it. You can use a
2026 Week 15 | Power BI: Exploring and Enhancing the new Theme Read More »
