Popular Features of Sigma Computing

Jan 12, 2025By Emma Lee
Emma Lee

Popular Features of Sigma Computing

Today’s business world relies heavily on tools that enable collaboration, insightful analysis, and robust data management. Sigma Computing has emerged as a leader in the business intelligence (BI) landscape, offering a cloud-native solution that caters to the dynamic needs of modern organisations. This blog explores the popular features of Sigma Computing and how they enhance productivity, collaboration, and decision-making.

1. Input Tables: Integrating External Data Sources

Sigma Computing allows users to create, edit, and reference data from external sources such as spreadsheets, databases, and APIs. However, the data itself resides in a cloud data warehouse, ensuring that everyone accesses the latest, most accurate information.

Benefits of Input Tables:

  • Centralised Data Access: All team members work with a single source of truth.
  • Real-Time Updates: Changes to the cloud data warehouse reflect instantly in Sigma.
  • Seamless Collaboration: Users can reference and modify data without worrying about outdated versions.

Example Use Case:
Imagine a sales team using Sigma to analyse customer data stored in a cloud warehouse. They can easily pull data from various external sources into an input table and create a unified view for comprehensive analysis.

2. Live Edit: Real-Time Collaboration

With Sigma’s Live Edit feature, teams can collaborate on workbook drafts in real-time. All editors share a live draft and can see each other’s changes instantly before publishing the final version.

Key Features:

  • Real-Time Visibility: Changes made by one team member are immediately visible to others.
  • Enhanced Teamwork: Encourages collaborative problem-solving and brainstorming.
  • Reduced Errors: Everyone works on the same draft that minimizes the risk of conflicting edits.

Example Use Case:

During a marketing campaign analysis, a team can simultaneously adjust data visualizations and metrics in a workbook draft, ensuring everyone’s input is reflected.

3. Lookups: Effortless Data Integration

Lookups in Sigma function similarly to Excel’s VLOOKUP, returning all rows from the current dataset and matching rows from the joined dataset. If multiple matches are found, Sigma indicates this with an asterisk (*).

Advantages of Lookups:

  • Simplified Data Enrichment: Combine datasets without adding unnecessary rows.
  • Ease of Use: Familiar functionality for Excel users.
  • Quick Identification: Highlights potential data mismatches or duplicates.

Example Use Case:

A financial analyst can use Lookups to enrich transaction records with customer information stored in another dataset, creating a comprehensive view for reporting.

4. Conditional Alerts: Smart Notifications

Sigma allows users to schedule exports as conditional alerts, ensuring that notifications are only sent when specific data conditions are met.

Benefits of Conditional Alerts:

  • Relevance: Receive notifications only when critical thresholds are crossed.
  • Time Savings: Avoid unnecessary alerts for non-critical updates.
  • Automated Monitoring: Sigma tracks conditions for you, reducing manual oversight.

Example Use Case:

An operations manager can set an alert to notify the team when inventory levels drop below a predefined threshold.

5. Pivot Tables: Advanced Data Summarization

Sigma’s pivot tables empower users to summarize and analyze data by plotting columns into rows, columns, and value fields. The feature supports various customizations, including filtering, formatting, and calculated columns.

Key Features:

  • Dynamic Grouping: Collapse or expand data groups.
  • Custom Formatting: Apply conditional formatting for better visualization.
  • Drill-Down Capability: Maximize tables to explore underlying data.

Example Use Case:

A product manager can use pivot tables to analyze sales performance across regions, drilling into specific areas for deeper insights.

6. Version Tagging: Seamless Version Control

Sigma’s version tagging allows users to tag published workbook versions, annotate changes, and switch between versions as needed. This feature is particularly useful for maintaining historical records and reverting to earlier versions if necessary.

Benefits:

  • Transparency: Clear documentation of changes made to workbooks.
  • Flexibility: Easy switching between versions.
  • Enhanced Collaboration: Teams can work on drafts without impacting published versions.

Example Use Case:

A data analyst can tag a workbook version before testing new formulas, ensuring a fallback option if changes don’t produce the desired results.

7. Drill Anywhere: On-Demand Data Exploration


Sigma’s Drill Anywhere feature allows users to perform ad-hoc drill-downs into data details directly from visualizations. By right-clicking on visual elements, users can select specific columns for deeper analysis.

Advantages:

  • Ad-Hoc Insights: Immediate access to underlying data without predefined filters.
  • Ease of Use: Intuitive right-click functionality.
  • Enhanced Analysis: Explore data at multiple granularity levels.

Example Use Case:

A supply chain analyst can drill into a bar chart to view detailed shipping delays by region.

8. Explore Mode: Safe Ad-Hoc Analysis


Explore Mode provides an isolated environment for users to customize published workbooks or perform ad-hoc analysis without affecting the original version.

Features:

  • Isolated Environment: Safeguards the original workbook.
  • Customizable: Tailor visualizations and metrics for specific needs.
  • Permission-Based Access: Ensures secure usage.

Example Use Case:

A business consultant can test new hypotheses on sales data without risking changes to the official report.

9. Intelligent Query Engine: Optimized Performance

Sigma’s Intelligent Query Engine leverages data warehouse query caching to improve performance. Users can set the cache’s time-to-live (TTL) to balance freshness and efficiency.

Benefits:

  • Faster Results: Cached queries reduce computation time.
  • Customizable TTL: Adjust cache duration to suit business needs.
  • Warehouse Integration: Leverages existing infrastructure for efficiency.

Example Use Case:

A financial team running daily profit margin reports benefits from cached queries, significantly reducing wait times.

10. Secure Embedding: Seamless Integration

Secure Embedding enables organizations to integrate Sigma content into other applications while maintaining security. This feature inherits the host application’s security controls, ensuring data integrity.

Steps for Secure Embedding:

  1. Generate client credentials.
  2. Create an embed user team.
  3. Share the workbook with the embed team.
  4. Implement the embed API on the host application.

Example Use Case:

A SaaS company can embed interactive dashboards into their platform for clients, providing real-time analytics while controlling access securely.

Sigma Computing stands out as a versatile and powerful BI tool. Its user-friendly features, robust security measures, and collaborative capabilities make it a valuable asset for any organization aiming to harness the power of data. By integrating these features into daily workflows, businesses can unlock new levels of efficiency and insight.