Reporting and BI
Sigma - the practical guide.
Sigma is a cloud BI platform that puts a familiar spreadsheet interface on top of the data warehouse. Founded in 2014, it lets analysts and business users explore Snowflake, BigQuery, Databricks or Redshift data with the same tactile, formula-driven feel as Excel - no SQL required - while keeping queries pushed down to the warehouse so governance and scale stay intact.
What Sigma does
The core combines spreadsheet-style worksheets, pivot tables, charts and dashboards with row-level security, lineage and version control on top of cloud data warehouses. Users build in workbooks (similar to Excel files), with each table, chart and input element wired to live warehouse queries. Input tables let business users add commentary, forecasts or scenario inputs back to the warehouse without engineering involvement.
Recent releases have leaned into AI assistance for query authoring, embedded analytics for SaaS products and a writeback feature that turns dashboards into lightweight data apps. Native warehouse support covers Snowflake, BigQuery, Databricks, Redshift and Postgres, with deep federated joins and incremental query optimisation.
Who it's for
Mid-market and enterprise teams already on a cloud data warehouse who want to put governed self-service analytics in front of business users without retraining everyone in SQL or BI-specific languages. Particularly strong for finance, operations and revenue teams that live in spreadsheets but need warehouse scale and governance.
Pricing, in rough terms
Quote-based, with editor and viewer seat tiers and usage-based warehouse compute (paid through your warehouse vendor). Editor seats typically run in the low hundreds per user per month; viewers are cheaper or sometimes unlimited at higher tiers. There's a 14-day free trial, no permanent free plan.
When Sigma is the right fit
The right call when the warehouse is the source of truth, business users would actually adopt a spreadsheet-like tool, and Tableau or Looker feel too analyst-flavoured. Also a strong fit for embedded analytics inside a SaaS product. A weaker fit for organisations without a cloud warehouse (Sigma is warehouse-native by design), early-stage startups on a budget, or teams that need rich, exploratory data visualisation (Tableau still wins).
Watch-outs
Warehouse compute costs are a real line item - poorly written workbooks can rack up Snowflake bills fast, so set query monitoring and cost guardrails early. The spreadsheet metaphor is approachable but governance is only as good as the discipline behind workbook ownership and permissions. Implementation goes faster with a partner if your warehouse data model isn't already analytics-ready.