Introduction This week, I wanted to challenge myself to do something I didn’t know how to do in Sigma, I wanted to start laying the groundwork to do sensitivity analysis. I’ve often thought this would be possible in Sigma, since we can connect to Snowflake User-Defined Functions (UDFs) via Sigma’s function bar to call models …
2024 Week 39 | Sigma: Can you test out changes in cost? Read More
Introduction Have I expressed my deep appreciation for Input Tables? With Snowflake or Databricks, we can write back to the database, which allows for some great methods of simplifying getting user-maintained information into a database. Even though I am a big fan of input tables, it’s still risky to allow users to edit a database …
2024 Week 35 | Sigma: Can you create a support request form? Read More
Introduction I’ve always appreciated when developers take the time to incorporate images into their visualizations, whether it’s as simple as adding an up arrow / down arrow to denote positive or negative trends, or going all the way to showing a business’s/team’s logo when referring to them in a table. This week, I wanted to …
Introduction I’ve always liked tracking my personal finances, partly out of necessity (I was a freelance musician for nearly a decade and I needed to keep track of *every* expense). Even before I got into data, I appreciated seeing my personal finances visualized cleanly so I could answer questions like ‘Did I spend too much …
2024 Week 27 | Sigma: Can you create a Cashflow Chart? Read More
Introduction A few weeks ago, the 19th Police District of Chicago emailed me with some interesting survey data. The visualizations were useful, but they were living inside of a Google Slides presentation, and I wanted to dig deeper into the results. Thankfully, I followed my nose to their community survey website and found that they …
2024 Week 24 | Sigma: Can you add custom map layers? 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 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 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 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 …
Introduction This week’s challenge is going to be longer than usual, mostly because I wanted to showcase dark mode along with a combo chart. If you’re not familiar with what a combo chart is, it can represent multiple columns using different shapes. Bars, lines, areas, and points are all fair game in a combo chart, …
2024 Week 10 | Sigma: Can you recreate this combo chart? Read More
