Google BigQuery Analytics

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

Table of Contents

Part I BigQuery Fundamentals
Chapter 1 The Story of Big Data at Google
Chapter 2 BigQuery Fundamentals
Chapter 3 Getting Started with BigQuery
Chapter 4 Understanding the BigQuery Object Model

Part II Basic BigQuery
Chapter 5 Talking to the BigQuery API
Chapter 6 Loading Data
Chapter 7 Running Queries
Chapter 8 Putting It Together

Part III Advanced BigQuery
Chapter 9 Understanding Query Execution
Chapter 10 Advanced Queries
Chapter 11 Managing Data Stored in BigQuery

Part IV BigQuery Applications
Chapter 12 External Data Processing
Chapter 13 Using BigQuery from Third-Party Tools
Chapter 14 Querying Google Data Sources