Overview
Explains how to load or stream your business data into BigQuery
Suggests innovative ways to engage with business stakeholders for the long run
Provides suggestions for enhancement of data analysis via machine learning
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents (23 chapters)
-
Building a Warehouse
-
Filling the Warehouse
-
Using the Warehouse
-
Maintaining the Warehouse
Keywords
About this book
BigQuery is a managed cloud platform from Google that provides enterprise data warehousing and reporting capabilities. Part I of this book shows you how to design and provision a data warehouse in the BigQuery platform. Part II teaches you how to load and stream your operational data into the warehouse to make it ready for analysis and reporting. Parts III and IV cover querying and maintaining, helping you keep your information relevant with other Google Cloud Platform services and advanced BigQuery. Part V takes reporting to the next level by showing you how to create dashboards to provide at-a-glance visual representations of your business situation. Part VI provides an introduction to data science with BigQuery, covering machine learning and Jupyter notebooks.
What You Will Learn
- Design a data warehouse for your project or organization
- Load data from a variety of external and internal sources
- Integrate other Google Cloud Platform services for more complex workflows
- Maintain and scale your data warehouse as your organization grows
- Analyze, report, and create dashboards on the information in the warehouse
- Become familiar with machine learning techniques using BigQuery ML
Who This Book Is For
Developers who want to provide business users with fast, reliable, and insightful analysis from operational data, and data analysts interested in a cloud-based solution that avoids the pain of provisioning their own servers.
Authors and Affiliations
About the author
Bibliographic Information
Book Title: BigQuery for Data Warehousing
Book Subtitle: Managed Data Analysis in the Google Cloud
Authors: Mark Mucchetti
DOI: https://doi.org/10.1007/978-1-4842-6186-6
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Professional and Applied Computing (R0), Apress Access Books
Copyright Information: Mark Mucchetti 2020
Softcover ISBN: 978-1-4842-6185-9Published: 01 October 2020
eBook ISBN: 978-1-4842-6186-6Published: 30 September 2020
Edition Number: 1
Number of Pages: XXXV, 525
Number of Illustrations: 99 b/w illustrations
Topics: Database Management