You're reading from Data Exploration and Preparation with BigQuery

Product type Book

Published in Nov 2023

Publisher Packt

ISBN-13 9781805125266

Pages 264 pages

Edition 1st Edition

Languages

Concepts

Data Analysis

Author (1):

Mike Kahn

Table of Contents (21) Chapters

Preface

1. Part 1: Introduction to BigQuery

2. Chapter 1: Introducing BigQuery and Its Components

3. Chapter 2: BigQuery Organization and Design

4. Part 2: Data Exploration with BigQuery

5. Chapter 3: Exploring Data in BigQuery

6. Chapter 4: Loading and Transforming Data

7. Chapter 5: Querying BigQuery Data

8. Chapter 6: Exploring Data with Notebooks

9. Chapter 7: Further Exploring and Visualizing Data

10. Part 3: Data Preparation with BigQuery

11. Chapter 8: An Overview of Data Preparation Tools

12. Chapter 9: Cleansing and Transforming Data

13. Chapter 10: Best Practices for Data Preparation, Optimization, and Cost Control

14. Part 4: Hands-On and Conclusion

15. Chapter 11: Hands-On Exercise – Analyzing Advertising Data

16. Chapter 12: Hands-On Exercise – Analyzing Transportation Data

17. Chapter 13: Hands-On Exercise – Analyzing Customer Support Data

18. Chapter 14: Summary and Future Directions

19. Index

Why subscribe?

20. Other Books You May Enjoy

Summary of key points

Let’s revise our chapter-wise journey in this book right from the beginning in the following sections, which contain a list of key points from each chapter.

Chapter 1, Introducing BigQuery and Its Components

BigQuery is a fully managed, serverless data warehouse that enables users to analyze data with SQL.
BigQuery uses a columnar format that is optimized for analytics queries on structured and semi-structured data.
You can use common SQL queries to analyze data in BigQuery, as BigQuery supports a standard SQL dialect known as GoogleSQL.
There are several access methods for administration tasks in BigQuery, including the Google Cloud console, the bq command-line tool, and the BigQuery API.
Role-based access control (RBAC) is used to secure data and resources. You can control access to rows as well as views.
There are two pricing models: on-demand analysis and capacity pricing (BigQuery Editions), offering predictable pricing...