Introduction I felt like I was seeing more news about food recalls lately, and I did the thing any good data-minded individual would do: pulled down data from the FDA to see if what I’m feeling is backed up by data. When I pulled the data down from, I realized there was still a lot …
Introduction This week, I wanted to highlight Sigma’s actions once again, as we got a new update a last week: The ability to change date controls via actions! Pairing this new feature with the ‘Conditions’ beta feature in actions, we can create more user-friendly date filtering with much less hassle. Stay up to date on changes to …
2024 Week 43 | Sigma: Can you create a segmented date control? Read More
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 …
