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

Visualizing BigQuery data using Looker Studio

Visualizing data is an essential step in your data exploration and analysis work. It allows you to gain insights, discover patterns, and communicate findings to stakeholders. We will use Looker Studio (https://cloud.google.com/looker-studio), formally known as Data Studio, in this section. Looker Studio enables an out-of-the-box native integration to BigQuery and makes it easy to visualize data quickly. It is free to use with any Google account and easy to share reports and enable collaboration if your organization uses Google Workspace.

Creating the right visualizations

Choosing the right visualization approach is important in communicating insights and patterns hidden within your BigQuery data. The appropriate visualization technique can bring clarity to complex datasets, highlight trends, and aid in decision-making. Before creating visualizations, it is essential to have a clear understanding of your data and the objectives you...