Item: Google BigQuery
Rating: 10
Author: Yatin Garg

Use Cases and Deployment Scope

Google BigQuery allows querying multiple datasets within seconds using Sql. It also helps optimise queries to get results quickly.We can preview data without incurring costs. Google BigQuery is a fully managed, serverless, super fast data warehouse with no equivalent in the cloud space. It also creates graph using the data to help generate insights and view trends.

Pros and Cons

Automatically optimises queries to fetch data quickly
Allows efficient management of data across multiple databases
The editor and query builder have a very intuitive interface that makes it easy to build new queries fast

Not able to search specific column fields using search functionality
Uploading database using excel is time consuming and error prone
The error message thrown while querying can be more customisable to correct the errors

Most Important Features

Managing data across multiple databases
Ability to create new databases and pre aggregates tables which are generated using scheduled queries
Speed of querying and optimisation

Return on Investment

Shortened time by 30% to draw out data insights
Increase in tech performance and speed by 20% due to correct data logging
Reduced cost of managing data across multiple databases

Alternatives Considered

Azure Data Explorer and MongoDB

Google BigQuery manages data like no one else. The light speed of running queries makes it a one stop solution. The editor and query builder also have a highly intuitive interface that makes it easy to build new queries fast. Google BigQuery can easily be integrated with other google products like gmail and drive allowing the team to get real time updates and actionables.

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?

Yes

Did implementation of Google BigQuery go as expected?

Yes

Would you buy Google BigQuery again?

Yes

Other Software Used

Spreadsheet.com, Grammarly, Slack

Likelihood to Recommend

Google BigQuery is a great way to manage data across multiple databases within the organisation. The speed of querying makes it highly valuable. The graphs and charts helps analyse the draw insights from the data effectively. We also get a real time understanding of how much time it will take to run the query. We can choose a highly customisable plan as per the need of the organisation to effectively manage the licensing and costs.

One stop solution for data management and fast querying

Overall Satisfaction with Google BigQuery