Introduction Welcome to Week 22! This week we’ll be using the food truck data set again. We’ll use Input tables to set profit goals, and get a powerful view of how our actual sales perform against our goals! If you need a refresher on input tables, revisit week 6’s challenge, or read up on them …
2024 Week 22 | Sigma: Can you add custom Sales Goals? Read More »
Introduction This week, I was inspired by a post in the Sigma Community from Mark Ruesink that showed a really clever way to visualize outliers in Sigma using a combo chart and some clever calculations. Mark goes all the way to visualizing outliers, so I definitely recommend checking out his full post, but I wanted …
2024 Week 21 | Sigma: Can you set some boundaries? Read More »
Introduction Week 20 already! Crazy how fast the year is going by…and how fast you’re skilling up in Sigma! I love scatter plots. They’re a great way to display a lot of information in an easily consumable package. Layering quadrant colors on top, make it even easier to visually group dots and find outliers. -Katrina …
Introduction After last week’s awesome product launch, I was thinking about some of the Sigma features that we have not yet highlighted in Workout Wednesday. One of those is Custom Functions, and while the ability to create Custom Functions is currently reserved for admins, it’s a great feature for users to be aware about when …
Introduction Welcome to Week 18! This week we’ll be consolidating menu item data and sales data from Sigma’s sample food trucks database using a powerful tool – Joins! We’ll use both Joins and Lookups to get a feel of the difference between the two. The formatting styles and colors in this challenge are all up …
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 »
Introduction My past few challenges have been quite heavy on the formatting. Today I wanted to take a break from challenging you to format your workbooks, to showing you a powerful feature in Sigma that I don’t see used as often as I think it should be. Trellising! If you’re not familiar with trellising, it …
Introduction This week, we’re building a staple in my bar chart library: Top, Bottom, and Other Values. I often use this bar chart to easily show the breadth of the outliers while not losing sight of the typical. This challenge is also a great example of the flexibility of modeling at different levels of granularity …
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 »
Introduction We’re deep in the March Madness tournament, so what better way to celebrate than by digging into some NCAA data? This weeks challenge is one that shows a creative way of comparing two entities based on similar stats. I’m actually not sure if there’s a better way of handling this challenge, so I would …
2024 Week 13 | Sigma: Can you compare two teams? Read More »
