Database design and theory Books

Book SynopsisLeverage 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 DescriptionData 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 forThis 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 ContentsTable of Contents Introducing 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

Read more less

Book SynopsisEverything you need to know to apply data contracts and build a truly data-driven organization that harnesses quality data to deliver tangible business value Purchase of the print or Kindle book includes a free PDF eBook Key Features Understand data contracts and their power to resolving the problems in contemporary data platforms Learn how to design and implement a cutting-edge data platform powered by data contracts Access practical guidance from the pioneer of data contracts to get expert insights on effective utilization Book DescriptionDespite the passage of time and the evolution of technology and architecture, the challenges we face in building data platforms persist. Our data often remains unreliable, lacks trust, and fails to deliver the promised value. With Driving Data Quality with Data Contracts, you’ll discover the potential of data contracts to transform how you build your data platforms, finally overcoming these enduring problems. You’ll learn how establishing contracts as the interface allows you to explicitly assign responsibility and accountability of the data to those who know it best—the data generators—and give them the autonomy to generate and manage data as required. The book will show you how data contracts ensure that consumers get quality data with clearly defined expectations, enabling them to build on that data with confidence to deliver valuable analytics, performant ML models, and trusted data-driven products. By the end of this book, you’ll have gained a comprehensive understanding of how data contracts can revolutionize your organization’s data culture and provide a competitive advantage by unlocking the real value within your data.What you will learn Gain insights into the intricacies and shortcomings of today’s data architectures Understand exactly how data contracts can solve prevalent data challenges Drive a fundamental transformation of your data culture by implementing data contracts Discover what goes into a data contract and why it’s important Design a modern data architecture that leverages the power of data contracts Explore sample implementations to get practical knowledge of using data contracts Embrace best practices for the successful deployment of data contracts Who this book is forIf you’re a data engineer, data leader, architect, or practitioner thinking about your data architecture and looking to design one that enables your organization to get the most value from your data, this book is for you. Additionally, staff engineers, product managers, and software engineering leaders and executives will also find valuable insights.Table of ContentsTable of Contents A Brief History of Data Platforms Introducing Data Contracts How to Get Adoption in Your Organization Bringing Data Consumers and Generators Closer Together Embedding Data Governance What Makes Up a Data Contract A Contract-Driven Data Architecture A Sample Implementation Implementing Data Contracts In Your Organization Data Contracts in Practice

Read more less