Content in this section aims to give you an idea of how Sigma can work for you, as well as teaching you some of its most high level concepts.
Your BI Team Wants You to Use Sigma — Now What?
By giving you access to Sigma, your BI team is empowering you to access your data directly, without the limitations of spreadsheets or the need to know programming skills. Unlike traditional BI tools, Sigma allows business domain experts, like you, to go beyond the dashboard to explore data on-demand.
This article will dive into how Sigma can help you achieve accurate, real-time data and insights to drive critical business decisions.
From Spreadsheets to Sigma: 5 Things to Know
If you're looking to transition from spreadsheets to Sigma, you are not alone! Sigma uses a spreadsheet-like interface, coupled with the power of SQL, to give you ultimate analytical access to your data.
This article covers the 5 most important things we think you should know if you are transitioning from spreadsheets to Sigma.
Workbook Analysis (New)
Are you ready to dive into ad hoc analysis and/or report building in Sigma Workbooks? Check out the following resources to get started.
Workbooks are Sigma's newest and most dynamic document type. They harness and extend the power of Sigma's original document types – worksheets and dashboards – in one central interface. They're designed to support both ad hoc data exploration and longterm complex reporting.
This article will introduce you to workbook basics and direct you to introductory resources.
This article will teach you the basics of creating your first workbook.
Workbooks support three element types: data elements, control elements, and UI elements.
This article will introduce you to the three element types and direct you to introductory resources for each.
Are you ready to dive into your own analysis in the Sigma worksheet? Check out the following resources to get started.
Worksheets are one of four available document types in Sigma, alongside workbooks (new), dashboards and datasets. If you plan to do ad hoc analysis or create visualizations for future dashboards, you can expect to find yourself working in worksheets often.
This article will introduce you to the basics of worksheets and their components.
As a Sigma user, you will create worksheets to structure and join your data, calculate formulas, filter down to the information your want, and build actionable visualizations for dashboards.
This article will teach you the basics of creating your first worksheet from a data source.
Working with Columns
Columns are central to every Sigma worksheet. When you create worksheets, you will likely structure and format your existing columns, create new column calculations, and sort and filter your data.
This article will teach you the basics of working with columns in Sigma worksheets.
Using Levels and Groups
Data in worksheets can be grouped into hierarchical levels based on common values. Unlike traditional spreadsheets, which have a flat representation of data, you are not dependent on pivot tables to calculate aggregate values or limited by pivot table level restrictions.
This article will teach you the basics grouping your data and how it can benefit your analysis.
Using the Formula Bar
The formula bar is central to calculating data in worksheets. Sigma has a large library of functions for you to work with, many of which will be familiar. Unlike traditional spreadsheets, Sigma calculates formulas at the column level rather than per cell.
This article will teach you how to use the formula to create calculations in Sigma.
Sigma supports a variety of visualizations for your reporting needs. All visualizations are initially created in worksheets, and all worksheets can contain multiple visualizations. After your visualizations are created, they can be added to dashboards.
This article will teach you how to build a basic visualization.
In Sigma, you can selectively share your analysis and facilitate collaboration with colleagues across your organization.
This article will teach you about content permissions in Sigma and how you can share your work.