Google BigQuery Analytics
- 9h 10m
- Jordan Tigani, Siddartha Naidu
- John Wiley & Sons (US)
- 2014
How to effectively use BigQuery, avoid common mistakes, and execute sophisticated queries against large datasets
Google BigQuery Analytics is the perfect guide for business and data analysts who want the latest tips on running complex queries and writing code to communicate with the BigQuery API. The book uses real-world examples to demonstrate current best practices and techniques, and also explains and demonstrates streaming ingestion, transformation via Hadoop in Google Compute engine, AppEngine datastore integration, and using GViz with Tableau to generate charts of query results. In addition to the mechanics of BigQuery, the book also covers the architecture of the underlying Dremel query engine, providing a thorough understanding that leads to better query results.
- Features a companion website that includes all code and data sets from the book
- Uses real-world examples to explain everything analysts need to know to effectively use BigQuery
- Includes web application examples coded in Python
About the Authors
Jordan Tigani has more than 15 years of professional software development experience, the last 4 of which have been spent building BigQuery. Prior to joining Google, Jordan worked at a number of star-crossed startups. The startup experience made him realize that you don't need to be a big company to have Big Data. Other past jobs have been in Microsoft Research and the Windows kernel team.
Siddartha Naidu joined Google after finishing his doctorate degree in Physics. At Google he has worked on Ad targeting, newspaper digitization, and for the past 4 years on building BigQuery. Most of his work at Google has revolved around data; analyzing it, modeling it, and manipulating large amounts of it. When he is not working on SQL recipes, he enjoys inventing and trying the kitchen variety. He currently lives in Seattle with his wife, Nitya, and son, Vivaan, who are the subjects of his kitchen experiments, and when they are not traveling, they are planning where to travel to next.
In this Book
-
The Story of Big Data at Google
-
BigQuery Fundamentals
-
Getting Started with BigQuery
-
Understanding the BigQuery Object Model
-
Talking to the BigQuery API
-
Loading Data
-
Running Queries
-
Putting It Together
-
Understanding Query Execution
-
Advanced Queries
-
Managing Data Stored in BigQuery
-
External Data Ocessing
-
Using BigQuery from Third-Party Tools
-
Querying Google Data Sources
