Author name: Ashley Bennett

Sigma Architect with Aimpoint Digital

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 »

2024 Week 14 | Sigma: It’s a Bird… It’s a Plane… It’s Lookup Functions!

Introduction Welcome to Week Fourteen! This week, you’re going to learn about Sigma’s Lookup function.  Lookups are very useful for joining information from one data source to another, without accidentally fanning your data.  Sigma also has a Lookup Wizard for a foolproof way of utilizing this function. When I book a flight, I am particularly concerned

2024 Week 14 | Sigma: It’s a Bird… It’s a Plane… It’s Lookup Functions! Read More »

2024 Week 11 | Sigma: Can you find the Subtotal?

Introduction Welcome to Week Eleven! This week, you’re going to learn about Sigma’s Subtotal, PercentOfTotal, and GrandTotal functions.  I find these functions particularly useful in adding context to ToolTips or Pivot tables. In this challenge, you will explore the various types of subtotaling functions.  As you work through this challenge, think about the story the different

2024 Week 11 | Sigma: Can you find the Subtotal? Read More »