Data Exploration and Preparation with BigQuery
eBook - ePub

Data Exploration and Preparation with BigQuery

A practical guide to cleaning, transforming, and analyzing data for business insights

Mike Kahn

Share book
  1. 264 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

Data Exploration and Preparation with BigQuery

A practical guide to cleaning, transforming, and analyzing data for business insights

Mike Kahn

Book details
Table of contents

About This Book

Leverage BigQuery to understand and prepare your data to ensure that it's accurate, reliable, and ready for analysis and modeling

Key Features

  • Use 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 learn

  • Assess 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.


Frequently asked questions

How do I cancel my subscription?
Simply head over to the account section in settings and click on “Cancel Subscription” - it’s as simple as that. After you cancel, your membership will stay active for the remainder of the time you’ve paid for. Learn more here.
Can/how do I download books?
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
What is the difference between the pricing plans?
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
What is Perlego?
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Do you support text-to-speech?
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Is Data Exploration and Preparation with BigQuery an online PDF/ePUB?
Yes, you can access Data Exploration and Preparation with BigQuery by Mike Kahn in PDF and/or ePUB format, as well as other popular books in Computer Science & Data Warehousing. We have over one million books available in our catalogue for you to explore.



Table of contents