Dig in to how Sigma optimizes analysis.
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!
Once you calculate your weekly numbers, calculating week over week numbers become very simple when using the Lag or Lead functions.
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.
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.
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.
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.
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!
Sigma makes cloud analytics as approachable as a spreadsheet and as powerful and expressive as SQL, and levels are the key.