Google BigQuery enables companies to handle large amounts of data without having to manage infrastructure. Google’s documentation describes it as a « serverless architecture (that) lets you use SQL queries to answer your organization’s biggest questions with zero infrastructure management. BigQuery’s scalable, distributed analysis engine lets you query terabytes in seconds and petabytes in minutes. » Its client libraries allow the use of widely known languages such as Python, Java, JavaScript, and Go. Federated queries are also supported, making it flexible to read data from external sources.
📖 A highly rated canonical book on it is « Google BigQuery: The Definitive Guide », a comprehensive reference.
Another enriching read on the subject is the inside story told in the article by the founding product manager of BigQuery celebrating its 10th anniversary.
⚙️ Código de manutenção do datalake (metadados e pacotes de acesso) | 📖 Docs: https://basedosdados.org/docs/home
Case study under capstone project of Google Data Analytics Certificate
Leveraged Big Query and MySQL to analyze 100K records for sales optimization, trend identification, and enhancing customer satisfaction for a retail brand in South America and to provide insights and recommendations to improve their userbase and improve their services
Airbnb Jersey City Case Study! Optimize the revenue by its active listings.
SaaS deal desk analytics using BigQuery, SQL, and Looker Studio
This case study simulates the real-world experience of a junior data analyst at Cyclistic, a fictional company. We will leverage the data analysis process framework (Ask, Prepare, Process, Analyze, Share, Act) to address critical business questions and provide data-driven insights to guide strategic decision-making.
Este repositório reúne consultas SQL práticas usadas em estratégias de CRM e Growth 🚀
Random forest regression + ARIMA timeseries modeling to impute metric values and forecast revenue for reporting purposes.
Derive actionable insights from two datasets — Global AI Impact and AI Job Market Insights — to inform strategy on AI adoption, market dynamics, and talent planning across countries and industries.
A BigQuery SQL query that can be used to visualize user paths that lead to a conversion, e.g. a sale, on a website or an app
Using BigQuery ML; create a machine learning model to recognize the US accent from within six other accents
Analyze the Chicago Crime Dataset using SQL queries in Google BigQuery to uncover insights and trends, supporting informed decision-making for law enforcement and community stakeholders.
Cyclistic bike-share analysis case study! design a new marketing strategy to convert casual riders into annual members.
Google Data Analytics Capstone Project
Objective is to build a web service to host an interactive dashboard of any given service and city of the end user's choice using Tableau Desktop
Released May 19, 2010