BigQuery for Data Warehousing Managed Data Analysis in the Google Cloud

Create a data warehouse, complete with reporting and dashboards using Google’s BigQuery technology. This book takes you from the basic concepts of data warehousing through the design, build, load, and maintenance phases. You will build capabilities to capture data from the operational environment, a...

Full description

Bibliographic Details
Main Author: Mucchetti, Mark
Format: eBook
Language:English
Published: Berkeley, CA Apress 2020, 2020
Edition:1st ed. 2020
Subjects:
Online Access:
Collection: Springer eBooks 2005- - Collection details see MPG.ReNa
LEADER 02574nmm a2200253 u 4500
001 EB001903172
003 EBX01000000000000001066081
005 00000000000000.0
007 cr|||||||||||||||||||||
008 201006 ||| eng
020 |a 9781484261866 
100 1 |a Mucchetti, Mark 
245 0 0 |a BigQuery for Data Warehousing  |h Elektronische Ressource  |b Managed Data Analysis in the Google Cloud  |c by Mark Mucchetti 
250 |a 1st ed. 2020 
260 |a Berkeley, CA  |b Apress  |c 2020, 2020 
300 |a XXXV, 525 p. 99 illus  |b online resource 
505 0 |a Cloud Shell and Cloud SDK -- 23. Appendix B: Sample Project Charter 
653 |a Database Management 
653 |a Database management 
041 0 7 |a eng  |2 ISO 639-2 
989 |b Springer  |a Springer eBooks 2005- 
856 4 0 |u https://doi.org/10.1007/978-1-4842-6186-6?nosfx=y  |x Verlag  |3 Volltext 
082 0 |a 005.74 
520 |a Create a data warehouse, complete with reporting and dashboards using Google’s BigQuery technology. This book takes you from the basic concepts of data warehousing through the design, build, load, and maintenance phases. You will build capabilities to capture data from the operational environment, and then mine and analyze that data for insight into making your business more successful. You will gain practical knowledge about how to use BigQuery to solve data challenges in your organization. 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. You will: 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.