fbpx
Select Page

Sigma’s Datasets are a flexible way to build centralized data definitions and guide data exploration. Sigma balances administrative control with the freedom to find, add, and trust new data. There are two types of Datasets in Sigma: Worksheet based and SQL based. 

Specific kinds of Datasets have different functionality. However, all Datasets function as sources of data. 

One of the most powerful features of Datasets are Links. You can define the relationships between Datasets on the Relationships tab, setting up the join keys between the Datasets. Once a Link is defined, users will easily be able to add columns from the linked data sources to worksheets based on the Dataset. They can use Links to add data using a pre-defined join path and an intuitive UI. 

Types of Datasets

  • SQL Based
    • Use SQL to define the data within the Dataset
    • Materialize the results of your SQL back to the data warehouse as a table. This helps speed up query time and reduces compute. 
    • Create Relationships and Descriptions within Sigma
  • Worksheet Based
    • Turns a Sigma Worksheet into a Dataset. This designates the Dataset as a data source for users, sets up calculatations as a single source of truth, and allows users to materialize the data in the Worksheet. 
    • Materialize the results of your Worksheet back to the data warehouse as a table. This helps speed up query time and reduces compute. 
    • Create Relationships and Descriptions within Sigma

 

Add a Description

  1. Navigate to the overview page.
  2. Click ‘Edit’.
  3. Click to add a description.
  4. Hit ‘Publish’ to save the changes.

 

Format Columns

  1. Navigate to the overview page.
  2. Click ‘Edit’.
  3. Find the column that you would like to format, and click the arrow next to the column name to open the column menu.
  4. Choose the formatting option that you would like to apply.
  5. Hit ‘Publish’ to save the changes.

 

Add Column Descriptions

  1. Navigate to the overview page.
  2. Click ‘Edit’.
  3. Click ‘Columns’ to go to the column page.
  4. Click to add a description.
  5. Hit ‘Publish’ to save the changes.

 

Add a Badge

  1. Navigate to the overview page.
  2. Click the flag icon next to the name of the table.
  3. Choose which badge you would like to apply.
  4. If you would like to, you can add a note about the badge you are adding.
  5. Click add.

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.