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 Surprise! I have one more challenge for the year. This challenge was inspired by a workbook I created in my early Sigma days. We wanted to track weekly progression toward a quarterly total. Sounds easy, right? I thought so, too! But then I realized that DateTrunc(“week,” [Date]) would duplicate the week label across quarters. …
2024 Week 51 | Sigma : Can you calculate weekly progress? Read More
Introduction Welcome to Week 50! This week we’re playing with a new Sigma feature – modals! Modals are pop-ups that can contain any elements that you might otherwise have in another tab. There is so much opportunity with this feature, particularily when combined with actions! The formatting styles and colors in this challenge are all …
Introduction Welcome back to Workout Wednesday! This week, we’re shining a spotlight on an incredible solution shared by community member Valerie Junk. It’s always inspiring to see how ideas ripple through the community—Valerie’s post was sparked by none other than Nikola Ilic, a powerhouse of creativity and insight in our space. I’m continuing my theme of community gratitude, …
2024 Week 51 | Power BI: Highlight Data with a Slicer by Valerie Junk Read More
Introduction As we near the end of 2024, I have one last BIG challenge for you all. In the new year I plan to hit reset and get back to fundamentals. If you’re looking to take a break for the holidays, I hope you can come back to this head scratcher when you’re ready. This …
#WOW2024 | Week 51 | Filter for One Value OR All Others Read More
Introduction We’re going to try something a little different this week. We’re going to make a viz/dashboard without a dataset. Having just come from my daughter’s Christmas show this evening, and thinking I wanted to focus on container/dashboard formatting but keep it simple, I decided to build, then decorate a Christmas tree. So, that’s what …
Introduction This week, we’re diving into how to link a single color across multiple elements, giving users the power to choose which item gets the color splash. Plus, we’re checking out the latest tweaks to the Trellis options to make your visualizations even cooler. Have fun!-Katrina Need access to Sigma? Click Here to Sign Up …
2024 Week 49 | Sigma: Can you create a highlight action? Read More
Introduction A percentile is a number denoting the position of a data point within a numeric dataset by indicating the percentage of the data points with an equal or lesser (assuming it’s inclusive) value. Percentiles can be used to understand test scores, stock values, health indicators, and other values. This week, we will use them to look …
2024 Week 49 | Power BI: Visualize Ranges with Percentiles Read More
Introduction This weeks challenges come from a fellow Data School Coach, Robbin Vernooij. He created this back in 2019, but I thought it was a pretty cool dashboard and gets you to think about Sets in a good way! Click to open in Tableau Public Requirements Dashboard Size 1000×800 Connect the data together You can …
#WOW2024 W49: Can you create a scatter plot investigation? Read More
Introduction Welcome back to Workout Wednesday! I’ve been getting so much of my inspiration from the community lately, and this week’s challenge is no exception! Recently, Andy Kriebel posted a cool calendar filter on LinkedIn, that he built using Tableau. Our very own guest contributor and friend Erik Svensen took Andy’s post and re-created it …
2024 Week 48 | Power BI: Use a Calendar as a Filter Read More
Introduction Hey there #DataFam! Welcome to week 48 of 2024…that’s wild when you think about it. That means that we have 47 other challenges already this year. So what are doing this week? We’re gonna play different mark types on dual axis. This week’s challenge is something I’m calling a “candle line” chart. Check it …
