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 …
2024 Week 15 | Sigma: Can you identify the top, average, and bottom profitable customers? Read More
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 …
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 …
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
Introduction A good data visualization strikes a balance between enough and too much information. For this week’s challenge, we will explore a couple of ways to customize tooltips. Customizing these can help provide users with meaningful information without overwhelming or crowding the visuals. I’m sure you’ll knock this one out of the park! Need access …
2024 Week 8 | Sigma: Can you customize this tooltip? Read More
Introduction Welcome to Week Seven! This week, you’re going to create a line graph that can change its date granularity. With a dynamic x-axis, this graph allows users to view trends at the level that makes sense for their current needs, without duplicating work. Also in this challenge, you’re going to learn how to show …
2024 Week 7 | Sigma: Can you recreate this Line Graph? Read More
