- 15
- 3 561
Data Katrina
United States
Приєднався 10 гру 2023
Welcome! I’m the leading expert on Sigma Computing, sharing insights and tips to help you master this powerful BI platform. As the author of a book on Sigma (Spreadsheets for Dummies), leader of the global Sigma User Meetup, and creator of weekly challenges for learning Sigma (Workout Wednesday), I’m passionate about making data accessible and impactful.
Whether you're just starting out or looking to sharpen your skills, you’ll find tutorials, demos, and practical advice tailored to your journey.
Whether you're just starting out or looking to sharpen your skills, you’ll find tutorials, demos, and practical advice tailored to your journey.
WOW2024 W49 Solution Video
In this week's Workout Wednesday challenge, learn how to create a highlight action in Sigma by coloring a selected item while graying out others. Follow along as we set up the functionality to distinguish and color a single value, customizing visual elements and applying actions to dynamically update charts and tables based on user selection.
00:00 Introduction to the Highlight Action Challenge
00:18 Setting Up Sales Analysis
00:37 Creating Visualizations: Bar and Line Charts
02:51 Building a Pivot Table
03:27 Implementing Highlight Actions
04:48 Customizing Colors and Sort Order
08:44 Testing and Final Adjustments
14:29 Conclusion
00:00 Introduction to the Highlight Action Challenge
00:18 Setting Up Sales Analysis
00:37 Creating Visualizations: Bar and Line Charts
02:51 Building a Pivot Table
03:27 Implementing Highlight Actions
04:48 Customizing Colors and Sort Order
08:44 Testing and Final Adjustments
14:29 Conclusion
Переглядів: 117
Відео
What are Sigma Input Tables?
Переглядів 112Місяць тому
A simple introduction to Input Tables in Sigma Computing. Learn how Input tables act like a spreadsheet living inside your workbook and regular data workflow. 00:00 Introduction to Sigma Input Tables 00:30 Creating and Editing Empty Input Tables 04:29 Uploading and Modifying CSV Data 05:50 Using Linked Input Tables 09:27 Editing Permissions and Publishing 12:47 Conclusion and Future Videos
Can you fill the donut hole? | #WOW2024W23 Solution
Переглядів 1127 місяців тому
Join me, Katrina Menne, in Workout Wednesday Week 23 as I demonstrate how to create and customize a donut chart in Sigma. Follow along as I break down the process of visualizing customer data by gender, civil status, and loyalty program with Sigma's recent updates to the Donut Chart Element. Step 1: 0:00 - Introduction Step 2: 0:40 - Create the Donut Chart Step 3: 1:12 - Adding Customer Count S...
#WOW2024 W20 Sigma Computing Solution Video
Переглядів 1007 місяців тому
Join me for a detailed walkthrough of my Workout Wednesday challenge, creating quadrants on a scatter plot in Sigma. 00:00 Introduction to Workout Wednesday Challenge 00:10 Diving Into the Scatter Plot Challenge 00:31 Step-by-Step Guide to Building the Workbook 02:14 Creating and Analyzing the Scatter Plot 07:27 Final Touches and Conclusion
#WOW2024 W15 Sigma Computing Solution Video
Переглядів 1328 місяців тому
Welcome back to the Workout Wednesday series for Week 15! Today, we're diving into identifying the top and bottom five profitable customers and calculating the average for all others. This is a great challenge to test your level of detail calculation knowledge in Sigma. Let's dive in! Step 1: An overview of the challenge objectives - 0:00 Step 2: Getting set up - 0:26 Step 3: Creating average p...
#WOW2024 W12 Sigma Computing Solution Video
Переглядів 2059 місяців тому
In this blog, we'll solve the @workoutwednesday5713 W12 @SigmaComputing Challenge. Workbook Actions are a great way to increase the functionality and flexibility of your analytics. With Actions, we can change what a user sees, how they see it, and the level of detail in our analysis. Let's dive in! Step 1: An overview of the challenge objectives - 0:22 Step 2: Getting the data ready - 0:44 Step...
#WOW2024 W5 Sigma Computing Solution Video
Переглядів 1669 місяців тому
This video will delve into the solution video for the WOW2024 W5 Sigma Computing Challenge. We've seen dynamic texts in other challenges, but this week combines the power of Table Summaries, think grand and overall data set calculations, and Sigma's easy-to-create dynamic options. Let's dive in! Step 1: Add a new Table Element - 0:25 Step 2: Understanding Table Summaries - 0:50 Step 3: Add Open...
S.C.B.P. - Data Modeling with Pit Stop Tables in Sigma Computing
Переглядів 18310 місяців тому
Tune in with me, Katrina Menne, your @SigmaComputing and data visualization expert, as we delve into workbook modeling best practices with Pit Stop tables. Learn what pitstop tables are, why you should create them, when you have to utilize them, and how to future-proof your workbooks. In this Sigma Computing Best Practices session, I will explain the basic structure of Sigma workbooks and the i...
How to Create Actions in Sigma Computing
Переглядів 79310 місяців тому
Learn how to create Actions in Sigma Computing, why you should use them, and common Action scenarios. 00:00 Introduction to Sigma Computing Actions 00:17 Getting Started with Workbook Actions 01:56 Exploring the Types of Actions in Sigma 05:13 Example 1: Updating Control Elements 08:05 Example 2: Moving Fields and Modifying Elements 12:50 Example 3: Column Visibility 14:27 Conclusion: The Power...
#WOW2024 W4 Sigma Computing Solution Video
Переглядів 14410 місяців тому
This blog post will delve into the solution video for the WOW2024 W4 Sigma Computing Challenge. This challenge covers one of my favorite features in Sigma, the KPI element. It is so easy to use and create meaningful insights. Let's dive in! Step 1: Add a new Table Element - 0:20 Step 2: Create KPI - 1:03 Step 3: Add Profit to Value - 1:29 Step 4: Add Date to Timeline - 1:42 Step 5: Filter to la...
#WOW2024 W8 Sigma Computing Solution Video
Переглядів 12610 місяців тому
This video is the solution video for the WOW2024 W8 Sigma Computing @workoutwednesday5713 . This challenge shows two different ways to customize the tooltip. One solution removes information, and the other adds information. Customizing tooltips is a great way to avoid cluttering visualizations while still providing meaningful information. Let's dive in! Step 1: Add a new Table Element - 0:20 St...
#WOW2024 W3 Sigma Computing Solution Video
Переглядів 27911 місяців тому
Video Solution for Workout Wednesday 2024 Week 3 | Sigma: Can you choose the right value? Link to challenge: workout-wednesday.com/2024-week-3-sigma-can-you-choose-the-right-value/ Link to full blog and clarifications: www.katrinamenne.com/post/wow-2024-week-3-sigma-solution Step 1: Add a new Table Element -1:30 Step 2: Create a child visualization or bar chart - 2:15 Step 3: Build the dynamic ...
#WOW2024 W2 Sigma Computing Solution Video
Переглядів 19911 місяців тому
Workout Wednesday 2024 Week 2 | Sigma: Can you recreate this drillable bar chart? Link to Challenge: workout-wednesday.com/2024-week2-sigma-drillable-bar-chart/ In this week's challenge, we look at how to create a drill-down control element that allows users to decide the level of granularity for a bar chart. In creating this solution, we also cover what is a Metric in Sigma, different ways to ...
#WOW2024 W1 Sigma Computing Solution Video
Переглядів 362Рік тому
How to complete the Workout Wednesday Week 1 Sigma Computing Challenge.
How to Register & Get Started with Sigma Workout Wednesday
Переглядів 532Рік тому
A walkthrough of registering and starting with Sigma Computing Workout Wednesday (WOW) challenges. WOW are bite-sized weekly challenges designed to help learn data analytics platforms like Sigma Computing.
Thank you
Thank you.
I am looking for training on Sigma Training
thank you
Do you provide training? with certification
Not at the moment! Sigma posts training options here: community.sigmacomputing.com/
Hi! Can you also do this on dates? Like Year>month>day then will go back to Year(default)
Hi! I think you could, but it'd be a really complicated solution because the default "unclick" option is basically the previous option. So it'd be hard to go from day back up to year all within the same bar chart. Right now, a drill-down control would be the best option: help.sigmacomputing.com/docs/drill-down-control. You could also combine some actions with other control elements to mimic the same functionality. Check out WOW Week 7 for dynamic date selectors: workout-wednesday.com/2024-week-7-sigma-can-you-recreate-this-line-graph/ This is the first round of actions, so I imagine future updates might make this easier!
Amazing. Thank you.
Thank you! Are we able to remove the underline?
Great question! The underline is only visible while you're editing the workbook. It helps identify what in your text element is a dynamic vs static text. The underline will go away when you publish (or preview the workbook). If you'd ever like to keep the underline, use the text format using the formula bar.
Thank you! Good job! I would love it, and it would be helpful if you explored the given topic more!
Thank you! I plan to make a part 2 when some updates are made that will expand action functionality.
THANK YOU
Glad you liked it!
@@Data_Katrina Please do more in formatting if possible
@@mustafaaltameemi4226 I'll add it to the list!