Item: Google BigQuery
Rating: 10
Author: Anomita Chandra

Use Cases and Deployment Scope

Google Big Query is used by product and services department at my organization. It is used to maintain the various services like bookstore, market place, recreation etc. It is used to maintain the information about inventory, the various vendors and product details. Since it is serverless and can handle large datasets it gives us quick results , work with real time data and helps to handle transactional data.

Pros and Cons

Google BigQuery is column based, therefore it has high speed and easily accessible.
As I work with inventory related data, it gives me real time updates which helps to resolve many blocks which could cause problems if delayed.
Being serverless, it is easy to handle large size data.

Google BigQuery charge according to the quality of the code. So if it is long and lengthy and not the most efficient it can be costly.
The UI/UX is little difficult to use at the beginning on a small screen because of the layout.

Most Important Features

Serverless - My organization works on realtime data, therefore it helps to stay updated.
Columnbased - Since the data is columnbased, it doesn't take time to load the data.

Return on Investment

Positive - My organization has faced great profits and has trubleshooted many issues before hand because of the realtime data to work on. It keeps the data up to date.
Negative - As there are various Google BigQuer proficiency people in the organization. Some very experienced and some novice. It has a negative impact because people who are new write longer and inefficient codes so the company is charged more.

Alternatives Considered

SQL Server Business Intelligence Manager, Microsoft SQL Server and Snowflake

At my previous organization we used server based SQL server. There were days when the server was down and we couldn't work or access the data. This caused multiple reports and processes which were fed from the server to fail. Google BigQuery doesn't have such problems.

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

Tableau Desktop, Microsoft Azure, Microsoft Access

Likelihood to Recommend

Google BigQuery is suitable for scenarios where the dataset is large and needs to be analyzed based on real time data. Google BigQuer has been very useful when I was working on the inventory data for the bookstore. At the beginning of semester there was always high demand for school materials, this high demand caused a steady decline in the inventory. Getting updated real time helped us to restock the warehouse beforehand with products in higher demand and thereby led to higher sales.

Reasons to move to Column Based System - Google BigQuery!

Overall Satisfaction with Google BigQuery