Try our new research platform with insights from 80,000+ expert users

Looker vs ThoughtSpot comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Looker
Ranking in Embedded BI
5th
Average Rating
8.0
Number of Reviews
19
Ranking in other categories
No ranking in other categories
ThoughtSpot
Ranking in Embedded BI
7th
Average Rating
7.6
Reviews Sentiment
7.2
Number of Reviews
8
Ranking in other categories
BI (Business Intelligence) Tools (17th), Data Visualization (11th)
 

Mindshare comparison

As of December 2024, in the Embedded BI category, the mindshare of Looker is 26.9%, up from 24.7% compared to the previous year. The mindshare of ThoughtSpot is 12.9%, up from 10.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Embedded BI
 

Featured Reviews

Subramani R - PeerSpot reviewer
The APIs are exposed at every level, so it's highly modular
Looker doesn't connect to Excel, which is a huge disappointment because a lot of data is presented in Excel. Also, it can't consume data directly from REST APIs, which is necessary. Looker needs to expand its horizons when it comes to data sources. The inability to connect to different data sources is hampering our use cases. Currently, it only has an ODBC connection that connects to a database. It needs to connect to other data sources, such as Excel, APIs and different platforms. You can't create very attractive visuals with the built-in features, but I think they're providing some extensions to develop different visualizations. Looker can't create multiple sheets. You can only create one dashboard. It's not that you're able to toggle through different sheets to navigate different visuals. It's just one and people have to scroll through the dashboard. So scrolling is not something that people generally like to do, rather than segregating them in multiple tabs of sheets.
Avirat Gaikwad - PeerSpot reviewer
It's great not having to write SQL queries but they lack custom visualization functionalities
The majority of issues we have are similar to those every visualization tool faces in the initial phase. Something like a customized visualization, which a lot of companies build for Power BI or Tableau isn't available in ThoughtSpot, or there are minimal options. That's something that I'd like to see in the next release. ThoughtSpot is essentially a query-based search engine where you can type your query and get the answer. If you don't have your data prepared well, your user won't understand what this search engine is for, or they won't get the right answer. So, it doesn't have that powerful query. We usually create models in DBT and then get that into ThoughtSpot as a worksheet.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"It is a pretty stable solution because it is a cloud-based product."
"With Looker, I have experienced benefits in terms of usability and shareability."
"It's quite effortless to navigate through various applications and review their updated data in real-time."
"The product is easy to use."
"The stability of Looker has been good since I have been using it. However, it depends on what components are being used."
"Looker allows you to generate the most optimal SQL queries in a DC through UI actions. We had signed a contract with Google Cloud to use BigQuery. That was the primary reason we adopted Looker. It works better with BigQuery than any other BI platform. We also like how this tool was developed. It was designed with an eye toward microservices architecture."
"We can centralize all our data models."
"I would rate the stability a ten out of ten. I didn't face any issues with stability."
"ThoughtSpot takes the modifying of existing reports out of our hands."
"It's easy to drill down or expand data to get more details right out of the box."
"I would say the return on investment is good. Whatever we invested, we got results. We have been finding it easy to use and onboard new use cases."
"The initial setup was very straightforward."
"The scalability is good."
"I like ThoughtSpot's search capabilities. You can also create custom analytics even if you aren't an experienced data analyst. We have users with no data analytics experience making some of the dashboards we've created, copying components, and customizing them to their specific use cases."
"It is easy to set up the solution."
"The ability to do ad hoc explorations of data has been most valuable."
 

Cons

"The visualization capability of the product is limited."
"The product does not have documented material."
"Looker doesn't connect to Excel, which is a huge disappointment because a lot of data is presented in Excel. Also, it can't consume data directly from REST APIs, which is necessary. Looker needs to expand its horizons when it comes to data sources. The inability to connect to different data sources is hampering our use cases. Currently, it only has an ODBC connection that connects to a database. It needs to connect to other data sources, such as Excel, APIs, and different platforms."
"Stability needs improvement."
"It needs to be more user-friendly."
"The integration with different databases must be improved."
"Integrations with other BI tools could be better."
"The main area of concern in Looker is probably related to blending the data from the different sources, including the data present internally in the company and on the cloud."
"If I want to order columns, this feature is not there."
"A customized visualization is lacking in this product."
"ThoughtSpot is a fairly new product, so some usability aspects aren't as mature as we'd like them to be. One example is their organizational methodology, like how objects are organized in their dashboards inside the product. They're all on a flat list, which works if you've got five or 10 dashboards. However, it's insufficient when you're a large enterprise with multiple groups looking at the same dashboards. It isn't organized well."
"The most difficult thing I found is that it only deals with the files and does not have direct connectivity to databases."
"I would like to see more flexibility in adding the pins. Currently, we have four different sizes in which I can add pins, but I would like to be able to resize my pins."
"In terms of features, I'd like to be able to pivot data - for example, going from rows to columns. It's not easy to do."
"The one area of the solution that I do hear needs improvement is on the visualization front."
"The dashboards could give you more ability to fine tune the appearance. You get a great deal more control over how something looks in Power BI than you do in ThoughtSpot."
 

Pricing and Cost Advice

"The price of Looker usually depends on the solution's provider, but it is usually cheaper than the other products in the market. Looker is offered at different prices for different companies."
"Looker is expensive and could be made better by reducing it."
"It is cheap."
"I do not have to make any payments to use the solution."
"It's not cheap, but it's not expensive for big companies."
"I give the pricing a six out of ten."
report
Use our free recommendation engine to learn which Embedded BI solutions are best for your needs.
824,053 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
37%
Computer Software Company
10%
Financial Services Firm
10%
Manufacturing Company
7%
Financial Services Firm
24%
Computer Software Company
11%
Manufacturing Company
10%
Healthcare Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Looker?
With Looker, I have experienced benefits in terms of usability and shareability.
What is your experience regarding pricing and costs for Looker?
I do not have to make any payments to use the solution. In the beginning, Looker may work fine for its users. If advanced users who have experience with BI tools use Looker, then they may find it t...
What needs improvement with Looker?
The visualization capability of the product is limited. From an improvement perspective, the product should have more visualization capability. I can't clean data in Looker, and if I try to do it, ...
What do you like most about ThoughtSpot?
It's easy to drill down or expand data to get more details right out of the box.
What is your experience regarding pricing and costs for ThoughtSpot?
I like the pricing structure. I get billed by how much data I put in, not how many people are looking at the data. It's better for me as I can control pricing a bit more easily.
What needs improvement with ThoughtSpot?
We'd like more flexibility with the calendar as our fiscal year does not align with the calendar year. We have to load or create our own custom calendar to actually need our fiscal year-end. With o...
 

Comparisons

 

Overview

 

Sample Customers

Yahoo!, Etsy, Kohler, Hipcamp, Hubspot, Kickstarter, Venmo, Dollar Shave Club, 600+ customer
Primary Capital Mortgage, Sterling Backcheck, RichRelevance, Rambus, Batteries Plus Bulbs
Find out what your peers are saying about Looker vs. ThoughtSpot and other solutions. Updated: October 2024.
824,053 professionals have used our research since 2012.