You're reading from Data Exploration and Preparation with BigQuery A practical guide to cleaning, transforming, and analyzing data for business insights

Product type Paperback

Published in Nov 2023

Publisher Packt

ISBN-13 9781805125266

Length 264 pages

Edition 1st Edition

Languages

SQL

Tools

BigQuery

Concepts

Data Analysis

Author (1):

Mike Kahn

View More author details

Table of Contents (21) Chapters

Preface

1. Part 1: Introduction to BigQuery FREE CHAPTER

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

Exploring BigQuery data with Google Sheets

If you are a Google Workspace or Google account user, you may be familiar with Google Sheets, the spreadsheet tool that allows users to input and manage data in a workbook with rows and columns. Google Sheets gives users the ability to easily connect or input data, create tables, charts, and graphs, and perform statistical analysis. Sheets is integrated with BigQuery, offering another option to explore your BigQuery data. Exploring BigQuery data in sheets can be a quick and productive option, especially for sharing findings.

Connecting to Sheets from BigQuery using Explore with Sheets

You may consider exporting your data to Google Sheets for further exploration and relationship analysis from within BigQuery. Select your table in the BigQuery Explorer pane and, in the table query pane, click the EXPORT button, then Explore with Sheets: