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

Introduction to exploring data in BigQuery

BigQuery offers a variety of features that make it easy to explore data. The approaches and tools described in this section can be used in parallel and by preference. You can use each of these tools in any order you would like, and it is encouraged to have knowledge and experience with each, so you have the flexibility to choose what works best for you. The BigQuery web UI is the best way to get started with exploring data. It is a web-based interface that allows you to import, modify, and query your data. The BigQuery page in the Cloud console is fully featured and most data analytics teams will spend a lot of time there. In this section, we will continue to use the Google Trends public dataset to introduce practices around data exploration.

Exploring data in the BigQuery SQL workspace

The SQL workspace (refer to Figure 3.1) is the main view where you can open multiple tabs, view datasets, and begin your data exploration journey. You...