Ashley Bennett

Sigma Architect with Aimpoint Digital

2024 Week 52 | Sigma: Can you analyze these Holiday Movies?

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 »

2024 Week 48 | Sigma: Can you map these Thanksgiving Dishes?

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 »

2024 Week 40 | Sigma: Can you avoid the food?

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 »

2024 Week 32 | Sigma: Can you pick the right columns?

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 »

2024 Week 28 | Sigma: Are you ready for vacation?

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 »

2024 Week 25 | Sigma: Can you compare these populations?

Introduction Welcome to Week Twenty-Five! This week, you’re going to compare US Census data from 2000 and 2010.  In this challenge, we’ll highlight a couple of new formatting additions to Sigma, as well as create a dynamic parameter.  Good Luck!-Ashley Need access to Sigma? Click Here to Sign Up Link to WOW Sigma Instance Youtube …

2024 Week 25 | Sigma: Can you compare these populations? Read More »

2024 Week 17 | Sigma: Can you Cohort These Customers?

Introduction Welcome to Week Seventeen! This week, you’re going to perform a Cohort Analysis of food truck customers based on when they placed their first order.  Conditional formatting will help highlight which cohorts have a greater percentage of customers in them. As a bonus, you will implement a dynamic page control input to let the …

2024 Week 17 | Sigma: Can you Cohort These Customers? Read More »