Good BigQuery: Speed, Scale, and Simplicity
February 03, 2025

Good BigQuery: Speed, Scale, and Simplicity

Umang Aggarwal | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Google BigQuery

I use Google BigQuery to run codes on Telecom customers to understand their connect and disconnect behavior. Some of the key business problems that I have solved using Google BigQuery is mapping geospatial data with zip/market zones to enhance our product sales by reaching the correct/targeted audience. Apart from this I use it to understand churn trends - why customers are moving/disconnecting, what's working, how to streamlines offers etc.

I also utilize it to understand demand and what is driving customers to take up an offer.

Pros

  • Ability to upload custom data set to use on Google BigQuery - especially when I have to use Longitude and latitude
  • Ability to handle large amount of data without affecting processing speeds
  • Ability to integrate with other cloud services like Google Data Studio, Google Sheets, and Google Cloud Machine Learning Engine. This makes it easier to build comprehensive data solutions within the Google Cloud ecosystem

Cons

  • Optimization: Google BigQuery can sometimes struggle with optimizing very complex queries, especially those involving multiple joins and subqueries.
  • Error/Failure check: It would be good to have a feature that can tell exactly where the coding issue would be along with suggesting some alternate codes - this will help give people an idea of what's wrong and what can we do about it
  • Has helped in building models that I can run iterations on
  • Has helped in streamlining processes and saving views that can be refurbished and used again
I have used most of the data analytics platforms. Based on my work, I have found that the user interface of Google BigQuery is simple to navigate. I like the front view - ease of joining tables, and integration with other platforms.

Do you think Google BigQuery delivers good value for the price?

Not sure

Are you happy with Google BigQuery's feature set?

Yes

Did Google BigQuery live up to sales and marketing promises?

Yes

Did implementation of Google BigQuery go as expected?

I wasn't involved with the implementation phase

Would you buy Google BigQuery again?

Yes

1. Complex Query Optimization Issues: Sometimes optimizing very complex queries involving multiple joins and subqueries becomes difficult and ends up taking time to process

2. Outside source data integration that works: Working on in-built libraries or data has helped me improve working, especially Zillow

Google BigQuery Feature Ratings

Database-as-a-Service
7.7
Database scalability
7
Database security provisions
8
Monitoring and metrics
8

Comments

More Reviews of Google BigQuery

  1. Home
  2. Database-as-a-Service (DBaaS)
  3. Google BigQuery Reviews
  4. User Review of Google BigQuery