Google BigQuery Analytics - Softcover

Tigani, Jordan

Softcover

ISBN 10: 1118824822 ISBN 13: 9781118824825

Publisher: Wiley, 2014

Synopsis

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 this title

About the Author

The authors are founding members of the BigQuery team and have helped build and run the service. Jordan Tigani is an active participant in the BigQuery StackOverflow virtual community. Siddartha Naidu has extensive experience helping customers integrate with BigQuery.

From the Back Cover

Run complex queries and write code with BigQuery

If you’re a data analyst, developer, or data scientist, BigQuery can save you big time, allowing you to run complex queries over billions of records—and get answers in seconds. In Google BigQuery Analytics, you’ll learn how to use BigQuery effectively, avoid common pitfalls, and execute sophisticated queries against complex data sets. Explaining the hows and whys of BigQuery, this book gives expert advice to help you get your data in, get it out, and gain the most actionable insights from your analysis.

• Explains the details of authentication and communication with the BigQuery API
• Shows you how to get your data in and out of the service
• Demonstrates how to compose powerful queries from simple pieces
• Covers using the service from the Google Cloud Platform and from third-party tools
• Offers real-world examples that demonstrate current best practices and techniques
• Includes web application examples coded in Python, a popular language for big data analytics
• Features a companion website and public datasets that are used in the book

From the Inside Flap

Run complex queries and write code with BigQuery

If you’re a data analyst, developer, or data scientist, BigQuery can save you big time, allowing you to run complex queries over billions of records—and get answers in seconds. In Google BigQuery Analytics, you’ll learn how to use BigQuery effectively, avoid common pitfalls, and execute sophisticated queries against complex data sets. Explaining the hows and whys of BigQuery, this book gives expert advice to help you get your data in, get it out, and gain the most actionable insights from your analysis.

• Explains the details of authentication and communication with the BigQuery API
• Shows you how to get your data in and out of the service
• Demonstrates how to compose powerful queries from simple pieces
• Covers using the service from the Google Cloud Platform and from third-party tools
• Offers real-world examples that demonstrate current best practices and techniques
• Includes web application examples coded in Python, a popular language for big data analytics
• Features a companion website and public datasets that are used in the book

Edition details

• Publisher: Wiley
• Publication date: 2014
• Language: English
• ISBN 10: 1118824822
• ISBN 13: 9781118824825
• Binding: Paperback
• Edition number: 1
• Number of pages: 528