ThoughtSpot - from a user/admin perspective
February 06, 2018

ThoughtSpot - from a user/admin perspective

Jason Westenskow | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with ThoughtSpot

We are using ThoughtSpot throughout the organization. I've personally trained our call center supervisors in the use of the tool along with retraining our corporate users repeatedly. I am the in-house expert on ThoughtSpot.

Our main use case is research and ad-hoc exploration. Tasks that would take hours to days previously are completed within 1/2 hour and span millions of rows of data in the process. Specifically, we are speeding up our access to data (user license limitations are removed with ThoughtSpot) and speed of insight (e.g. ad hoc exploration).
  • Millions of rows via in-memory database creates quick-insight/access to data
  • No user license restrictions (license is based on data loaded to the instance)
  • Easy Google-like interface for querying data
  • Simply put, ThoughtSpot is a new product. formatted/pixel-perfect reports are not what ThoughtSpot is good at.
  • Limited app-level administration controls.
  • Limited in allowing modification to "loaded" tables. For example, a DBA likes fields in a proper order. ThoughtSpot relies heavily on unchanged table structures (assigned by guide) and so new field adds must be added to the end or all relationships and reports are invalidated. This is not the end of the world.
In ad-hoc reporting...ThoughtSpot is superior in speed-to-results. The other products are capable, however, they require SQL coding and setup that ThoughtSpot only requires on initial load of data. Both PowerBI and ThoughtSpot use a text-based "natural language" query engine, however, PowerBI forces the user within a very narrow dataset path, whereas ThoughtSpot will allow broad queries across all tables (just don't select any data sources).
We've not found a limitation here. However, we've elected to bypass the ODBC connectors and scheduled cron job loaders from flat-files.
Sharing is simply achieved. Once the report, answer, and pinboard, are built, a few more clicks and you can pick who (1 to many users and or groups) to share the results with.
ThoughtSpot is great for data exploration. As long as your data can be connected via primary key / foreign key relationships (no referential integrity is enforced - it's a relationship). Starting from the raw tables, a user can comb through millions of rows of data and use both simple and complex formulas to break up the results.

ThoughtSpot is not built for pixel-perfect reporting. Don't plan on using this as a wholesale replacement for financial reporting - unless you're willing to forgo the normal report structure.

ThoughtSpot Feature Ratings

Customizable dashboards
9
Drill-down analysis
10
Formatting capabilities
8
Report sharing and collaboration
9
Publish to Web
9
Publish to PDF
9
Report Delivery Scheduling
7
Delivery to Remote Servers
7
Pre-built visualization formats (heatmaps, scatter plots etc.)
10
Location Analytics / Geographic Visualization
10
Multi-User Support (named login)
10
Role-Based Security Model
9
Multiple Access Permission Levels (Create, Read, Delete)
9
Single Sign-On (SSO)
10
Responsive Design for Web Access
4
Dashboard / Report / Visualization Interactivity on Mobile
4
REST API
10
Javascript API
10
Java API
10
Themeable User Interface (UI)
10
Customizable Platform (Open Source)
Not Rated