Native Cloud Data Warehouse Analytics & Business Intelligence Software
Empowering Self-Service Analytics with Sigma & Snowflake
From my perspective, the ROI is immediate because the onboarding is so fast, I can take a client who only knows Excel and have them building complex pivots in an afternoon. I’ve also been impressed by the AI/Intelligence features, specifically the AI Forecast and natural language formulas, which take the guesswork out of trend analysis. The biggest unexpected benefit has been Input Tables, which finally solved the problem of letting users comment on or update data without leaving the dashboard. It’s turned our static reports into truly interactive tools.
Easiest BI Tool: Live Snowflake Data in a Spreadsheet-Like Experience
Empowering sales teams has become effortless as collaborative dashboards compare rep performance
What is our primary use case?
My main use case for Sigma is to build dashboards for sales reps to compare their sales metrics to other sales reps. Along with that, I used it to access important data sets for the Business Intelligence team at Workato and make any changes to the data sets necessary.
One example of a dashboard I built is where sales reps would often have sales competitions where they would track the amount of leads contacted or the amount of successful sales within a certain time period in order to compete against one another. These dashboards are the most common use I have for Sigma, which are dashboards for the sales reps to compare their sales metrics to other sales reps.
I also used Sigma to look at the accounts and other databases that we had as a company. Using Sigma to create dashboards and visualize data was probably the most effective use case of Sigma.
In particular, creating dashboards and visualizations for leadership was made very easy and simple through Sigma. Being able to visualize data quickly and efficiently while also being connected to all of the Snowflake databases made things incredibly simple and easy for our company overall.
What is most valuable?
In my opinion, some of Sigma's best features are simple table manipulation, simple dashboard creation, and simple connections for manipulating data.
The ease of use of all of these features was definitely remarkable. One feature I forgot to mention was Sigma's support team. I struggled to figure out how to connect a couple pieces of data a few times, but after reaching out to Sigma support team, I was able to create a solution within minutes, thanks to all of their help. Without Sigma support team, I definitely would not have been able to do all the things that I did with Sigma. What made those features stand out was the ease of use and the flexibility of the various features within Sigma.
Sigma is valuable because you can do pretty much anything you need to do within Sigma. If you need to run a custom SQL query, you can do that. If you need to build a visualization of a data set really quickly, you can also do that. It is very easy to learn for new users, and it is very easy for people that do not have technical backgrounds to learn how to use as well.
What needs improvement?
I cannot remember specifics, but there were one or two times when I wanted to build something in a dashboard but Sigma would not let me compute the math in the way that I wanted to compute it. It felt like it was a little bit limited in ability because there were very specific functions and specific mathematical computations that Sigma allows you to do, and if you want to do something outside of that, it did not seem like it was possible. There was one time where even with a Sigma support agent, we could not figure out the most effective way to accomplish the task and run a query that we wanted to.
Expanding features and abilities and functions within Sigma could be one way to improve Sigma.
For how long have I used the solution?
I have been using Sigma for about six months while I was an intern at the company called Workato.
What do I think about the stability of the solution?
I felt that Sigma was stable.
What do I think about the scalability of the solution?
Our data sets were quite large, but I saw no visible impact while using Sigma. Sigma seemed to scale just fine with our large data sets and could handle anything we threw at it.
How are customer service and support?
The customer support is a 10 out of 10, hands down. The support staff are all professional users of the product itself and they are available almost 24/7 and helped me to come up with solutions to all of the problems that I had. Sigma support team is probably the best thing that Sigma has in my opinion.
I would rate the customer support 10 out of 10.
What was our ROI?
Unfortunately, as an intern, I cannot necessarily comment on return on investment. However, it definitely saved me time and reduced the need for more interns.
What other advice do I have?
Sigma definitely improved collaboration overall as an organization. The ability for RevOps, BI, and sales to all coordinate and collaborate on a project because of Sigma's impact was extraordinary in my opinion.
I rate Sigma an eight out of ten. I give it an eight because its ease of use and quick integration capabilities are what helped me. However, if it was able to do all of the computations and queries that I needed it to at the time, I would have given it a ten. Those last two points that kept it from being a ten are from the slightly limited ability of Sigma.
I would encourage others looking into using Sigma to use the support team whenever possible if there is something they did not know how to do within Sigma.
Instant Access and Customizable Dashboards
Self-service dashboards have empowered teams and replaced legacy reporting across the organization
What is our primary use case?
My main use case for Sigma is for enterprise dashboards, which is originally why I brought it in, and self-service analytics.
A quick and specific example of how I used Sigma for enterprise dashboards is that I built a centralized reporting dashboard for our marketing team.
My main use case for Sigma supports the entire organization, and one of the big reasons that I initially brought it in was I was able to connect it to our Snowflake environment and let one of our SVPs know that it was connected. Before I got a chance to really train her, she had set up her own dashboard. It was a comprehensive dashboard that had at least five tabs on it, and it was actually really good. I could not believe that she set it up by herself with no training.
What is most valuable?
The best features Sigma offers include the self-service functionality, which was a really big deal, as well as their very good data apps and integration with Snowflake. Sigma is also moving into the AI space, as a lot of companies are, and they are doing a really great job at it.
The data apps feature stands out for me because it was just more focused data that is easier to get to, not having to do just the regular dashboards.
Sigma has positively impacted my organization because we were able to retire an old enterprise reporting tool that was homegrown, which involved a lot of canned SQL and parameterized SQL, making it a lot easier for us.
After switching from our homegrown reporting tool to Sigma, we noticed that a set of employees were able to create their own dashboards, allowing other organizations within the company to really take off and not depend on BI after that. So that was one of the big things.
What needs improvement?
I think Sigma can be improved by continuing to do what they are doing in leaning into AI and leaning into the Snowflake integration with AI. All of the conversational features that they have recently rolled out are really great, and I think that is mainly it. It is about being able to hold people within the tight context of the data in the dashboard and being able to interact with it conversationally.
I cannot think of any needed improvements right now, even something minor.
For how long have I used the solution?
I have been using Sigma for three years.
What do I think about the scalability of the solution?
Sigma's scalability as our data or user base grows is very easy, especially with the organizations.
How are customer service and support?
Sigma's customer support is excellent, and that is actually one of the other reasons why we ended up going with Sigma, as we are able to hit the question mark and ask for support and get real live people that are very knowledgeable. Their support I really think is a 10 out of 10.
How would you rate customer service and support?
Positive
What other advice do I have?
For actual users, I find it very easy to get into and adopt Sigma.
Sigma's performance when handling large data sets or complex queries is wholly dependent on the Snowflake warehouse, so if we do not want to burn too many Snowflake credits, we keep it on a smaller warehouse. Usually, it is okay, which is mainly because what we are trying to do is also be careful with our Snowflake budget.
I think Sigma handles data security and compliance requirements for my organization really strongly since they integrate with Snowflake security as well.
I do not know that we really had any big integrations, but we did have a couple API integrations with some homegrown tools, and that went pretty smoothly. They have been getting much better at that.
I think the level of customization Sigma allows for dashboards and reports is very good and getting better, but the other big thing is really what they are heading towards with more of the data apps.
My advice for others looking into using Sigma is to make sure your data foundation is set. I just do not think it is a smart idea for any tool to go after your transactional data; you should at least have some sort of data model so that way you are not querying 10 years of data when you only need last month or last year.
I think Sigma is a very strong company, and I consider them one of the top vendors in the space. The only question that I would have is that I have not had a chance to look at some of the newer agentic, AI-only tools. I would rate this review as a 9 out of 10 overall.