FeaturedUdemy
Calculations in Sigma
4.9(162)846 studentsBEGINNEREnglish
Korshub's take
The Korshub Take
This beginner course equips analytics professionals with the skills to author dynamic, enterprise-grade calculations directly within Sigma. Covering single-row logic, conditional aggregations, window functions, and period-over-period performance metrics, you will learn to transform raw data tables into insightful business metrics using Sigma\'s spreadsheet-native interface.
Who It\'s For
Business analysts, data analysts, and BI specialists who want to leverage Sigma for cloud data warehouse calculations and dynamic reporting.
Key Takeaways
- Conditional Logic: Implement single-row conditional evaluation using IF and SWITCH functions.
- Conditional Aggregations: Calculate targeted metrics across subsets of data using functions like SUMIF and AVGIF.
- Window & Period Analysis: Perform rolling calculations, cumulative totals, and period-over-period performance comparisons.
- Dataset Enrichment: Merge related tables using Sigma\'s Lookup modal while mastering data types and syntax rules.
About this course
Boost your analytics skills with the Calculations in Sigma course. You’ll learn to create dynamic, business-ready calculations that help teams explore data, automate logic, and surface meaningful trends. We’ll cover single-row logic with IF and SWITCH, conditional aggregations like SUMIF and AVGIF, rolling and cumulative analysis using window functions, and period-over-period comparisons to track performance over time.
You’ll also learn how to enrich datasets using Sigma’s Lookup modal and understand how Sigma handles data types, grouped tables, and syntax. By the end, you’ll be ready to build accurate, efficient calculations and apply them to real business scenarios in Sigma.
Advertisement