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 …
Introduction Welcome to Week Seventeen! This week, you’re going to perform a Cohort Analysis of food truck customers based on when they placed their first order. Conditional formatting will help highlight which cohorts have a greater percentage of customers in them. As a bonus, you will implement a dynamic page control input to let the …
2024 Week 17 | Sigma: Can you Cohort These Customers? Read More »
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 …
Introduction This week, we’re building a staple in my bar chart library: Top, Bottom, and Other Values. I often use this bar chart to easily show the breadth of the outliers while not losing sight of the typical. This challenge is also a great example of the flexibility of modeling at different levels of granularity …
Introduction Welcome to Week Fourteen! This week, you’re going to learn about Sigma’s Lookup function. Lookups are very useful for joining information from one data source to another, without accidentally fanning your data. Sigma also has a Lookup Wizard for a foolproof way of utilizing this function. When I book a flight, I am particularly concerned …
2024 Week 14 | Sigma: It’s a Bird… It’s a Plane… It’s Lookup Functions! Read More »
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 »
Introduction For this week’s challenge, we’re exploring Sigma’s workbook actions, a powerful feature that enables better end-user experiences, nuanced data exploration, and more impactful presentations. Sigma’s workbook actions cover a wide range of interactions, but for this first challenge, we’ll focus on two common action scenarios: clicking to filter and clicking to change. As you …
Introduction Welcome to Week Eleven! This week, you’re going to learn about Sigma’s Subtotal, PercentOfTotal, and GrandTotal functions. I find these functions particularly useful in adding context to ToolTips or Pivot tables. In this challenge, you will explore the various types of subtotaling functions. As you work through this challenge, think about the story the different …
2024 Week 11 | Sigma: Can you find the Subtotal? Read More »
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 »
Introduction This week have a guest author! Tausif Kazi is an expert in data visualization who is experienced in several platforms such as Sigma, Power BI, Tableau, and Snowflake. Connect with Tausif:Linkedin: https://www.linkedin.com/in/tausifkazi/Twitter: https://twitter.com/VizByTK This challenge will cover how to create a Bar chart in Pivot Tables. This will help your users quickly understand the …
2024 Week 9 | Sigma: Can you create Bar charts in this Pivot Table? Read More »
