Data Exploration and Preparation with BigQuery: A practical guide to cleaning, transforming, and analyzing data for business insights - Softcover

Mike Kahn

Softcover

ISBN 10: 1805125265 ISBN 13: 9781805125266

Publisher: Packt Publishing, 2023

Synopsis

Learn to understand and prepare data using BigQuery to make your data accurate, reliable, and ready for analysis and modeling

Key Features

• Explore data with the BigQuery web UI, bq CLI, and BigQuery API in cloud console using mock dataset
• Optimizing storage and query performance techniques in BigQuery
• Case study on data exploration and preparation for advertising, transportation, and support data

Book Description

Data professionals today encounter challenges including handling large volumes of data, dealing with data silos, and lacking appropriate tools. Datasets often arrive in different conditions and formats, demanding considerable time from analysts, engineers, and scientists to process and uncover insights. The complexity of the data lifecycle often hinders teams and organizations from extracting the desired value from their data.

Data Exploration & Preparation with BigQuery will help in addressing these challenges. The book begins with the basics of BigQuery while covering the fundamentals of data exploration and preparation. The book then progresses to demonstrate how BigQuery can be used for data exploration and preparation and explain the various big data tools available on Google Cloud. The book will further teach you to properly shape your tables for query efficiency and best practices for data preparation. You will also learn about when to use Dataflow, BigQuery, and Dataprep for ETL. The book will give you a walkthrough of various case studies that demonstrate how BigQuery can be used to solve real-world data problems.

By the end of this book, Readers are expected to be able to use SQL to explore and prepare datasets in BigQuery to unlock insights from data.

What you will learn

• Assess the quality of a dataset and learn best practices for data cleansing
• Prepare data for data analysis, visualization, and for machine learning
• Approaches to visualize data in BigQuery
• Apply lessons learned with real-life scenarios and design pattern
• Setup and organize BigQuery resources
• Use SQL and other tools to explore datasets
• Best practices for querying BigQuery datasets
• Understand data preparation tools, techniques, and strategies

Who This Book Is For

This book is for data analysts who want to learn how to explore and prepare data using BigQuery. Readers are expected to have a basic understanding of SQL, reporting, data modeling, and transformations. Moreover, this is an excellent guide for anyone who plans on using BigQuery as a data warehouse to provide insights to their business from large data sets

Table of Contents

1. BigQuery and Data Exploration and Preparation Introduction
2. BigQuery Design and Organization
3. Exploring Data in BigQuery
4. Loading and Transforming Data
5. Querying BigQuery Data
6. Exploring Data with Notebooks
7. Exploring and Visualizing Data
8. Data Preparation Tools
9. Cleansing and Transforming Data
10. Data Preparation and Cost Control Best Practices
11. End to End Use Case for Advertising Data
12. End to End Use Case for Transportation Data
13. End to End Use Case for Customer Support Data
14. Summary of Key points, Future Directions, Resources

About this title

About the Author

Mike Kahn is a data and infrastructure enthusiast and currently leads a Customer Engineering team at Google Cloud. Prior to Google, Mike spent five years in solution architecture roles and worked in operations and leadership roles in the data center industry. His over 15 years of experience have given him a deep knowledge of data and infrastructure engineering, operations, strategy, and leadership. Mike holds multiple Google Cloud certifications and is a lifelong learner. He is based in Boca Raton, Florida, in the US and holds a Bachelor of Science degree in Management Information Systems (MIS) from University of Central Florida and a Master of Science degree in MIS from Florida International University.

From the Back Cover

Leverage BigQuery to understand and prepare your data to ensure that it's accurate, reliable, and ready for analysis and modelingKey FeaturesUse mock datasets to explore data with the BigQuery web UI, bq CLI, and BigQuery API in the Cloud console Master optimization techniques for storage and query performance in BigQuery Engage with case studies on data exploration and preparation for advertising, transportation, and customer support data Purchase of the print or Kindle book includes a free PDF eBook Book Description Data professionals encounter a multitude of challenges such as handling large volumes of data, dealing with data silos, and the lack of appropriate tools. Datasets often arrive in different conditions and formats, demanding considerable time from analysts, engineers, and scientists to process and uncover insights. The complexity of the data life cycle often hinders teams and organizations from extracting the desired value from their data assets. Data Exploration and Preparation with BigQuery offers a holistic solution to these challenges. The book begins with the basics of BigQuery while covering the fundamentals of data exploration and preparation. It then progresses to demonstrate how to use BigQuery for these tasks and explores the array of big data tools at your disposal within the Google Cloud ecosystem. The book doesn't merely offer theoretical insights; it's a hands-on companion that walks you through properly structuring your tables for query efficiency and ensures adherence to data preparation best practices. You'll also learn when to use Dataflow, BigQuery, and Dataprep for ETL and ELT workflows. The book will skillfully guide you through various case studies, demonstrating how BigQuery can be used to solve real-world data problems. By the end of this book, you'll have mastered the use of SQL to explore and prepare datasets in BigQuery, unlocking deeper insights from data.What you will learnAssess the quality of a dataset and learn best practices for data cleansing Prepare data for analysis, visualization, and machine learning Explore approaches to data visualization in BigQuery Apply acquired knowledge to real-life scenarios and design patterns Set up and organize BigQuery resources Use SQL and other tools to navigate datasets Implement best practices to query BigQuery datasets Gain proficiency in using data preparation tools, techniques, and strategies Who this book is for This book is for data analysts seeking to enhance their data exploration and preparation skills using BigQuery. It guides anyone using BigQuery as a data warehouse to extract business insights from large datasets. A basic understanding of SQL, reporting, data modeling, and transformations will assist with understanding the topics covered in this book.Table of ContentsIntroducing BigQuery and Its Components BigQuery Organization and Design Exploring Data in BigQuery Loading and Transforming Data Querying BigQuery Data Exploring Data with Notebooks Further Exploring and Visualizing Data An Overview of Data Preparation Tools Cleansing and Transforming Data Best Practices for Data Preparation, Optimization, and Cost Control Hands-On Exercise - Analyzing Advertising Data Hands-On Exercise Analyzing Transportation Data Hands-On Exercise - Analyzing Customer Support Data Summary and Future Directions

Edition details

• Publisher: Packt Publishing
• Publication date: 2023
• Language: English
• ISBN 10: 1805125265
• ISBN 13: 9781805125266
• Binding: Paperback
• Number of pages: 125