Google BigQuery vs. ThoughtSpot

Google BigQuery is great for being the central datastore and entry point of data if you're on GCP. It seamlessly integrates with other Google products, meaning you can ingest data from other Google products with ease and little technical knowledge, and all of it is near real-time. Being serverless, BigQuery will scale with you, which means you don't have to worry about contention or spikes in demand/storage. This can, however, mean your costs can run away quickly or mount up at short notice.

Incentivized

By using the power of cloud platforms like bigquery or snowflake, ThoughtSpot can deliver performance at scale ensuring that even the largest organization can quickly analyze and visualize data. The ability to seamlessly share live dashboards fosters collaborations, ensuring everyone in the organization is working from the same data source and aligned in decision making.

Incentivized

• Its serverless architecture and underlying Dremel technology are incredibly fast even on complex datasets. I can get answers to my questions almost instantly, without waiting hours for traditional data warehouses to churn through the data.
• Previously, our data was scattered across various databases and spreadsheets and getting a holistic view was pretty difficult. Google BigQuery acts as a central repository and consolidates everything in one place to join data sets and find hidden patterns.
• Running reports on our old systems used to take forever. Google BigQuery's crazy fast query speed lets us get insights from massive datasets in seconds.

Incentivized

• Beautiful visualizations. The visuals are distinct, clean, and easy to discern from one another.
• Intelligent querying functionality. When looking to manipulate the data, the search function makes it easy to manipulate the features in the data, along with aggregating them in the way you'd like.
• Embedding! It has been a smooth process thus far for our product & technical teams to work with ThoughtSpot and bring it into our product.

Incentivized

• It is challenging to predict costs due to BigQuery's pay-per-query pricing model. User-friendly cost estimation tools, along with improved budget alerting features, could help users better manage and predict expenses.
• The BigQuery interface is less intuitive. A more user-friendly interface, enhanced documentation, and built-in tutorial systems could make BigQuery more accessible to a broader audience.

Incentivized

• It would be great if ThoughtSpot can add the feature to filter by clicking on visualizations. i.e if I click on a particular data point in the chart if the full dashboard can filter just for that particular data point.
• Color coding the heatmap with different colors like green to orange to red.

Incentivized

We have to use this product as its a 3rd party supplier choice to utilise this product for their data side backend so will not be likely we will move away from this product in the future unless the 3rd party supplier decides to change data vendors.

Incentivized

We have had success with the initial use cases and there are more use cases that can receive return on investment. I don't give it a 10 because other products like Tableau are building functionality that may start to compete in the coming years.

Incentivized

web UI is easy and convenient. Many RDBMS clients such as aqua data studio, Dbeaver data grid, and others connect. Range of well-documented APIs available. The range of features keeps expanding, increasing similar features to traditional RDBMS such as Oracle and DB2

The tool is easy to use if you know what you are doing and looking for. I know as they work towards improvements and simple language it will become even easier, but as of now they are doing a great job but there is room for improvement.

Incentivized

I have never had any significant issues with Google Big Query. It always seems to be up and running properly when I need it. I cannot recall any times where I received any kind of application errors or unplanned outages. If there were any they were resolved quickly by my IT team so I didn't notice them.

Incentivized

it's available unless there is a server or system update etc. sometimes the timing of this is bad (for example during a month end close)

Incentivized

I think Google Big Query's performance is in the acceptable range. Sometimes larger datasets are somewhat sluggish to load but for most of our applications it performs at a reasonable speed. We do have some reports that include a lot of complex calculations and others that run on granular store level data that so sometimes take a bit longer to load which can be frustrating.

Incentivized

It does what it is supposed to. Would be nice to have a bit more insights

Incentivized

BigQuery can be difficult to support because it is so solid as a product. Many of the issues you will see are related to your own data sets, however you may see issues importing data and managing jobs. If this occurs, it can be a challenge to get to speak to the correct person who can help you.

Incentivized

I give it this meeting because the team is not only help able to help us in the current solutions but also amazing and taking feedback and feeding it back to their development team which includes more products and features into ThoughtSpot

Incentivized

inhouse in-person training. Took a bit to long to get the basics.

Incentivized

poor instructions

Incentivized

Understand use case and model and design accordingly

Incentivized

Google BigQuery of course collects a much much larger array of raw data and can handle (practically) an unlimited amount of data. For a large enterprise like ours that relies on large-scale analytics, this is absolutely imperative. Google BigQuery can also combine GA4 data with external sources (like CRM tools), so our analytics can be unified. Due to our heavy reliance on GA4, Google BigQuery is the natural choice since it is a Google product and has better integration.

Incentivized

It is more flexible and PowerBI, easier work online, and share information with many users. Also the dashboards and beautiful, and the user experience is better. Performance used to be faster. We use Looker for different use cases but, when it comes to reporting and sharing information, ThoughSpot is much better.

Incentivized

We have continued to expand out use of Google Big Query over the years. I'd say its flexibility and scalability is actually quite good. It also integrates well with other tools like Tableau and Power BI. It has served the needs of multiple data sources across multiple departments within my company.

Incentivized

Because it is very reliable, inside the situation, we need strong internet connection to access a lot of data but easily never had any downtime except during the upgrades

Incentivized

• In some places, Google BigQuery has helped us save some money by avoiding the need for expensive infrastructure and reducing some of the operational costs.
• Scalability is up-to-date and really helpful in multiple places.
• Knowledge transfer is easy as it is very user-friendly, so the learning curve has been reduced.
• Also, it gives us more insights from our data, helping us make smarter decisions for our business.

Incentivized

• Time to market ROI is massive vs hiring the full-time dedicated team to build and maintain a frontend multi-tenant SaaS data viz product.
• It will be interesting to see over time how the advanced features play out in terms of usability and end value, such as Natural Search, which we are very excited about, and the machine learning tools.

Incentivized