Sigma Computing has recently been making waves in the data analytics community for its lightning-fast analytics, collaboration with the Snowflake Data Cloud, and its innovative cloud-based spreadsheet-like design.
But under the hood, what is this analytics platform truly capable of?
Whether you’re just getting started in your analytics journey, interested in switching analytics platforms, or simply curious about Sigma, this guide has everything you need to know about Sigma Computing including:
What areas of the BI world Sigma covers
What makes it different from other BI platforms
Who would benefit the most from Sigma
Example use cases
What is Sigma Computing?
Sigma Computing is a cloud-based Business Intelligence (BI) platform primarily used for data exploration and visualization. Sigma was designed to increase speed to insights by utilizing Snowflake’s lightning fast computing power coupled with the familiarity of spreadsheets.
Sigma offers code free and code friendly data manipulation and visualization, making it easy for customers to slice and dice data in every conceivable combination.
What Can You Do With Sigma?
Sigma is primarily made up of two different components: Data Modeling and Data Analysis.
Data Modeling in Sigma
Users begin by creating connections to their Snowflake (or other databases) tables. Sigma provides an intuitive, spreadsheet-like interface, that easily and clearly allows users to join and enrich their data.
A unique feature to Sigma is the ability to create data links right in the platform. A link is similar to a v-lookup from Excel or left/right join in SQL. This functionality allows data engineers to create connections between any number of data sources without creating bloat in the dataset itself.
Other users can then add new columns based on the link at the data source or workbook (analysis) level. This frees up the engineers from data addition requests and allows users to create unique datasets meaningful to their needs.
Data Analysis and Visualization in Sigma
Once a dataset is created, users interact with it in workbooks. Sigma Workbooks are similar to other platforms’ concepts of workbooks: collections of sheets or dashboard tabs. Each tab can contain different data building blocks called Elements. An element can be a data source, such as a table, or a data visualization like a bar or line chart.
You can also add UI or control elements to your workbooks, like a text box to provide additional context or a date control to allow users to filter their data.
Sigma’s built-in elements such as KPIs, pivot tables, filters, and simple chart types make it easy for anyone to create meaningful data insights. Users can also easily add new calculations to any type of data element. Anyone who has ever used Excel will be familiar with the function writing process.
How is Sigma Different from Other BI Platforms?
With so many business intelligence platforms out there, it can be hard to find the right one for your business. Although most platforms have overlapping features and functionality, Sigma’s fresh approach to analytics has distinguished itself in three key areas: Ease of Use, Speed, and Data Distribution. Let’s look more closely at these unique features.
Ease of Use
Once a dataset is created, users interact with it in workbooks. Sigma Workbooks are similar to other platforms’ concepts of workbooks: collections of sheets or dashboard tabs. Each tab can contain different data building blocks called Elements. An element can be a data source, such as a table, or a data visualization like a bar or line chart.
You can also add UI or control elements to your workbooks, like a text box to provide additional context or a date control to allow users to filter their data.
Sigma’s built-in elements such as KPIs, pivot tables, filters, and simple chart types make it easy for anyone to create meaningful data insights. Users can also easily add new calculations to any type of data element. Anyone who has ever used Excel will be familiar with the function writing process.
Speed
Sigma Computing is the only BI tool built explicitly for the Snowflake platform. This allows teams to truly unlock every ounce of speed and power provided by Snowflake. The live connections with Snowflake allow users to run queries on terabytes of data without having to worry about latency issues.
For example, Sigma coupled with Snowflake’s auto-scaling features allows everyone in your organization to access and interact with the same live dashboards with virtually no lag.
With Sigma and Snowflake, you can read from, create from scratch, or update tables in your database within seconds instead of hours or days. This capability enables organizations to move from batch-oriented reporting to an interactive query model.
Data Distribution
Sigma enables engineers, analysts, and decision makers with greater access and control over the entire data analysis process. Sigma’s collaborative features enable you to share reports with other team members for review, comment, and editing at any stage in the process.
Users can quickly share results with colleagues or bring them into the workflow so they can help improve reports and dashboards. Sigma makes it easy for everyone to understand what has changed, what needs to change, and how to implement the next steps. At the same time, Sigma provides helpful security constraints through default and custom account types.
What Are Some Use Cases of Sigma?
Sigma is an ideal solution for anyone looking to increase data literacy in their organization. Sigma helps people go from being intimidated by data to being empowered by it through interactive visualizations.
Whether you’re looking to increase sales, improve customer experience, bolster marketing, or develop stronger relationships with vendors, Sigma can help connect you to new insights about your business.
Here are some common questions Sigma can help resolve:
“What Data is Available?”
Sigma thrives in an environment where the data is unknown, unruly, or requires heavy manipulation. Its flexible and intuitive cloud-native solution offers a new approach to business intelligence and analytics, enabling users to explore and analyze all of their data without moving it or modeling it ahead of time.
Sigma’s column detail feature provides a comprehensive summary of the data’s structure, contents, and composition. Once the data has been demystified, Sigma allows users to prototype new data connections and models to determine the best solution.
“Show Me the Numbers”
Sigma allows for technical and non-technical roles to investigate row level details and create ad hoc analysis—helping everyone understand trends in driving factors and identifying outliers. This adaptability means self-service analytics is truly unlocked for all areas of the business.
At the same time, Sigma’s web-based platform makes it simple for admins to verify and control access to different parts of an organization’s data. BI teams can create endorsed and reusable analysis to help prevent duplicate work and ensure that everyone on the team is working off of the same facts.
“ASAP”
Time is money in organizations and data management and analysis is no exception. Because Sigma offers multiple steps of the data journey, it helps every area of data run faster and smoother. Sigma’s live connection to Snowflake ensures all data is as up to date as possible.
With workbook sharing, all areas of the business can know in real time how to respond to wins and losses. And if the workbook doesn’t answer a question, users are free to pivot and drill into the underlying data themselves.
Conclusion
No organization can function without some sort of spreadsheet-based platform. Because spreadsheets are so crucial to our businesses, it is important to have the best possible version of the tool. Sigma seamlessly combines data preparation and modern data visualizations into a comprehensive data analysis platform.
Sigma’s ethos of transforming ordinary data into something new and purposeful through intuitive interface and accessible features are sure to unlock any answers hidden in your business’ data.
Now that you’ve read our introductory guide on Sigma, we invite you to explore our two most requested Sigma resources: