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 …
Introduction Welcome to Week Twenty-Five! This week, you’re going to compare US Census data from 2000 and 2010. In this challenge, we’ll highlight a couple of new formatting additions to Sigma, as well as create a dynamic parameter. Good Luck!-Ashley Need access to Sigma? Click Here to Sign Up Link to WOW Sigma Instance Youtube …
2024 Week 25 | Sigma: Can you compare these populations? 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 As workbook builders we need to be thoughtful when deciding which visualizations to use in all sorts of scenarios. A good rule of thumb to help decide is looking for visualizations that provide high amounts of information to a low pixel or space ratio. This week we’re choosing to fill the donut chart to …
2024 Week 23 | Sigma: Can you fill the donut hole? Read More
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
