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 Welcome to Week 34! Creating a histogram in Sigma is easy when you use the built-in Bin functions to divvy up your data. This week we’ll be creating a histogram using a two different Bin functions in Sigma and some controls to make the charts more dynamic! The formatting styles and colors in this …
Introduction Sigma is all about making data manipulations and explorations accessible to everyone! This week’s challenge might sound intimidating, extracting data from JSON, but Sigma makes it a breeze. Have fun!-Katrina Need access to Sigma? Click Here to Sign Up Link to WOW Sigma Instance Youtube Click here to Watch: How to Register & Get …
2024 Week 33 | Sigma: Can you find the safe to eat items? Read More
Introduction Welcome to Week Thirty-Two! This week, we’re going to highlight one of Sigma’s latest enhancements to Actions. In this challenge, you’ll add actions to controls to show or hide columns in visualizations based on the column names selected in the control. This new action gives users more control over the data they want to …
2024 Week 32 | Sigma: Can you pick the right columns? 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 This week’s challenge was inspired by a lively discussion I was a part of, covering what date calculations a data analyst should or should not know. We’ve already covered several common ones, such as the current time period vs the prior time period. So this week, I wanted to add another to the list: …
2024 Week 30 | Sigma: Can you show partial or whole months? Read More
Introduction Welcome to Week 29! When dealing with time series data, sometimes we want to see how the data changes from period to period, specifically how it increases and decreases. Enter, the waterfall chart. Waterfall charts are a great way to see the journey of a value from start to end, and to see how …
2024 Week 29 | Sigma: Can you create a Waterfall Chart? Read More
Introduction Welcome to Week Twenty-Eight! Now that we are firmly in Summer Mode, let’s plan a lake vacation! This week, we’re going to evaluate water quality monitoring data in the Great Lakes. The dataset we’re using comes from Data.Gov. This dataset has many different characteristics measured in one long table. Don’t worry. I’ve already created a Sigma …
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 Welcome to Week 26! When we dive into monthly data, it’s often more helpful to predict the current month’s numbers rather than relying on incomplete data for an incomplete month. This week, we’re trying out three different ways to estimate sales projections for the ongoing month, also known as the run rate. Dealing with …
