Introduction Welcome to Week 46! This week we pretend to be a streaming service, trying to see which of our 3 new shows are doing well with the viewer base. Funnel charts will be our main focus here, but feel free to play around with the sample data to find other key insights! The formatting …
2024 Week 46 | Sigma: Can you create a Funnel Chart? Read More
Introduction Welcome to Week 42! This week we’ll look at an easy way to compare data year over year, whether we are using a line chart visualization or a pivot table to view our data. There are many ways to acheive similar results, this is just one! Feel free to play around with other ways …
2024 Week 42 | Sigma: Can you compare Year over Year Data? Read More
Introduction Welcome to Week 38! Sometimes there are events or notable data points that aren’t stored in your data, but you want to see how they effect the trends. Enter reference marks and conditional formatting! This week we practice using reference marks and conditional formatting to highlight specific dates and events. The formatting styles and …
2024 Week 38 | Sigma: Can you create reference marks? 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 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 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 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 Welcome to Week 18! This week we’ll be consolidating menu item data and sales data from Sigma’s sample food trucks database using a powerful tool – Joins! We’ll use both Joins and Lookups to get a feel of the difference between the two. The formatting styles and colors in this challenge are all up …
