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 »
Sigma, Workout Wednesday
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
2024 Week 31 | Sigma: Can you set Image Links? Read More »
Sigma, Workout Wednesday
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 »
Sigma, Workout Wednesday
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 »
Sigma, Workout Wednesday
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 »
Sigma, Workout Wednesday
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
2024 Week 19 | Sigma: Can you clean a string? Read More »
Sigma, Workout Wednesday
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
2024 Week 16 | Sigma: Can you create a trellis? Read More »
Sigma, Workout Wednesday
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 »
Sigma, Workout Wednesday
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 »
Sigma, Workout Wednesday
Introduction This week’s challenge features *secret messages*! It’s not a flashy visual, but it showcases two important features of Sigma that any developer *must* know: Input Tables and Row Level Security. Input Tables allow Sigma users to interact with the data warehouse directly by manipulating tables at the cell-level in Sigma. These input tables can
2024 Week 6 | Sigma: Can you keep a secret with Row Level Security? Read More »
Sigma, Workout Wednesday