Skip to main content
HomeBusiness Intelligence

Course

Calculations in Sigma

BasicSkill Level
4.8+
98 reviews
Updated 12/2025
Build dynamic Sigma calculations to explore data, automate logic, and uncover trends with practical business examples.
Start Course for Free
SigmaData Manipulation2 hr12 videos36 Exercises2,750 XPStatement of Accomplishment

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Loved by learners at thousands of companies

Group

Training 2 or more people?

Try DataCamp for Business

Course Description

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.

Prerequisites

Introduction to Sigma
1

Foundations of Sigma Calculations

This chapter introduces the core building blocks that make Sigma calculations accurate and dependable. You’ll learn how syntax cues, data types, and logical expressions shape the results you compute. Then you’ll progress from IF and SWITCH logic to conditional aggregations and window functions to build calculations that answer real business questions.
Start Chapter
2

Period-Over-Period Analysis

This chapter focuses on how Sigma streamlines period-over-period analysis for real business reporting. You’ll learn how to set up valid date fields, choose the right time granularity, and use Sigma’s automated MoM, QoQ, and YoY comparison tools. You’ll then expand into flexible techniques like DateLookBack and InDateRange to support rolling windows and custom time periods.
Start Chapter
3

Enriching Data with Lookups

This chapter explores how Sigma’s Lookup tools let you enrich tables by bringing in data from other sources without writing SQL. You’ll learn when to use lookups instead of joins, how to configure them correctly, and how to return aggregated values through the Lookup wizard. You’ll also learn to troubleshoot multiple-match issues and perform multi-key lookups for complex datasets.
Start Chapter
Calculations in Sigma
Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
Enroll Now

Don’t just take our word for it

*4.8
from 98 reviews
92%
6%
2%
0%
0%
  • Dawn Elizabeth
    9 hours ago

    Great exercise. Thank you

  • Pranjali
    yesterday

  • Kevin
    4 days ago

  • Nandhini
    4 days ago

  • Rupesh Kumar
    4 days ago

  • Asairi Carlos
    4 days ago

"Great exercise. Thank you"

Dawn Elizabeth

Pranjali

Kevin

FAQs

Do I need any prior experience with Sigma to take this course?

Although this course is designed for beginners and guides you through creating and customizing visualizations step-by-step, we recommend you take the Introduction to Sigma DataCamp course first.

What types of calculations will I learn in this course?

You’ll learn a wide range of calculations, including If, Then, Else statements, Lookup columns, Switch, Window functions, and period-over-period comparisons

Is any coding required to complete this course?

No coding is required. All skills taught in the course are hands-on, practical, and use Sigma’s no-code interface.

Do I need to have Sigma installed/have an active Sigma subscription?

You don't need to install anything; the whole course runs in your browser, including an interactive virtual machine that runs Sigma.

Join over 19 million learners and start Calculations in Sigma today!

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Grow your data skills with DataCamp for Mobile

Make progress on the go with our mobile courses and daily 5-minute coding challenges.