Google BigQuery

What differentiates Google BigQuery from other similar products?

Main reason would be that we use BigQuery to store our clients and company Google Analytics data, so we know that all of our important data is at one place and safe. Also BigQuery provides a "free version" while you store and work with a limited data, afterwards you only pay per TB or GB what you use, or store which is good.

What is your favorite aspect of this product?

Extremly easy to connect with already existing Google Projects. You dont need any senior expirience or programmers to help you. From Google Analytics administration you can straight connect it to BigQuery and start saving all of your important data quickly. Afterwards with a little coding/jquery expirience, you can search through you raw data, export them, whatever you like!

What do you dislike most about this product?

The whole package of BigQuery consist of many products and things to explore, so for the begginer it might be a bit confusing to find the right thing you need.

What recommendations would you give to someone considering this product?

It depends on what are you looking for, but if you need to save your data quickly, not paying anything extra and you are user of Google Analytics, BigQuery is a way to go, within few minutes or after 1 YT tutorial, you are capable of saving all of your raw data to work on it later on

What differentiates Google BigQuery from other similar products?

The amazingly fast processing of data and ability to export the data in various formats.

What is your favorite aspect of this product?

I can perform joins in huge tables and fetch huge amounts of data without being worried about the processing.

What do you dislike most about this product?

The latest update wherein they added the editor tabs. Although the editor tabs is great, it presents a lot of new bugs to this product.

What recommendations would you give to someone considering this product?

If you want some tasks to run on a daily basis in a specific time interval, use the schedule queries feature of this product which can be triggered using various means.

What differentiates Google BigQuery from other similar products?

BigQuery makes it easy to import data from various sources into a pre-defined schema and table. Rapid data access is one of the many strengths of this excellent data warehouse technology. Using a standard web browser, users can view and verify large amounts of data. The underlying engine always strives to improve query performance and grow as needed to achieve service-level agreements.

What is your favorite aspect of this product?

The data warehousing and real-time analytics functions are my favorites. I can export the ability to store massive amounts of information to spreadsheet programs like Google Sheets. My Google Data Studio reports required a data warehouse that could process large payments of information rapidly and efficiently. Since migrating to Google Big Query, we've seen instantaneous loading times and more agility across all data sets.

What do you dislike most about this product?

The price is the one thing I don't like, although compared to other cloud providers, BigQuery is reasonable. The sandbox environment of BigQuery only allows DML SQL commands, which limits its usefulness for learning. As my query grows in size, the BigQuery console's lag becomes more annoying. BigQuery doesn't support all the major SQL languages.

What recommendations would you give to someone considering this product?

To store and generate reports from our many syndicated data sources, I have taken advantage of Google Cloud and BigQuery. Tableau and other data visualization tools are used to access the functional and reporting levels of BigQuery. It's a great buy because it's simple to implement and use and works well with other programs to help with data analysis and visualization.