Analyze data at lightening speed @BigQuery
November 29, 2018
Analyze data at lightening speed @BigQuery
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Google BigQuery
BigQuery is a user platform designed to ingest, process and output large volumes of data. We use it to ingest data from Google Analytics and collate that data with other internal data systems by pushing them to BigQuery. BigQuery makes it possible to process a huge volume of data sessions and user levels in almost real-time and achieve personalization and optimized UX.
- Processing of huge volumes of data enabled us to provide strategic insights by understanding the facts and realities.
- Detailed Audience analysis enabled us to achieve better targeting for digital media and marketing campaigns
- Personalization: We are able to achieve personalization by marrying, stitching, and processing huge volume of data.
- SQL syntax is not exactly same as ANSI SQL so there is a learning curve. Traditional SQL queries cannot execute in BigQuery which limits portabiltiy of the code.
- Limitation on visualization: We can improve visualization in data studio by bringing in the ability to support complex functions/formulas such as Tableau can do.
- By using BigQuery for visualization and personalization, we were able to achieve 5% higher conversion rate.
Google BigQuery integrates seamlessly with Web Analytics data compared to the Azure cloud.
Google BigQuery integrates natively with different digital media platforms compared to Azure and AWs.
Google BigQuery integrates natively with different digital media platforms compared to Azure and AWs.