Introduction Welcome to Week 12 of 2025! If you’ve been developing workbooks for long enough, you’ve likely seen end users request a large amount of filters on a single page. That can take a ton of real estate. How do you balance the flexibility of a ton of controls with the overall usability of your […]
2025 Week 12 | Sigma: Can you save space? Read More »
Introduction Welcome to Week 6 of 2025! This week, we’re going to learn how to calculate a rolling metric, or moving sum. We’re going to use some sample Marketing Data to help us assess trends over time. We’re going to combine with some dynamic parameters to select which metric to calculate and how granular we
2025 Week 6 | Sigma: Can you roll with it? Read More »
Introduction It’s my first challenge of 2025! This week, we’re going to learn a new Sigma feature: Modals. Modals are pop-up windows that could be used for many things, like a form for an input table or to provide more detailed information. We’re going to use them to provide a breakdown on an Executive Summary.
2025 Week 4 | Sigma: Can you pop a breakdown? Read More »
Introduction It’s the last challenge of 2024! Whether you’ve been with us all year or are joining us for the first time, welcome! With the holiday season in full swing, we are keeping it light this week. We’re going to analyze some holiday movie data that I sourced from Kaggle. This dataset found movies on
2024 Week 52 | Sigma: Can you analyze these Holiday Movies? Read More »
Introduction Welcome to Week Forty-Eight! This week, I am heavily focused on my Thanksgiving preparations, so naturally, we will be taking our Workout Wednesday to the kitchen. I asked Chat GPT to generate us a dataset involving popular Thanksgiving dishes by state. We’re going to use that to utilize some newer features, like a conditional
2024 Week 48 | Sigma: Can you map these Thanksgiving Dishes? Read More »
Introduction Welcome to Week Forty-Four! This week, I wanted to have a little fun because not only is Thursday Halloween, but it’s also my birthday. As someone who loves data and shares her birthday with a holiday, I am interested to see just how common holiday birthdays are. In this challenge, you will use a couple
2024 Week 44 | Sigma: How likely is a holiday birthday? Read More »
Introduction Welcome to Week Forty! In my last article, Week 36, we covered how to affect multiple columns using the same filter. This week, we’re going to focus on even more advanced filtering techniques. What do you do when you want to compare multiple arrays? Luckily Sigma recently released a brand new function: ArrayIntersection. In
2024 Week 40 | Sigma: Can you avoid the food? Read More »
Introduction Welcome to Week Thirty-Six! This week, we’re going to focus on some more advanced filtering. By now, you should know how to utilize a page control’s targets to filter a single column in an element. What do you do when you need to affect multiple columns in the same element? You can utilize a
2024 Week 36 | Sigma: Can you filter without targets? Read More »
Introduction Welcome to Week Thirty-Two! This week, we’re going to highlight one of Sigma’s latest enhancements to Actions. In this challenge, you’ll add actions to controls to show or hide columns in visualizations based on the column names selected in the control. This new action gives users more control over the data they want to
2024 Week 32 | Sigma: Can you pick the right columns? Read More »
Introduction Welcome to Week Twenty-Eight! Now that we are firmly in Summer Mode, let’s plan a lake vacation! This week, we’re going to evaluate water quality monitoring data in the Great Lakes. The dataset we’re using comes from Data.Gov. This dataset has many different characteristics measured in one long table. Don’t worry. I’ve already created a Sigma
2024 Week 28 | Sigma: Are you ready for vacation? Read More »
