Tips & Tricks

Levels: Unlocking the Power of Sigma

Sigma makes cloud analytics as approachable as a spreadsheet and as powerful and expressive as SQL, and levels are the key.

Tips & Tricks

Calculate a Moving Average

A Moving Average is a function that is often used to filter out the noise of random price fluctuations and get a better idea of the trend. Learn how to quickly calculate one!

Tips & Tricks

Assign Your Data to Categories

Sometimes you need to group your data into categories that are specific to your organization and the analysis you need to do. We make it easy with the functions BinRange and Choose.

Tips & Tricks

Find Latest Weekday and Previous Weekday

There are times when you need to adjust the a column of dates to fit specific conditions. Finding the most recent or previous weekday is one common case.

Tips & Tricks

Perform a Cohort Analysis

Breaking users into cohorts gives insights into consumer behavior that are otherwise hidden in the larger picture. Dividing users into categories on Sigma is a straightforward process that will give you new power when looking at your data.

Tips & Tricks

Calculate Time Between Sales

Time between two sales is a useful number that can be used to tease out additional data about your customers. It’s a number often used when Creating Cohorts, and a common KPI to track.

Tips & Tricks

Year Over Year Numbers by Month

Year over year data viewed by month can give us insights on how our business is doing while taking into account seasonality. In Sigma, you can calculate your data in just a few steps!

Tips & Tricks

Calculate Week Over Week Numbers

Once you calculate your weekly numbers, calculating week over week numbers become very simple when using the Lag or Lead functions.

Ready to Speak Sigma?