Item: Google BigQuery
Rating: 9
Author: Verified User

Use Cases and Deployment Scope

We are using Google BigQuery to store all events data of our app and Since our events data are recorded every second wise so it's a large data set of events that are easily handled by Google BigQuery since Google BigQuery has minimal charges for storage and mainly it will charge for running the query inside the Google BigQuery so it will be very easy for us to store a large database in Google BigQuery.

Pros and Cons

Store Large data set
Very minimal Charge for Storage
You can write SQL queries on Google BigQuery

There is no training module for Google BigQuery for that reason newcomers will face problems with the user interface and not be familiar with the syntax of SQL query format of Google BigQuery
There are some functions which are only used in Google BigQuery which I feel difficult to understand and no one is there for you on how it will work so I think there should be some customer support team would be there where you can raise your concerns with the team.

Return on Investment

For Storage Purpose It saves a lot of cost compared to other tools
They provide multi functionality like you can do SQL query on your data
You can also build your dashboard on your data sets which you have uploaded on Google BigQuery with the help of Google Data Studio since both are of Google Products they are already interlinked with each other.

Alternatives Considered

Zoho Analytics, MoEngage and Amazon Redshift

Cost is the important factor for us compared with all of the other tools Google BigQuery stands top among all of them which charges very minimal charges for storage against all the apps that we have liked the most additionally, we can do query on our data, and can build dashboard on Google data Studio so we that's why we have preferred Google BigQuery against all of the other apps.

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

Looker Studio, Google Cloud Dataflow, Zoho People

Likelihood to Recommend

As previously mentioned Google BigQuery is perfect for storage of you have large data sets since they are charging very minimal charge for storage but they will charge for every single query that you run on Google BigQuery so if you have large data sets then go for it. If you want to do query on the data then Google BigQuery will already provide and you can also build the dashboard with your data on Google Data Studio.

Store & Analyze your data with Google BigQuery

Overall Satisfaction with Google BigQuery