{"product_id":"data-exploration-and-preparation-with-bigquery-a-practical-guide-to-cleaning-transforming-and-analyzing-data-for-business-insights-paperback","title":"Data Exploration and Preparation with BigQuery: A practical guide to cleaning, transforming, and analyzing data for business insights - Paperback","description":"\u003cp\u003eby \u003cb\u003eMike Kahn\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eLeverage BigQuery to understand and prepare your data to ensure that it's accurate, reliable, and ready for analysis and modeling\u003c\/strong\u003e\u003c\/p\u003eKey Features\u003cul\u003e\n\u003cli\u003eUse mock datasets to explore data with the BigQuery web UI, bq CLI, and BigQuery API in the Cloud console\u003c\/li\u003e\n\u003cli\u003eMaster optimization techniques for storage and query performance in BigQuery\u003c\/li\u003e\n\u003cli\u003eEngage with case studies on data exploration and preparation for advertising, transportation, and customer support data\u003c\/li\u003e\n\u003cli\u003ePurchase of the print or Kindle book includes a free PDF eBook\u003c\/li\u003e\n\u003c\/ul\u003eBook Description\u003cp\u003eData 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.\u003c\/p\u003e\u003cp\u003eThe 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.\u003c\/p\u003e\u003cp\u003eThe 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.\u003c\/p\u003e\u003cp\u003eBy 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.\u003c\/p\u003eWhat you will learn\u003cul\u003e\n\u003cli\u003eAssess the quality of a dataset and learn best practices for data cleansing\u003c\/li\u003e\n\u003cli\u003ePrepare data for analysis, visualization, and machine learning\u003c\/li\u003e\n\u003cli\u003eExplore approaches to data visualization in BigQuery\u003c\/li\u003e\n\u003cli\u003eApply acquired knowledge to real-life scenarios and design patterns\u003c\/li\u003e\n\u003cli\u003eSet up and organize BigQuery resources\u003c\/li\u003e\n\u003cli\u003eUse SQL and other tools to navigate datasets\u003c\/li\u003e\n\u003cli\u003eImplement best practices to query BigQuery datasets\u003c\/li\u003e\n\u003cli\u003eGain proficiency in using data preparation tools, techniques, and strategies\u003c\/li\u003e\n\u003c\/ul\u003eWho this book is for\u003cp\u003eThis 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.\u003c\/p\u003eTable of Contents\u003col\u003e\n\u003cli\u003eIntroducing BigQuery and Its Components\u003c\/li\u003e\n\u003cli\u003eBigQuery Organization and Design\u003c\/li\u003e\n\u003cli\u003eExploring Data in BigQuery\u003c\/li\u003e\n\u003cli\u003eLoading and Transforming Data\u003c\/li\u003e\n\u003cli\u003eQuerying BigQuery Data\u003c\/li\u003e\n\u003cli\u003eExploring Data with Notebooks\u003c\/li\u003e\n\u003cli\u003eFurther Exploring and Visualizing Data\u003c\/li\u003e\n\u003cli\u003eAn Overview of Data Preparation Tools\u003c\/li\u003e\n\u003cli\u003eCleansing and Transforming Data\u003c\/li\u003e\n\u003cli\u003eBest Practices for Data Preparation, Optimization, and Cost Control\u003c\/li\u003e\n\u003cli\u003eHands-On Exercise - Analyzing Advertising Data\u003c\/li\u003e\n\u003cli\u003eHands-On Exercise Analyzing Transportation Data\u003c\/li\u003e\n\u003cli\u003eHands-On Exercise - Analyzing Customer Support Data\u003c\/li\u003e\n\u003cli\u003eSummary and Future Directions\u003c\/li\u003e\n\u003c\/ol\u003e\u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 264\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.55 x 9.25 x 7.5 IN\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e November 29, 2023\u003c\/div\u003e","brand":"Books by splitShops","offers":[{"title":"Default Title","offer_id":42727272120383,"sku":"9781805125266","price":63.91,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0105\/8226\/1823\/files\/ffd88ef8cc61ab40f0d36e370cbdf75a.webp?v=1765114184","url":"https:\/\/dhlswag.com\/products\/data-exploration-and-preparation-with-bigquery-a-practical-guide-to-cleaning-transforming-and-analyzing-data-for-business-insights-paperback","provider":"BBB","version":"1.0","type":"link"}