This book shows business and data analysts how to use bigquery most effectively, avoid common pitfalls, and ultimately execute sophisticated queries against large, complex data sets. the authors will share tips and recipes for running complex queries. and they will also show how to write code to communicate with the bigquery api. the authors will demonstrate best practices and techniques againstan extended real-world example -- a web application that collects sensor data from mobile devices and displays a dashboard visualizing the data in real-time. along the way, the authors will use examples to demonstrate streaming ingestion, transformation via hadoop in google compute engine, appengine datastore integration, and using gviz with tableau to generate charts of query results.the authors will not just cover the mechanics of using bigquery; they will also cover the architecture of the underlying dremel query engine:understanding how a query will execute is a key to getting good results from bigquery.