Big Advantages to BigQuery
December 23, 2019
Big Advantages to BigQuery
Score 10 out of 10
Overall Satisfaction with Google BigQuery
Big Query is currently being used by several departments as well as IT to extract data, blend it with other data and to generate reports based on that data. It's being used to track customer journeys through our site, track different channel traffic conversions and to build out dashboards in Tableau.
- The computing used by BigQuery is dynamically distributed across compute resources so that you do not have to manage compute clusters.
- Big Query connects easily with Tableau so that you can analyze billions of rows in seconds using visual analysis tools without writing a single line of code.
- Although BigQuery machine learning gives you the option to control your geographic data, it only applies to the US, Asia, and Europe. Further expansion of this option to other parts of the world would be beneficial.
- You don’t need to install, provision, or set up anything with Big Query because it is managed. The downside being that you can’t use it outside of Google Cloud Platform.
- Big Query helps to analyze web traffic from different channels to optimize our message and conversion paths.
- We use BigQuery Data Transfer Service for Google Ads to automatically schedule and manage recurring load jobs for Google Ads reporting data.
Both BigQuery and Redshift are two comparable fully managed petabyte-scale cloud data warehouses. They’re similar in many ways, but you should consider their unique features and how they can contribute to an organization’s data analytics infrastructure. When considering which one to use, it is best to take advantage their free trial periods to run your tests. This way you'll be able to use your own results as well as compare them to third party benchmarks that closely make your own business, in order to determine the best cloud data warehouse.
BigQuery has exceeded our cloud data warehouse needs with features such as it inherits security features of Google Cloud Platform, it encrypts data by default for added security and Google Cloud DLP service supports BigQuery. Also, BigQuery natively supports streaming data, which is available for real-time analysis within a few seconds of the first streaming insertion into a table.
Do you think Google BigQuery delivers good value for the price?
Are you happy with Google BigQuery's feature set?
Did Google BigQuery live up to sales and marketing promises?
Did implementation of Google BigQuery go as expected?
Would you buy Google BigQuery again?
I use it primarily in place of Google Analytics in Tableau since we use Tableau for all of weekly and monthly reporting and dashboards. One of the many advantages is being able to access unfiltered data and unaggregated data. This allows us to accurately capture measures such as unique users across many different time frequencies, which you can only do at the yearly level with Google Analytics.