Item: Google BigQuery
Rating: 9
Author: Adam Rooney

Overall Satisfaction with Google BigQuery

Use Cases and Deployment Scope

I think Google BigQuery is the perfect repository for all of our cleansed data to be used for analytics and determining trends. It's the perfect system to hook up to using a number of ETL tools and can be configured to be used by people with vastly differing technical skills, from someone that just needs to quickly get an overview of how something is doing with some collated stats, to someone that needs to do a deep dive into a particular area and work out any trends or issues.

Pros and Cons

Pros

Easy to use UI through the Google Cloud Platform
Preventing duplicated data from being instered
Integrating with ETL systems
Easily accessible and easy to use API

Cons

It could be easier to transform and delete data from Google BigQuery
A bit lacking in AI features
A built in hashing solution for data would be nice

Return on Investment

Insights and determining trends has helped steer the company in different and better ways we might not have before Google BigQuery
With poorly written queries or oversights it's very easy to accidentaly run expensive queries over and over again.
As we were using GCP for other features, it was great that Google BigQuery was included in the GCP suite as it means we didn't have to, and still feel no need to, search for alternatives

Alternatives Considered

Google Cloud Spanner, Microsoft SQL Server and Looker

In my opinion, Google BigQuery is custom made to be the best data lake system that is easy to use, scalas to fit any business size, has inbuilt security, as well as tools for data integrity. Although a few other tools have some of the same functionality, Google BigQuery is the only one to wrap it all into one big, tidy, easy to use package.

Key Insights

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

Yes

Are you happy with Google BigQuery's feature set?

Yes

Did Google BigQuery live up to sales and marketing promises?

I wasn't involved with the selection/purchase process

Did implementation of Google BigQuery go as expected?

Yes

Would you buy Google BigQuery again?

Yes

Other Software Used

Google Cloud Spanner, Postman, Microsoft Visual Studio Code, Agent Ransack, Notepad++, Snagit

Likelihood to Recommend

Google BigQuery was perfect when we needed to have it so every row of data going into Spanner was also duplicated into a more accessible and quieryable database like Google BigQuery. We had to clean the data on our side to remove any PII, unnecassary data, and unify some things, but for us, Google BigQuery was perfect as the tool to be the end point for the data. Any time you need to have a large dataset that will be accessed by a number of different people with different skillsets, I think Google BigQuery is perfect.

Google BigQuery Feature Ratings

Comments

Please log in to join the conversation

Google BigQuery, for all your big ideas.