Sigma workbooks are data exploration tools for both Business Intelligence (BI) developers and spreadsheet-savvy analysts. Workbooks are similar to spreadsheets in that they have pages and display data in tables and pivot tables. Workbooks are similar to BI tools in that they provide dashboard-like displays that can include charts, graphs, controls, tables, texts, and images. You analyze your data and create visualizations on workbook pages, and use a page as a dashboard.
Workbooks enable both ad hoc data exploration and complex BI presentations and reporting. The collaborative interface and visual approach to data interaction in Sigma makes data accessible to everyone in your organization, and teams can draw insights from large amounts of data.
This document introduces you to workbooks and links to more resources.
Workbooks have three states: explore, draft, and publish.
When you create a workbook it is in an explore state until you actively save the first version. You can keep a workbook in the explore state and never save it. For example, you may need conduct ad hoc data exploration and analysis that is only needed in the current moment, and you don't want to clutter folders with one-off documents. Unsaved workbooks are called explorations and are available in the Recents page for 30 days.
Save a workbook for continuing your analysis and setting up reporting. If you decide to share your exploration with your colleagues, publish the workbook.
You can embed an entire workbook, a page, or an element in another application. See Workbook embedding: an overview
Workbooks can use data from multiple sources, including tables in a Cloud Data Warehouse (CDW) and your organization's Sigma datasets. Your data is always live, accessible at scale, and cannot be deleted or corrupted. For information about data sources see Connect to data sources
After Sigma connects to your data source, you can create workbooks directly from tables in your source, or you can model the data using a Sigma dataset. Use a dataset as the source for your workbooks to ensure consistency. For more information about data modeling, see: Data modeling with datasets and Data modeling tutorial.
When users access a Dataset or Workbook that has been shared with them, that document owner's permission to the source data is evaluated within Sigma and then the queries to the cloud data warehouse get run using the user account credentials that have been set in the connection's settings. The exception to this is if the connection is configured to use OAuth without a service account. In this case, the queries will run with the user's personal Snowflake OAuth credentials when they are viewing Datasets and Workbooks owned by others.
Sigma provides a variety of settings that affect the editing environment, formatting and theme, and page breaks for PDF exports. For more information see Workbook settings.
This section introduces you to the basic components of workbooks. The screenshots show a workbook in Edit mode.
A workbook contains one or more pages. Page tabs, located at the bottom of the screen, show different pages in the workbook.
Each page has a menu. When a workbook is in view mode, such as when it is provided to Viewers, it allows users to export (download) a page as a PDF file.
In edit mode, Creators have more options for pages, including delete, rename, hide, duplicate, and Add new page. For more information about hiding page see Hidden pages and controls in workbooks.
Each workbook page has a canvas on which you can place elements such as tables, pivot tables, text, controls, images, and visualizations.
The workbook editor panel, on the left side of the screen, allows you to interact with and update elements in your workbook.
When you select a new or existing element, the editor panel automatically displays that specific element’s configuration.
The editor panel content changes depending on how you are currently interacting with the workbook. For example, it displays one view when adding a new element and alternative views when configuring different element types.
Access to the editor panel depends on your workbook view mode.
You arrange elements on the page canvas. Element types include:
- Data elements (tables, visualizations, and pivot tables)
- UI elements (text, images, buttons, embeds, spacers, and dividers)
- Control elements (filters and parameters)
In workbooks, tables and pivot tables are not considered types of visualizations. Visualizations, tables, and pivot tables are separate elements in the data elements category.
For more information about elements see Intro to element types.
The toolbar, located directly under the workbook header, gives you quick access to select actions, formatting options, and the formula bar. The toolbar content changes depending on the element you have selected, and undo, redo, and page theming functions are always displayed.
When you select a column in a data element, you can view and edit the column's formula in the toolbar only if you have Can Edit or Can Explore access to the workbook. For more information see Folder and Document Permission.
If you previously used Sigma worksheets or dashboards, you may be familiar with the process of creating multiple worksheets to source visualizations for a single dashboard. Workbooks alleviate this workflow by allowing you to build your analysis exactly where it is displayed to your report consumers.
Updated 11 days ago
- Edit, draft, and publish a workbook
- Workbook modes overview: View, Explore, Edit
- Workbook lifecycle: explore, draft, and publish
- Create a workbook
- Intro to Element Types
- Intro to data elements
- Workbook example templates
- Fundamentals (QuickStart)
- What's Possible with Sigma Workbooks (Webinar)
- Questions and Answers on Workbooks and Visualizations (Community)