A non-technical, user friendly analytics tool
September 21, 2019
A non-technical, user friendly analytics tool
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Sigma Computing
We use Sigma Computing to develop business reporting from our business analytics data. Sigma Computing effectively solved the problems of accessibility to the data and adoption of usage with our non-analyst users. Our front line managers found it to be very easy to use and understand because its interface modeled after simple spreadsheet sheet usage which they are already familiar with. Thu,s they did not need to learn the language of analytics to do more complex tasks like regressions and correlations.
Pros
- Simple spreadsheet-like user interface. If you know Excel or Google Docs, you can use Sigma Computing to do complex analysis.
- Flexible in that power users can narrow down result sets directly if they know how to do SQL, but SQL knowledge is not required to to analyze data.
- Easy to share completed reports and graphical data with teams, without requiring team members to have paid accounts.
Cons
- Because Sigma Computing sits directly on top of the analytics data warehouse it queries live data. Not the most efficient when it comes to speed and requires attention from data specialist to make sure the warehouse is optimized to support the queries.
- Access control is loosely governed. Meaning pretty much granular access to specific tables or schemas hard to manage. Sharing a report means granting implicit access to the source data.
- Change management is tricky. Renaming of tables means re-creating reports, rather than just being able to point existing reports at a new table.
- Adoption of data to make decisions and measure goals.
- Build-out of complex reports (regressions/cohort analysis) with relatively low levels of learning training; easy to use.
- Drive-up run time (cost) on data warehouse cluster usage; both good and bad in that there's more usage of the data, but also no caching so a lot of extra unnecessary queries being run.
Largely most of the tools we looked at have a per-user access model of pricing. So sharing out a report means making a static non-updating snapshot of it in an "exported" kind of way that is painful to make available to users who do not need actual access to use visualization tools. Because of this, the pricing models inflate the cost of the tool. This is not a consideration with Sigma Computing because "viewers" are not billable users.
The user experience on most of these is geared toward analyst users - we actually licensed these and tested many of them with our user base for several months. The onus is on the end-user to "bootstrap" themselves through training and documentation to understand how to use the tool. This was not necessary at all with Sigma Computing.
All of these employ some kind of a "caching" mechanism to keep the reporting "fast" which is, in fact, a desirable thing. But there's configurable refresh on many of them which are optimized to toward report generation speed rather than data freshness. In Sigma's case, it always re-fetches the data (which introduces different problems) so the data is always up to date.
The user experience on most of these is geared toward analyst users - we actually licensed these and tested many of them with our user base for several months. The onus is on the end-user to "bootstrap" themselves through training and documentation to understand how to use the tool. This was not necessary at all with Sigma Computing.
All of these employ some kind of a "caching" mechanism to keep the reporting "fast" which is, in fact, a desirable thing. But there's configurable refresh on many of them which are optimized to toward report generation speed rather than data freshness. In Sigma's case, it always re-fetches the data (which introduces different problems) so the data is always up to date.
Comments
Please log in to join the conversation