Data Exploration and Preparation with BigQuery  (English, Paperback, Kahn Mike)

Learn to understand and prepare data using BigQuery to make your data accurate, reliable, and ready for analysis and modelingKey FeaturesExplore data with the BigQuery web UI, bq CLI, and BigQuery API in cloud console using mock datasetOptimizing storage and query performance techniques in BigQueryCase study on data exploration and preparation for advertising, transportation, and support dataBook DescriptionData 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 learnAssess the quality of a dataset and learn best practices for data cleansingPrepare data for data analysis, visualization, and for machine learningApproaches to visualize data in BigQueryApply lessons learned with real-life scenarios and design patternSetup and organize BigQuery resourcesUse SQL and other tools to explore datasetsBest practices for querying BigQuery datasetsUnderstand data preparation tools, techniques, and strategiesWho this book is forThis 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