Dashboard Templates: An Overview

Sigma offers a variety of templates to create presentation-ready dashboards. For each given use case, templates can eliminate the need for your team to model data, build new reports, and create visualizations. Instead, Sigma generates all of these directly from your connection in seconds.

When you create a new dashboard from a template, Sigma will automatically create any associated Datasets, worksheets, and visualizations necessary to create the Dashboard. You will be the owner of this generated content and can edit it to customize the dashboard at any time. You may choose to use your template generated dashboards simply for out of the box quick insights OR you can build on them for a more customized experience. 

Summary of Content

Requirements
Available Template Types
      Sales and Marketing Templates
      Snowflake Usage Templates
      Lacework SecOps Template
      Global Impact of COVID-19 Template
Template Usage Overview
Related Resources

Requirements

  • Templates are only available for use by organization Admins. 
  • Additional requirements may exist on a per-template type basis. Please refer to the individual template’s documentation for specific requirements.

Available Template Types

Sales and Marketing Templates

Use the following templates to jump right into focused analysis of your team’s Salesforce data. Get Started

  • Salesforce Opportunity Overview - tracks key accounts, open opportunities, sales representatives, amounts, close dates, stages, and next steps at a glance.

  • Salesforce Sales Performance - displays a holistic overview of sales health metrics by deal type, stage, team, and sales representative.

  • Salesforce Campaign Performance - tracks campaign performance analysis by lead type, effectiveness, pipeline, and opportunities.

Snowflake Usage Templates

Sigma provides three Snowflake Usage Dashboard templates. These templates use your Snowflake warehouse’s Account Usage data. Get Started

  • Snowflake Compute Cost - tracks cost by warehouse over time

  • Snowflake User Adoption - tracks how users are using warehouses and databases

  • Snowflake Performance Monitoring - tracks database, warehouse, and individual query performance

  • Snowflake Storage Cost - tracks storage cost by database and over time.

Lacework SecOps Template

Lacework is a cloud security solution used to monitor AWS, GCP and Azure. Use this template to analyze Lacework Sharehouse data stored in your Snowflake warehouse. Get Started

Global Impact of COVID-19 Template

Sigma’s COVID-19 template creates a dashboard displaying the global impact of COVID-19. It uses the Starschema COVID-19 Epidemiological Data available from Snowflake’s Marketplace. Get Started

Template Usage Overview

The following instructions are intended for the purpose of providing a general overview of template usage. For more detailed instructions, visit our documentation associated with your select template type.

  1. Before you can use a template, you must get your data into Sigma via a warehouse connection. This process varies depending on the template type. Please visit our template-specific documentation to learn more. 

  2. Once the appropriate data is available in Sigma, navigate to your Sigma Home Page.

  3. Under DASHBOARD TEMPLATES, select your desired template. This will open the Create a Dashboard from a Template modal. 

  4. First, you will need to select your data source to be used by the template. By default, Sigma will attempt to select the appropriate data source.
    If one more data source options are found, you will see the screen pictured below. Select your source and a location for your new dashboard. Then click 'Create'. 
    Please note: If Sigma is unable to match a source to your selected template, you will be directed to manually select your source(s) from the Advanced Table Mapping View.  
    Screen_Shot_2020-11-25_at_3.59.15_PM.png

  5. The remaining steps will walk you through the process of selecting data sources by means of the Advanced Table Mapping View.
    First, select your desired connection and source tables from the provided lists    . 
    Screen_Shot_2020-11-06_at_12.46.44_PM.png

  6. Click Next to continue.

  7. Now it is time to select a destination for your new Dashboard and its sources.
    Select an existing folder or use the Create Folder button to create a new one. If you create a new folder, don’t forget to name and open it before continuing.
    Screen_Shot_2020-11-06_at_12.50.42_PM.png

  8. Click Add.
    From here you will be routed directly to your new dashboard!

Related Resources

Salesforce Sales and Marketing Templates
Snowflake Usage Templates
Lacework Dashboard Templates
Global COVID-19 Template