Google BigQuery Analytics (Paperback)

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

《Google BigQuery Analytics》是一本完美的指南，針對希望運行複雜查詢並編寫與BigQuery API通信的代碼的業務和數據分析師提供最新的技巧。本書使用實際案例來演示當前的最佳實踐和技巧，並解釋和演示通過Google Compute Engine中的Hadoop進行流式摄取、轉換、AppEngine數據存儲集成以及使用GViz和Tableau生成查詢結果的圖表。除了BigQuery的操作方式外，本書還介紹了底層Dremel查詢引擎的架構，從而提供了更好的查詢結果的全面理解。

本書還包括一個附帶網站，其中包含了書中的所有代碼和數據集。使用實際案例來解釋分析師需要了解的一切，以有效地使用BigQuery。書中還包括使用Python編寫的Web應用程序示例。